topic Re: Putting quotes around a variable value in SAS Programming

Putting quotes around a variable value

buechler66 — Tue, 06 Sep 2016 20:26:48 GMT

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"

Re: Putting quotes around a variable value

Haikuo — Tue, 06 Sep 2016 21:03:49 GMT

PUT 'WHEN (' RULE ') AND a.RULE = . THEN "' ANALYSIS_DESC '"';

Re: Putting quotes around a variable value

ballardw — Tue, 06 Sep 2016 21:15:46 GMT

Another approach :

str = cats"When (",Rule,") and a.rule= . then ",quote(ANALYSIS_DESC));

put str;

Re: Putting quotes around a variable value

data_null__ — Wed, 07 Sep 2016 10:32:41 GMT

When using PUT statements you can also use FORMATS like $QUOTE.

PUT "WHEN (" RULE ") AND a.RULE = . THEN " ANALYSIS_DESC :$quote128.;