I have a simulated dataset with 35 variables (_65, _66,.....,_99) referencing age groups. I'd like to count how many zeros in the data for each age group and get a summary table, so I tried "proc format" as below, however, I don't know how to specify the output files names (after Out 😃 : My original thought was to use data step to join all the 35 tables. Specifically, my questions are 1) can anyone provide a better way to do this? I guess maybe macro or loop can do this or, 2) follow my current code, to give output dataset names. Please advise. Thanks! proc format; value fmt 0 = 'Negative' other = 'Positive'; run; proc freq data=initial4_64; table _65-_99 /out = ; format _65-_99 fmt.; run;
... View more