Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 13

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

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.

 

 

Super User
Super User
Posts: 7,668

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

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

Ask a Question
Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 2 in conversation