Help using Base SAS procedures

Proc report

Reply
Contributor
Posts: 22

Proc report

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

 

 

 

SAS Super FREQ
Posts: 8,866

Re: Proc report

[ Edited ]

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

 

report_usage_important.png

Contributor
Posts: 22

Re: Proc report

Thanks

 

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

Super User
Posts: 10,028

Re: Proc report



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;
Ask a Question
Discussion stats
  • 3 replies
  • 187 views
  • 1 like
  • 3 in conversation