您好，假如我的day有很多天怎么办？

data test;
input day id $;
cards;
1 234
1 75
1 10
1 987
1 96
1 3475
1 305
1 489
1 96
1 697
1 234
1 120
1 245
1 3250
1 25
1 29
1 598
1 965
2 965
2 87
2 59
2 65
2 476802
2 69
2 305
2 79
2 25
2 29
2 245
2 987
2 578
2 457
2 864
2 5876
3 69897
3 1986
3 19
3 983
3 25
3 29
3 5678
3 768
3 97
3 976
3 567
3 6
3 968
3 19
3 17
3 567
3 467  
;

proc sql;
  create table wanted as
   select distinct day, id, count(distinct id ) as num_Id
     from test
         where day ne 1 and id in (select distinct id from test where day=1)
     group by id;
quit;