topic Re: do loop sas in SAS Procedures

do loop sas

hdg — Thu, 03 May 2012 18:07:33 GMT

I am not sure what I am doing wrong here, its a very simple example just for me to understand why its giving me an error

%let nc = 1;

data _null_;
do nc = 1 to 10;

proc datasets lib=work kill memtype=data;

end;
run;

This gives me the following error

end;

---

180

ERROR 180-322: Statement is not valid or it is used out of proper order

Thank you for your help!

Re: do loop sas

Doc_Duke — Thu, 03 May 2012 18:34:30 GMT

The Do-End combination is part of a DATA step, you can't have PROC's within DATA steps. What SAS sees is the END; statement included in the PROC and it is not a valid statement for PROC DATASETS. That is the reason for the error message.

When I run your code, I also get the error message

ERROR 117-185: There was 1 unclosed DO block.

indicating that SAS did not see the END-statement in the DATA step.

However, the larger problem is that you are probably just getting into macro programming and want to actually execute the PROC 10 times. I would recommend that you read the chapter on macro language programming and go through the examples there before you launch out on your own.

Doc Muhlbaier

Duke

Re: do loop sas

bwasicak — Thu, 03 May 2012 19:10:08 GMT

How about this instead: It will iterate 10 times, whatever you set amax too.

%let amax = 10;

%macro testme;
%do i = 1 %to &amax;
proc datasets lib=work kill memtype=data;
quit;
%end;
%mend testme;

%testme ;

:smileygrin: