Hi,
I would like to have a column with concatenated values if one of the cell used to concatenate is not null.
How do I do the following?
data icoplib.icop_alerts4 (drop=CRITERIA_VALUE_in);
set icoplib.icop_alerts3 (rename=(CRITERIA_VALUE=CRITERIA_VALUE_in));
if risk_level not is null then do;
criteria_value = trim(criteria_value_in) || ' - ' ||trim(risk_level);
end;
else do;
criteria_value=trim(criteria_value_in);
end;
run;
Thank you for your help and time.
In data step
if not missing(risk_level) then do;
You might not need the if though.
The CATX function truncates blanks and places specified delimiter between strings.
data _null_;
risk_level='';
criteria_value_in = 'criteria';
criteria_value= catx('-',criteria_value_in,risk_level);
put criteria_value;
run;
In data step
if not missing(risk_level) then do;
You might not need the if though.
The CATX function truncates blanks and places specified delimiter between strings.
data _null_;
risk_level='';
criteria_value_in = 'criteria';
criteria_value= catx('-',criteria_value_in,risk_level);
put criteria_value;
run;
Works like a charm.
Thank you very much.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.