LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 27 Feb 2008 09:04:42 -0800
Reply-To:     drraju123@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         drraju123@GMAIL.COM
Organization: http://groups.google.com
Subject:      proc report - automation
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi all,

how are you doing.

i am using a macro to create 'aa' dataset. each call of macro produces

aa dataset with different number of variables depending on wether it is for sex or area (which is put in a macro parameter).

for every variable:

example : p1n_0_1 the value between _ _ is treatment ( 0 )

the last value is the code for sex or area( 1 )

lets say:

label 0 = 'x' 1 = ' y' 2 = 'z'

the treatments will be same for either sex or area.

sex code 1 = male 2 = female

area code 1 = nc 2 =ny 3 = mi 4 = tx

i want to write a proc report such that when i call macro depending on the macro parameter the output should be created.

lets say %macro x(var = ); proc report;

%mend; %x (var = sex); %x(var = area);

for sex output shpuld be: ______X_______ _______Y_________ __________Z_______ SOC MPT MALE FEMALE MALE FEMALE MALE FEMALE N(%) N(%) N(%) N(%) N(%) N(%)

Blood anaemia 33(12.0) 44(11.0) 32(23.0) 56(80.0) 45(10.0) 54(56.0)

for area.

it will be same as sex except instead of male and female we have nc ny mi tx under each treatment

please see below for datasets

data aa; /** datset for sex**/ input soc $ mpt $ p1n_0_1 $ p1n_0_2 $ p1n_1_1 $ p1n_1_2 $ p1n_2_1 $ p1n_2_2 $;

datalines;

blood anaemia 33(12.0) 44(11.0) 32(23.0) 56(80.0) 45(10.0) 54(56.0) ; run;

data aa; /** datset for area**/ input soc $ mpt $ p1n_0_1 $ p1n_0_2 $ p1n_0_3 $ p1n_0_4 $ p1n_1_1 $ p1n_1_2 $ p1n_1_3 $ p1n_1_4 $ p1n_2_1 $ p1n_2_2 $ p1n_2_3 $ p1n_2_4 $ ; datalines;

blood anaemia 33(12.0) 44(11.0) 32(23.0) 56(80.0) 45(10.0) 54(56.0) 33(12.0) 44(11.0) 32(23.0) 56(80.0) 33(12.0) 44(11.0) ; run;

thank you, Rangoon.


Back to: Top of message | Previous page | Main SAS-L page