Hi everyone,
I was wondering if anyone could help me with a question I have with proc report. I used the following codes to create a table ordered by the variable "count". I used ods msoffice2k option to save my table in excel. The problem I had was cell values for "count" became missing when the adjacent cells were associated with the same value. Does anybody know of a way to force the values of the order variable to be presented in the table? Thanks very much in advance.
ods msoffice2k file="freq_sex.xls " path=odsout style=minimal ;
proc report data=report nowd headline headskip ;
columns sex_1 count pct_total;
define sex_1 / display "Field Name" left ;
define count / order descending "Record Count" center ;
define pct_total / display "Percent Total";
run ;
Sample output:
Field Name Record Count Percent Total
Female 121 50%
Male 50%