The Little Engine That Could: Using EXCEL LIBNAME Engine Options to Enhance Data Transfers between S

LIBNAME xls_data EXCEL ‘C:\WUSS_2009\My_Excel_File.xls’ HEADER=NO MIXED=YES; Data test1; Set xls_data.’sheet1’n; x = input(F4,10.0); * convert to numeric values; if x = . then y = input(F4,$char25.); * if conversion fails, convert; * to ...

www.wuss.org