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.
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.