topic Re: DO loops in SAS Procedures

DO loops

lmacdon4 — Tue, 23 Feb 2010 18:44:30 GMT

Hi,

I have some programs with multiple steps/procedures that I want to run with a loop. For example, the simplest one is:

data reg_temp;
set hotelJPQ.TueDBA0L1_daily;
where (Week_Code>=1) AND (Week_Code<=4);
run;
PROC reg data=reg_temp outest=reg_out_temp;
* parms b0 b1;
DEMAND: model demand = price;
run;
PROC EXPORT DATA= work.reg_out_temp
OUTFILE= "C:\Research\working papers\Joint price quant\Tue_SAS.xls"
DBMS=Excel;
SHEET="1";
run;
quit;

I would like to replace the numeric values in:
where (Week_Code>=1) AND (Week_Code<=4);
and
SHEET="1";
with a variable (say 'x') within a loop such as
Do x = 1 to 9;

Have tried various approaches including different macros but have had no success.

Is there an easy way (or even a way) of accomplishing this.

Thanks,
lmacdon4

Re: DO loops

sbb — Tue, 23 Feb 2010 18:57:07 GMT

You may consider the SAS macro language for this type of repetitive processing, where only a subset of "variable information" changes iteratively.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search arguments, this topic/post:

macro language basics site:sas.com

macro variables introduction site:sas.com Message was edited by: sbb

Re: DO loops

lmacdon4 — Tue, 23 Feb 2010 19:14:42 GMT

thanks.

have tried some macros, but still having problems getting the different procs etc to recognize the 'x' variable.

Re: DO loops

Cynthia_sas — Tue, 23 Feb 2010 19:53:01 GMT

Hi:
This paper serves as an excellent intro to the SAS Macro Facility:
http://www2.sas.com/proceedings/sugi28/056-28.pdf

cynthia

Re: DO loops

lmacdon4 — Wed, 24 Feb 2010 03:24:55 GMT

thanks Cynthia, the above file was very helpful. The macro is working correctly now.

Cheers,
Leo