topic Re: Proc Report in SAS Procedures

Proc Report

robertrao — Mon, 04 Mar 2013 14:02:17 GMT

Could anyone help me resolve this issue Please

Re: Proc Report

robertrao — Mon, 04 Mar 2013 14:02:45 GMT

In the dataset I have sorted in the descending order of Discharges(number)... I wanted in that fashion
Type     Dept      Discharges
Normal    Health    400
Transfer Health    60
Death     Health    10

I do a proc report and i keep getting like this:

Dept Type Discharges

Health   Death      10
             Normal     400
            Transfer   60

Re: Proc Report

Tom — Mon, 04 Mar 2013 14:28:00 GMT

What code did you try? If you already have sorted the data and do not want "order" style applied then just define every variable as a display variable.

proc reports data=HAVE nofs ;

column type dept discharges;

define type / display ;

define dept / display;

define discharges / display ;

run;

Re: Proc Report

Cynthia_sas — Mon, 04 Mar 2013 14:28:56 GMT

Hi:

PROC REPORT uses either the default order in which the variables are stored in the dataset or the left-to-right order in which the columns are listed in a COLUMN statement. You did not list your code. If you want TYPE listed first on the report, it would have to be listed first on the COLUMN statement:

COLUMN TYPE DEPT DISCHARGES;

What do you have in your current COLUMN statement?

However, do you only have 3 observations in your data file? Or, are there more observations? If you have more than 3 observations, you may need DEFINE statements to control whether an item is ORDER, GROUP or SUM.

Also, since your data are already sorted in a particular order, then I would envision, that you would need a DEFINE statement for TYPE that was:

DEFINE TYPE / ORDER ORDER=DATA;

DEFINE TYPE / GROUP ORDER=DATA;

hard to tell which one without knowing more about your data and seeing the code you're using right now. And, if you think you'll want a "grand total" at the bottom of the report, you may also need an RBREAK statement:

RBREAK AFTER / SUMMARIZE;

cynthia