topic proc summary class with ranges possible? in SAS Procedures

proc summary class with ranges possible?

pinkyc — Thu, 12 Feb 2015 19:31:21 GMT

I have data as such:

PatID Age Num_1 Num_2 Den

A 18 0 1 1

B 330 0 1 1

C 65 1 1 1

D 44 1 0 1

E 70 1 1 1

F 20 0 0 1

...

I know that using this:

proc summary data=pat_info;

class Age;

var Num_1 Num_2 Den;

output out=pat_infosum sum=;

run;

Would give me an output where Num_1, Num_2 and Den with 1's are summed for each age, however, is there a way to set a range for the class? Something like 18-64 and 65+ so that the Num_1 and Num_2 are summed by a range of ages, not each age.

Re: proc summary class with ranges possible?

Haikuo — Thu, 12 Feb 2015 19:56:15 GMT

Hint: Proc format to group the range.

Re: proc summary class with ranges possible?

Reeza — Thu, 12 Feb 2015 20:02:32 GMT

Hope you don't have someone who is 330

Re: proc summary class with ranges possible?

Haikuo — Thu, 12 Feb 2015 20:03:59 GMT

And I hope it is me

Re: proc summary class with ranges possible?

pinkyc — Thu, 12 Feb 2015 20:14:04 GMT

Haha, typo there!