topic Re: Create a variable with two rows for each row in another variable in New SAS User

Create a variable with two rows for each row in another variable

mariapf — Tue, 01 Dec 2020 10:09:09 GMT

Hello all,

I have a task that I am having trouble carrying out being a SAS novice but it may be simple after all.

I have some curve names and for each of them I have to create a variable containing two points of the curve. The names of the points are simple to create using a cat function but I cannot figure out how to program an efficient process that creates a new variable with two observations for each observation in the input variable.

Thus, in my input table I have:

CURVE

curve1

curve2

curve3

And I need:

CURVE_POINT

curve1_0

curve1_1200

curve2_0

curve2_1200

curve3_0

curve3_1200

Should I do this with a loop? If so, how do I specify the need to do the loop for all rows of the curve variable? Counting the number of rows seems to be not so simple in SAS...

Thank you so much for your time, it is not easy to be starting out in SAS programming.

Re: Create a variable with two rows for each row in another variable

PeterClemmensen — Tue, 01 Dec 2020 10:13:07 GMT

Try this

data have;
input CURVE $;
datalines;
curve1
curve2
curve3
;

data want(drop = point);
   set have;
   do point = 1, 1200;
      curve_point = catx('_', curve, point);
      output;
   end;
run;

Re: Create a variable with two rows for each row in another variable

mariapf — Tue, 01 Dec 2020 12:27:49 GMT

Thanks a lot for your quick reply!

The code that you have suggested worked for both this issue and another table that I was having trouble creating