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.
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.