Hi. I have a Put statement where I'm attempting to output a mix of strings and variable values. The value for Analysis_Desc, which is ACTUAL DELIVERY DATE MISSING IN IV, needs to be output in quotes, but I can't seem to get the syntax to output the value in quotes.
PUT "WHEN (" RULE ") AND a.RULE = . THEN " ANALYSIS_DESC;
I'd expect the Put output statement to look like this:
WHEN (A.ACTUAL_DLVRY_DATE IS NULL AND B.ACTUAL_DLVRY_DATE IS NOT NULL ) AND a.RULE = . THEN
"ACTUAL DELIVERY DATE MISSING IN IV"
PUT 'WHEN (' RULE ') AND a.RULE = . THEN "' ANALYSIS_DESC '"';
PUT 'WHEN (' RULE ') AND a.RULE = . THEN "' ANALYSIS_DESC '"';
Another approach :
str = cats"When (",Rule,") and a.rule= . then ",quote(ANALYSIS_DESC));
put str;
When using PUT statements you can also use FORMATS like $QUOTE.
PUT "WHEN (" RULE ") AND a.RULE = . THEN " ANALYSIS_DESC :$quote128.;
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.