11-02-2016 10:44 AM
Hi- Is there a solution for below questions:
1) How to import multiple work sheets to import into sas using sas EG 5.1 (9.3) version.
2) How to export access file using proc export(apart from file-> export option)
Please let me know for more details.
11-02-2016 11:26 AM
With regards to importing multiple sheets, just use proc import with sheet="<sheetname>" option. There are many examples on here and the web of this, and macro-tizing it.
With regards to exporting, a simple google search shows many examples: