topic Re: How to regroup observation in New SAS User

How to regroup observation

hjjijkkl — Wed, 27 Jan 2021 18:30:11 GMT

I have a table that looks like this and I want a the variable status to be split into two with one variable containing only "1" and the 2nd variable containing "2 and 3"

ID	Status
1	1
1	3
1	1
1	1
2	1
2	3
2	1
3	1
3	2

I want the result to look like this table below

ID	1st Status	2nd Status
1	1
1		3
1	1
1	1
2	1
2		3
2	1
3	1
3		2

Re: How to regroup observation

PeterClemmensen — Wed, 27 Jan 2021 18:36:56 GMT

data have;
input ID Status;
datalines;
1 1
1 3
1 1
1 1
2 1
2 3
2 1
3 1
3 2
;

data want;
   set have;
   if status = 1 then _1stStatus = Status;
   else if Status in (2, 3) then _2ndStatus = Status;
   drop Status;
run;

Re: How to regroup observation

ballardw — Wed, 27 Jan 2021 18:36:43 GMT

It might help to describe how you intend to use the reshaped data. You may be adding unneeded complexity with additional variables.

Data want;

set have;

if status = 1 then Status1 = 1;

else if status in (2,3) then status2 = status;

run;

maybe. "1st status" is not legal for variable names.

If you no longer want the Status variable in the data set then drop it.