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
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!
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.
Ready to level-up your skills? Choose your own adventure.