Couple of solutions required on SAS EG 5.1 (9.3) installed on AIX server.

[Durga_SAS]

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.

Thanks

Prasad.

[RW9]

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:

https://v8doc.sas.com/sashtml/proc/z0316856.htm