@anujmehta wrote:
Thanks so much. The output is not exactly what i want. The data is structured as is structured exactly as you indicated but with 9 million observations and a patient ID.
data temp;
input patientid surge cmr_aids cmr_alcohol cmr_anemdef;
datalines;
1 0 0 1 0
2 0 0 1 1
3 0 0 0 1
4 0 1 1 1
5 0 1 1 1
6 0 0 1 0
7 0 1 0 0
8 0 1 0 1
9 1 0 0 0
10 1 0 0 0
11 1 1 1 1
12 1 0 1 0
13 1 1 0 1
14 1 0 0 1
15 1 1 1 0
;
run;
i used proc freq with a table statement (cmr_aids cmr_alcohol cmr_anemdef)* surge; to calculate the percentage of each condition in the larger population.
The table i want would be:
Surge=1 Surge=0
AIDS 0.3 0.3
Alcohol 4.5 4.1
Anemia 8.2 8.3
where the columns are surge 1 and surge 0, the rows are each condition and the values of the cells are the percentage of patients with each condition within each surge cohort similar to a Table 1 in publications.
Thanks!
First "Table 1 in publications" is so topic/profession/area specific that it is next to meaningless to many of us.
Second is this :
Surge=1 Surge=0
AIDS 0.3 0.3
Alcohol 4.5 4.1
Anemia 8.2 8.3
Supposed to come from that example data set???? Using your previous proc freq code as a template I do not get any of those numbers from the provided example data.
This does however match proc freq output for the given example data for the _type_=11 and the CMR variable = 1.
proc tabulate data=temp;
class surge;
var cmr: ;
table cmr: * mean=''*f=percent8.2,
surge
;
run;
or if you don't like percent signs:
proc format library=work;
picture perc_no_sign (round)
0-high = '009.99' (mult=10000 )
;
run;
proc tabulate data=temp;
class surge;
var cmr: ;
table cmr: * mean=''*f=perc_no_sign.,
surge
;
run;
... View more