data want(keep=m1-m4);
set have;
length m1-m4 $30; /* adapt to max length needed */
array cx {4} c1-c4; /* input data */
array mx {4} m1-m4; /* calulated for output */
do i=1 to dim(cx);
if i=1 then m1 = c1; else m(xi) = catx('-',mx(i-1),cx(i));
end;
run;
data want(keep=m1-m4);
set have;
length m1-m4 $30; /* adapt to max length needed */
array cx {4} c1-c4; /* input data */
array mx {4} m1-m4; /* calulated for output */
do i=1 to dim(cx);
if i=1 then m1 = c1; else m(xi) = catx('-',mx(i-1),cx(i));
end;
run;
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 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.