Add empty rows for row count less than N by ID

[shasank]

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. 

[novinosrin · Accepted solution]

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;