Help using Base SAS procedures

proc import .xlsx

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

proc import .xlsx

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.


Accepted Solutions
Solution
‎08-08-2012 05:37 PM
Occasional Contributor
Posts: 17

Re: proc import .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.

View solution in original post


All Replies
Super User
Posts: 17,826

Re: proc import .xlsx

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:

http://listserv.uga.edu/cgi-bin/wa?A1=ind1208a&L=sas-l#31

Occasional Contributor
Posts: 17

Re: proc import .xlsx

scandate or usedate?

Super User
Posts: 17,826

Re: proc import .xlsx

scandate is for excel and usedate is for access I believe.

Occasional Contributor
Posts: 17

Re: proc import .xlsx

no usedate is for .xlsx

Super User
Posts: 17,826

Re: proc import .xlsx

Solution
‎08-08-2012 05:37 PM
Occasional Contributor
Posts: 17

Re: proc import .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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 2134 views
  • 6 likes
  • 2 in conversation