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.
These couple of examples may help...not with a count variable, just with sashelp.class and how to show a value for an order or group variable (use a computed column).
ods msoffice2k file="c:\temp\prtgend.xls "
proc report data=sashelp.class nowd ;
title 'proc report examp -- use NOPRINT on SEX var after seeing how PRTGEND works';
columns sex prtgend name age;
define sex / order "Gender1 as Order";
define prtgend / computed 'Gender2';
define age / display "age";
compute before sex;
length holdvar $1;
holdvar = sex;
compute prtgend / character length=1;
prtgend = holdvar;
proc report data=sashelp.class nowd;
title 'Summary Report with Proc Report';
columns sex n pctn;
define sex / group 'Gender';
define n / 'Count';
define pctn / 'Percent' f=percent8.2;
rbreak after / summarize;
ods msoffice2k close;