topic Re: ERROR: The %DO statement is not valid in open code. in SAS Programming

ERROR: The %DO statement is not valid in open code.

desireatem — Thu, 16 Jan 2014 17:30:27 GMT

Hello, How can I fix this by maintaining %do u=1 %to 20; .........%end

data new;

set new;

run;

%do u=1 %to 20;

proc surveyselect data=new method = urs sampsize = 141 OUTHITS

reps=1 seed=1234100 out=new_&u;

run;

ERROR: The %DO statement is not valid in open code.

CODES..........

%end;

Re: ERROR: The %DO statement is not valid in open code.

LinusH — Thu, 16 Jan 2014 17:34:48 GMT

By having it in closed code (that is, wrap it into a macro definition).

Re: ERROR: The %DO statement is not valid in open code.

Cynthia_sas — Thu, 16 Jan 2014 17:41:18 GMT

Hi, for a longer explanation of what LinusH posted, please see my paper "Macro Basics for New SAS Users". If you are struggling with the correct usage for %DO, it is possible that the paper will explain that in more detail and, the rest of the paper might be useful too.

http://support.sas.com/resources/papers/proceedings13/120-2013.pdf

Cynthia

Re: ERROR: The %DO statement is not valid in open code.

data_null__ — Thu, 16 Jan 2014 17:42:34 GMT

SURVERSELECT has features that should eliminate the need to MACRO look it.

Re: ERROR: The %DO statement is not valid in open code.

desireatem — Thu, 16 Jan 2014 18:14:57 GMT

I put it in a macro it runs but no data is created. The data set test is real data that I want to do random sample with replacement. I can not use the option in proc surveyselec that does not require macro because of some computations that were performed in the code

data test;

set test;

run;

%MACRO DO_BRANCH;

%do u=1 %to 20;

proc surveyselect data=test method = urs sampsize = 141 OUTHITS

reps=1 seed=1234100 out=new_&u;

run;

ERROR: The %DO statement is not valid in open code.

CODES..........

%end;

%MEND DO_BRANCH;

Re: ERROR: The %DO statement is not valid in open code.

CTorres — Thu, 16 Jan 2014 18:42:46 GMT

I think what you need to do is:

%MACRO DO_BRANCH;

%do u=1 %to 20;

proc surveyselect data=test method = urs sampsize = 141 OUTHITS

reps=1 seed=1234100 out=new_&u;

run;

CODES.....

%end;

%MEND DO_BRANCH;

%DO_BRANCH

Regards,

Re: ERROR: The %DO statement is not valid in open code.

desireatem — Thu, 16 Jan 2014 19:37:04 GMT

Thanks; I ran the code but surveyselect created just new_1 and no data from new_2 to new_20

I ran the code:

%MACRO DO_BRANCH;

%do u=1 %to 20;

proc surveyselect data=test method = urs sampsize = 141 OUTHITS

reps=1 seed=1234100 out=new_&u;

run;

CODES.....

%end;

%MEND DO_BRANCH;

%DO_BRANCH;

Re: ERROR: The %DO statement is not valid in open code.

Vince28_Statcan — Thu, 16 Jan 2014 20:06:24 GMT

The following code works just fine when testing

%MACRO DO_BRANCH;

%do u=1 %to 20;

proc surveyselect data=sashelp.class method = urs sampsize = 14 OUTHITS

reps=1 seed=1234100 out=new_&u;

run;

%end;

%MEND DO_BRANCH;

%DO_BRANCH;

However, 2 important things to note. Since all procedure resets to the start of the seed, your current implementation would yield new_1=new_2=...=new_20. That is, the exact same 141 records would be selected.

I suspect its the part in CODES... that triggers your empty new_2 to new_20

As DN pointed out, a more natural approach would be to use REPS=20 and then split the resulting file BY REPLICATE (the automatically generated variable listing the count of REPS). This would clear your issue with having to change seeds each time as then it keeps on drawing numbers from the same seed rather than reseting at the beginning of the seed for each procedure iteration.

Re: ERROR: The %DO statement is not valid in open code.

AncaTilea — Thu, 16 Jan 2014 20:09:11 GMT

Do you do something in the CODES... part that modifies the output data sets?

when I ran your code like this, it worked:

%MACRO DO_BRANCH;

%do u=1 %to 4;

proc surveyselect data=SASHELP.CLASS method = urs sampsize = 141 OUTHITS

reps=1 seed=1234100 out=new_&u;

run;

/*CODES.....*/

%end;

%MEND DO_BRANCH;

%DO_BRANCH;

Re: ERROR: The %DO statement is not valid in open code.

sas_pgmr — Mon, 12 Dec 2016 15:11:22 GMT

This helped me. Thank you.