topic Re: Proc export (Inserting a tab in excel file) in SAS Programming

Proc export (Inserting a tab in excel file)

rathaurvivek — Wed, 02 Feb 2022 16:57:19 GMT

Is there any way to insert a tab in EXISTING Excel file (except proc excport)?

Proc export is not working for insertion of a tab in existing excel file in SAS v9.4 TS1M5 although it's working fine for v9.4 TS1M7

Please suggest any solution/suggestion for it.

CarmineVerrell — Wed, 02 Feb 2022 17:55:05 GMT

Hello,

If you have SAS/Access to pcfiles then this might be an alternative.

Find out if you have SAS/Access to Pcfiles

In a sas program type and execute the following syntax. Then view the log to see if you see SAS/Access to Pcfiles.

If you do then take a look at this link .

Thanks

ballardw — Wed, 02 Feb 2022 18:24:20 GMT

Missing code, at least for SAS 9.4 to see if installed:

proc product_status;run;

and look in the log for something similar to:

For SAS/ACCESS Interface to ODBC ...

If you don't find in the log for product_status you can run :

Proc setinit;run;

If you see something like this it is licensed but not installed and should be able to get it installed.

---SAS/ACCESS Interface to PC Files

If missing in both Proc outputs then not licensed.