topic Re: Create new variable in SAS Programming

Create new variable

KatLinden — Thu, 14 Nov 2019 17:20:45 GMT

Hi, I need to create a new variable consisting of three values 1, 2 and 3 and apply to all values to an already existing variable.

This is what I have:

This is what I need:

A 1

A 2

A 3

B 1

B 2

B 3

C 1

C 2

C 3

I realize this is probably an easy fix, but I can't figure it out.

Thanks for your help 🙂

novinosrin — Thu, 14 Nov 2019 17:23:42 GMT

just loop each record

data want;
set have;
do newvar=1 to 3;
 output;
end;
run;

PeterClemmensen — Thu, 14 Nov 2019 17:25:00 GMT

data have;
input var1 $;
datalines;
A
B
C
;

data want;
   set have;
   do var2=1 to 3;
      output;
   end;
run;