Good day all,
I am trying to import a .xlsx file and have the first line take in only what is literally in the file as far as the variables are concerned. Instead the way I have it set up now, it takes the format that is in excel and puts it in the sas datetime. format.
To give you an idea of the dataset:
building 10-jun 10-jul 10- aug ....
Is there an option in the proc import statement to ignore the format that is applied to the variables?
Thanks.
Well I am not really sure what happened but it worked, here is what I ended up using.
proc import out=work.data
datafile = 'filepath'
DBMS = EXCEL Replace;
RANGE="Sheet1$";
getnames = yes;
mixed = no;
scantext = yes;
usedate = yes;
scantime = no;
run;
I am really confused because it wouldn't run, I got up to walk around and clear my head. Ran it again without changing anything and it worked.
You can set scantime/scandate to no in your proc import, but that might not help with other data types.
Otherwise you can see some of the options in this thread here:
scandate or usedate?
scandate is for excel and usedate is for access I believe.
no usedate is for .xlsx
Well I am not really sure what happened but it worked, here is what I ended up using.
proc import out=work.data
datafile = 'filepath'
DBMS = EXCEL Replace;
RANGE="Sheet1$";
getnames = yes;
mixed = no;
scantext = yes;
usedate = yes;
scantime = no;
run;
I am really confused because it wouldn't run, I got up to walk around and clear my head. Ran it again without changing anything and it worked.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.