DATA Step, Macro, Functions and more

retain character variable as a Variable value.

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

retain character variable as a Variable value.

Hello All,

 

 

I want below as my output ,Meaning I want catx of all observation.

 

 

 

 

fNameNameSexAgeHeightWeightTotal
 AliceF1356.584Alice
AliceBarbaraF1365.398Barbara,Alice
BarbaraCarolF1462.8102.5Carol,Barbara,Alice
CarolJaneF1259.884.5Jane,Carol,Barbara,Alice
JaneJanetF1562.5112.5Janet,Jane,Carol,Barbara,Alice
JanetJoyceF1151.350.5Joyce,Janet,Jane,Carol,Barbara,Alice
JoyceJudyF1464.390JudyJoyce,Janet,Jane,Carol,Barbara,Alice

 

I have written below code 

 

data new;
retain fName a;
set sashelp.class;

fname=lag(Name);

Total=catx(',',Name,fname);
run;

 

Could any one suggest best possible wqay to get desire output also it would be helpful if get only unique values in 'Total' Variable.

 

Thanks


Accepted Solutions
Solution
‎06-28-2016 08:58 AM
Regular Contributor
Posts: 194

Re: retain character variable as a Variable value.

Hello,

 

Does the following program answer your problem ?

 

data new;
set sashelp.class;
length Total $1000.;
retain total;

if _N_=1 then Total=Name;
else Total=catx(',',Name,Total);
run;

View solution in original post


All Replies
Solution
‎06-28-2016 08:58 AM
Regular Contributor
Posts: 194

Re: retain character variable as a Variable value.

Hello,

 

Does the following program answer your problem ?

 

data new;
set sashelp.class;
length Total $1000.;
retain total;

if _N_=1 then Total=Name;
else Total=catx(',',Name,Total);
run;
Contributor
Posts: 35

Re: retain character variable as a Variable value.

Yes ,I found the way.

Thanks a lot for response

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 303 views
  • 0 likes
  • 2 in conversation