Can you please help with following?
data a;
input var1 $;
datalines;
a
b
c
d
e
;
run;
what I need is:
var1 | var2 |
a | a |
b | a-b |
c | a-b-c |
d | a-b-c-d |
e | a-b-c-d-e |
cat = catx('-',lag(var1),var1) ;
That doesn't make sense, you want to add the new variable, not the previous variable1 and current variable.
cat = catx('-',cat,var1) ;
RETAIN + CATX.
data b ;
length cat $200 ;
set a ;
retain cat;
cat = catx('-',lag(var1),var1) ;
run ;
This is what I have but not getting results i want.
cat = catx('-',lag(var1),var1) ;
That doesn't make sense, you want to add the new variable, not the previous variable1 and current variable.
cat = catx('-',cat,var1) ;
Thank you @Reeza
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.