Proc export (Inserting a tab in excel file)

[rathaurvivek]

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]

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 .

Working with Excel spreadsheets using the SAS/ACCESS LIBNAME statement (lexjansen.com)

Thanks

[ballardw]

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.