I am a new SAS user and I had similar problem with numbers with commas. What I did was to copy and paste the log part of the Proc Import into my program. That was basically a data step. Then, I modified the formats and informats for the variables of interest. The program worked well. Hope that helps. -Taha ... View more

Hi LinLIn, Unfortunately I cannot make your code running in a way I want. For some reason sas insert sas data not in the range I specified in excel file. I named a selected range in the excel file as table1 ($C$4:$E$7)and use this as a reference in the data step in sas. It does not work. The sas data are placed in the range $A$1:$C$4 instead of where I want it. Any ideas why is that? Here is my sas code: libname myxls '..path..\My work book.xls'; data myxls.table1; set FreqCount; run; libname myxls clear; Thank you! ... View more

Tom/Art Thanks guys. I knew that I was missing something obvious. We did look at other informats including anydtdte but there are some pretty obscure values that this doesn't work for. ... View more