topic Macro for repeating variables in SAS Programming

Macro for repeating variables

Q1983 — Wed, 18 Dec 2013 04:03:05 GMT

data investor1;
set investor ;
Col_group = substr(d_col_group,3);
Col_group_sort=substr(d_col_group,1,1);
if ls_step_cd ='322' then do; step_desc ='QA Apprvd RPP';Point_Value=1;if Col_group = 'A' then Col_group_sort='E';end;
if ls_step_cd ='322' then do; step_desc ='QA Apprvd RPP';Point_Value=1;if Col_group = 'B' then Col_group_sort='C';end;
if ls_step_cd ='322' then do; step_desc ='QA Apprvd RPP';Point_Value=1;if Col_group = 'C' then Col_group_sort='F';end;
if ls_step_cd ='323' then do; step_desc ='QA Apprvd ;Point_Value=1;if Col_group = 'A' then Col_group_sort='E';end;
if ls_step_cd ='323' then do; step_desc ='QA Apprvd ;Point_Value=1;if Col_group = 'B' then Col_group_sort='C';end;
if ls_step_cd ='323' then do; step_desc ='QA Apprvd ;Point_Value=1;if Col_group = 'C' then Col_group_sort='F';end;

run;

I am trying to do a macro. In this for each step_cd there will be several scenarios. The step_decr and the point value will be the same for each step_cd. The col_group and col_group sort will vary depending on the col_group. Instead of listing each scenario, I want to do a macro based on the scenarios I just described

Re: Macro for repeating variables

kuridisanjeev — Wed, 18 Dec 2013 05:07:35 GMT

Can you post the sample data and required format .That would help us to clearly understand your requirement.

Thanks,

Sanjeev.K

Re: Macro for repeating variables

kuridisanjeev — Wed, 18 Dec 2013 05:27:00 GMT

And As per my understanding,no need of using macros for your senario.

You can create a user defined format for displaying Col_group_sort column based on the Col_group values.

I simplified your code.Can you test bellow code on your data.

Proc format ;

value $ Grpsort

"A"="E"

"B"="C"

"C"="F"

;

run;

Data Want;

Set Have;

if ls_step_cd ='322' then do;

step_desc ='QA Apprvd RPP';Point_Value=1;

Col_group_sort=put(Col_group,$Grpsort.);

end;

if ls_step_cd ='323' then do;

step_desc ='QA Apprvd' ;Point_Value=1;

Col_group_sort=put(Col_group,$Grpsort.);

end;

Run;

Thanks,

Sanjeev.K

Re: Macro for repeating variables

UrvishShah — Wed, 18 Dec 2013 10:32:24 GMT

Hi,

In this case, you need to fix how many instances of step_cd and col_group...If there's so many subjects of step_cd and col_group then only you should think about Macros or formats...

Based on SAS Codes, it will be difficult to answer your question so please post some sample data and output you want...

-Urvish