DATA Step, Macro, Functions and more

Putting quotes around a variable value

Accepted Solution Solved
Reply
Regular Contributor
Posts: 212
Accepted Solution

Putting quotes around a variable value

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"

 


Accepted Solutions
Solution
‎09-07-2016 07:07 PM
Respected Advisor
Posts: 3,124

Re: Putting quotes around a variable value

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

View solution in original post


All Replies
Solution
‎09-07-2016 07:07 PM
Respected Advisor
Posts: 3,124

Re: Putting quotes around a variable value

PUT 'WHEN (' RULE ') AND a.RULE = . THEN "' ANALYSIS_DESC '"';
Super User
Posts: 10,550

Re: Putting quotes around a variable value

Another approach :

 

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

put str;

 

 

Respected Advisor
Posts: 3,777

Re: Putting quotes around a variable value

[ Edited ]

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

 

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

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 313 views
  • 4 likes
  • 4 in conversation