Context:
I have a SAS EG program, which i use to load data to our SAS VA server, and send an email to notify users that data is being loaded and an email once the load has completed.
As part of this program the user needs to select what dataset they are wanting to load.
EG:
Unformatted Value Formatted Value
File1 Customer Data
File2 Sales Data
Problem:
When i reference the prompt name (input_file) in the code it returns the unformatted value.
Is there a way to have the program pull the formatted value from the prompt list, without having to actually code it specifically into the program?
Example code:
FILENAME Mailbox EMAIL; DATA _NULL_; FILE Mailbox TO= (emails here) FROM= "&uemail" SUBJECT="SAS VA Reports referencing &input_file table currently unavailable"; PUT "Hello All,"; PUT "Please be advised that table &input_file is currently being loaded to SAS VA (Discovery) by user &_metauser."; PUT "This message is auto-generated."; RUN;
Thanks in Advance,
Samuel
Is the list dynamic oder static? Is the formatted value generated by applying a format to the unformatted value?
For dynamic lists adding a variable with the formatted value to the data source seems to be the only possibility to solve the problem.
Is the list dynamic oder static? Is the formatted value generated by applying a format to the unformatted value?
For dynamic lists adding a variable with the formatted value to the data source seems to be the only possibility to solve the problem.
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.