I'm trying to export a SAS dataset to Excel 2013 file using a program within a process flow in SAS EG 7.1. I wish to use two prompt in the name of the file e.g : &Prompt_4_SSC_4147_EMPL_AND_POS_SDMB_FINAL_&Prompt_3.xlsx. Is it possible to do?
You have two issues here:
first, there is a problem with the resolution of macro variables. Either you omitted the necessary dot after the macro variable names, or necessary macro variables are not defined:
WARNING: Apparent symbolic reference TRACKER_4147 not resolved. WARNING: Apparent symbolic reference DATE_PROD_TODAY not resolved.
second, SAS/ACCESS to PC Files is either not installed or not licensed:
ERROR: DBMS type EXCEL not valid for export.
Both of these issues need to be dealt with.
If you write the data from Excel to a csv file, no license is needed and a simple data step can read the data.
Values from prompts are handed to SAS code in the form of macro variables, and can be used as such.
Note that the names of macro variables used as parts of words need to be terminated with a dot:
&Prompt_4._SSC_4147_EMPL_AND_POS_SDMB_FINAL_&Prompt_3..xlsx
assuming that your prompts are named prompt_3 and prompt_4, respectively.
The ERROR happens in a libname statement, not in proc export code. Please post the log "as is" in a {i} window.
You have two issues here:
first, there is a problem with the resolution of macro variables. Either you omitted the necessary dot after the macro variable names, or necessary macro variables are not defined:
WARNING: Apparent symbolic reference TRACKER_4147 not resolved. WARNING: Apparent symbolic reference DATE_PROD_TODAY not resolved.
second, SAS/ACCESS to PC Files is either not installed or not licensed:
ERROR: DBMS type EXCEL not valid for export.
Both of these issues need to be dealt with.
If you write the data from Excel to a csv file, no license is needed and a simple data step can read the data.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.