topic Re: count question in SAS Procedures

count question

Hart — Mon, 15 Mar 2010 20:35:06 GMT

I have done this function before but am frustrated that I can not remember how!

so I have a table with 68k observations. I would like to create a new column in my dataset with this total number. I do not wish to hardcode this number because it may change.

currently my dataset is:

N N_tot T_tot
0 68243 47739
1 376 182
2 204 144
3 427 248
4 217 150
5 575 326
6 87 62
7 393 247
8 1096 710
9 453 296

I would like to appear as

N N_tot T_tot Count
0 68243 47739 68243
1 376 182 68243
2 204 144 68243
3 427 248 68243
4 217 150 68243
5 575 326 68243
6 87 62 68243
7 393 247 68243
8 1096 710 68243
9 453 296 68243

I would really appreciate any assistance.

Re: count question

RickM — Mon, 15 Mar 2010 20:42:07 GMT

Sounds like you are looking for the RETAIN statement

Re: count question

Patrick — Mon, 15 Mar 2010 23:58:20 GMT

In case that the N_tot value in row one is not always the one containing the maximum then the following would be an option:

data have;
input N N_tot T_tot;
datalines;
0 68243 47739
1 376 182
2 204 144
3 427 248
4 217 150
5 575 326
6 87 62
7 393 247
8 1096 710
9 453 296
;
proc sql;
/*create table want as*/
select *,max(n_tot) as Count
from have;
quit;

Re: count question

ChrisNZ — Thu, 18 Mar 2010 22:36:41 GMT

Maybe:

data T;
set T nobs=NOBS; *read nb of obs;
COUNT=NOBS; *save nb of obs;
run;