BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
buechler66
Barite | Level 11

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"

 

1 ACCEPTED SOLUTION

Accepted Solutions
Haikuo
Onyx | Level 15
PUT 'WHEN (' RULE ') AND a.RULE = . THEN "' ANALYSIS_DESC '"';

View solution in original post

3 REPLIES 3
Haikuo
Onyx | Level 15
PUT 'WHEN (' RULE ') AND a.RULE = . THEN "' ANALYSIS_DESC '"';
ballardw
Super User

Another approach :

 

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

put str;

 

 

data_null__
Jade | Level 19

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

 

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

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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