Add empty rows for row count less than N by ID

shasank — Fri, 13 Sep 2019 19:11:58 GMT

Hi Community,

I need your help with the below problem.

If the per ID rows count is <6 then I would like to add the additional missing rows with the Score = 0;

data Dsn;
input ID score;
cards;
1 48
1 45
1 50
1 42
1 41
2 51
2 52
2 43
2 52
;
run;

Expected Output:

ID	Score
1	48
1	45
1	50
1	42
1	41
1	0
2	51
2	52
2	43
2	52
2	0
2	0

Any help is appreciated.

Thank you for your time.

Best,

SC.

Re: Add empty rows for row count less than N by ID

novinosrin — Fri, 13 Sep 2019 19:17:34 GMT

data Dsn;
input ID score;
cards;
1 48
1 45
1 50
1 42
1 41
2 51
2 52
2 43
2 52
;
run;

data want;
 do _n_=1 by 1 until(last.id);
  set dsn;
  by id;
  output;
 end;
 do _n_=_n_+1 to 6;
 score=0;
 output;
 end;
run;

topic Add empty rows for row count less than N by ID in New SAS User

Add empty rows for row count less than N by ID

Re: Add empty rows for row count less than N by ID