topic Couple of solutions required on SAS EG 5.1 (9.3) installed on AIX server. in SAS Enterprise Guide

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

Durga_SAS — Wed, 02 Nov 2016 14:44:23 GMT

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.

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

RW9 — Wed, 02 Nov 2016 15:26:06 GMT

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