topic Macro to create patient profiles in SAS Programming

Macro to create patient profiles

mano — Mon, 25 Feb 2013 16:07:57 GMT

I Have created a macro for creating patient profiles.

%macro patprof ( subjid= );

%mend;

I have 550 patients in my study and I am calling my macro for every individual patient.

for example :-

%patprof(subjid= 101);

%Patprof(subjid=102);

%patprof(subjid=109);

is there any way that which improves my macro code so that I don't need to call my macro all 550 times for each patient.

My subjid are not consecutive numbers.

any help is appreciated.

Re: Macro to create patient profiles

art297 — Mon, 25 Feb 2013 16:09:31 GMT

You would have to post your macro in order for anyone to help

Re: Macro to create patient profiles

Astounding — Mon, 25 Feb 2013 17:00:53 GMT

Art is right ... without seeing your code we can give just the most general of answers. With that in mind, there are two approaches that might be possible.

(1) You may be able to change your code so that it processes all patients using a BY SUBJID statement. If appropriate, subset your data so it contains just the SUBJID values of interest (including the possibility of just a single SUBJID), and feed the subset to your code.

(2) You may be able to keep your code as is, but tell us a data set that contains all relevant values for SUBJID. Then macro language could generate the 550 calls to your macro, instead of you having to type them.

Good luck.

Re: Macro to create patient profiles

UrvishShah — Tue, 26 Feb 2013 06:51:10 GMT

Hi,

Based on your information provided, if youe SUBJID is not a consecutive numbers, then try the following code..It might works...

%macro test;

proc sql noprint;

select distinct compress(subjid) into :_subjid separated by ' '

from have (keep = subjid);

quit;

%let i = 1;

%let _subjid_ = %scan(&_subjid.,&i.);

%do %while(&_subjid_ NE);

%patprof(subjid= &_subjid_.);

%let i = %eval(&i + 1);

%let _subjid_ = %scan(&_subjid.,&i.);

%end;

%mend test;

%test;

Hope it works...

Thanks,

Urvish