topic Re: Proc report in SAS Procedures

Proc report

Defense — Sat, 24 Jun 2017 02:15:54 GMT

I have a sas datsset create as below:

proc format;

value gender

1=male

2=femal;

run;

DATA have;

input group id sex ;

format sex gender.;

datalines;

1 133 1

3 134 1

;

run;

( sas dataset Have)

obs group id sex

1 1 133 male

2 3 134 male

Then I run proc report code as below:

proc report data=have; run;

The output upexpect as below(colum total):

group id sex

4 267 femal

How can I fix this problem? it sounds because format

Thank

Re: Proc report

Cynthia_sas — Sat, 24 Jun 2017 02:27:45 GMT

Hi:
You do not have any define statements in your PROC REPORT code. GROUP and ID variables are numeric and by default, numeric variables have a usage of SUM. So you have values of 1 and 3 in for your two rows, and 1+3 = 4. You have values of 133 and 134 for ID and 133+134 = 267.

My suggestion is that you review the DEFINE statement. And, as an example of what you need to do, consider this code and output.

cynthia

Re: Proc report

Defense — Sat, 24 Jun 2017 02:37:43 GMT

Thanks

In my real datsset, there is one more character variable. I will try to use define/order optiom to see if it workd.

Re: Proc report

Ksharp — Sat, 24 Jun 2017 12:40:54 GMT



proc format;
value gender
1='male'
2='femal';
run;

 

DATA have;
input group id sex ;
format sex gender.;
datalines;
1 133 1
3 134 1
;
run;

proc report data=have nowd;
define group/display;
run;