09-06-2012 03:38 AM
I would like to import an excel file in sas (the estension of my file is .xlsx), but i don't know how to do it?
I would like to code it instead to use "file--> import data-->...".
I tried to use the procedure import but i don't get it.
09-06-2012 10:49 AM
You know that if you use "file ---> import data ---> etc", you can save the code that was generated to load the file into SAS?
Then you just INCLUDE that code into you SAS session and save it - save you having to write the code in the first place.
09-06-2012 11:04 AM
thanks for the information. I ignored that i could save the code when i used "file--> import data..".
Can-you explain me how to save the code generated to load the file into sas?
Thanks a lot,
09-06-2012 10:07 AM
Sounds like you tried to use the documentation for PROC IMPORT but you "didn't get it." I assume you were using the SAS/ACCESS Interface to PC Files, right?
If you have feedback about the documentation that would help us improve it, please let me know. Also, for the .xlsx format, there are a number of SAS Notes; just search on xlsx and import to see them. Thanks,
Need further help from the community? Please ask a new question.