topic Re: Retaining in New SAS User

Retaining

unnati — Tue, 05 Feb 2019 20:06:58 GMT

Var New Var

A A

B AB

C ABC

D ABCD

can anyone explain how to get this answer with using retain statement or other option

Thank you

Unnati

novinosrin — Tue, 05 Feb 2019 20:11:57 GMT

data have;
do _n_=65 to 68;
var=byte(_n_);
output;
end;
run;

data want;
set have;
length want $10;
retain want;
want=cats(want,var);
run;

Hi @unnati it;s plain vertical concatenation. Just a matter of time before you get the understanding. HTH

SASJedi — Tue, 05 Feb 2019 20:12:50 GMT

HOw about something like this?

data have;
   input Var:$1;
datalines;
A
B
C
D
;
data want;
   set have;
   length NewVar $4;
   retain NewVar;
   NewVar=CATS(NewVar,Var);
run;