Hi all,
I am currently running SAS v9.3 on a 64-bit OS, I am using the following code to import data from an Excel file. The file contains 275 columns (variables) but only the first 255 are getting imported. I've read previous discussions on this and it seems like this shouldn't be an issue with version 9.3. Is my code missing something? I have tried adding the option "version='2007';" but it was not successful.
Thanks in advance for any help someone can offer!
proc import datafile='V:\ProjectDirectory\DatafileName.xlsx' out=getdata replace dbms=excelcs;
sheet='SASInput';
usedate=no;
scantime=yes;
run;
proc contents data=getdata varnum;
run;