Proc SQL and OUTOBS

AJ_Brien — Fri, 14 Jun 2019 18:50:14 GMT

Hello,

I'm struggling a bit with the syntax.

I have a macro variable 'volume' whose value will change every day. And the outobs option needs to be equal to twice this volume. when I run without the outobs option, it runs fine. This is what I'm doing:

%let volume = 10;



proc sql outobs= 2*&volume.;
insert into abc
select acc, id, flag, ' ' as trial
from old_table where flag = 'n';
quit;

this is the error that I get:

ERROR 22-322: Syntax error, expecting one of the following: ;, CHECK, CODEGEN, CONSTDATETIME, DOUBLE, DQUOTE, ERRORSTOP, EXEC, 
EXITCODE, FEEDBACK, FLOW, INOBS, IPASSTHRU, LOOPS, NOCHECK, NOCODEGEN, NOCONSTDATETIME, NODOUBLE, NOERRORSTOP, 
NOEXEC, NOFEEDBACK, NOFLOW, NOIPASSTHRU, NONUMBER, NOPRINT, NOPROMPT, NOREMERGE, NOSORTMSG, NOSTIMER, NOSTOPONTRUNC, 
NOTHREADS, NOWARNRECURS, NUMBER, OUTOBS, PRINT, PROMPT, REDUCEPUT, REDUCEPUTOBS, REDUCEPUTVALUES, REMERGE, SORTMSG, 
SORTSEQ, STIMER, STOPONTRUNC, THREADS, UBUFSIZE, UNDO_POLICY, WARNRECURS.

ERROR 200-322: The symbol is not recognized and will be ignored.

Appreciate the help. Thanks!

Re: Proc SQL and OUTOBS

ErikLund_Jensen — Fri, 14 Jun 2019 18:57:42 GMT

Hi @AJ_Brien

You need this:


proc sql outobs= %eval(2*&volume);
insert into abc
select acc, id, flag, ' ' as trial
from old_table where flag = 'n';
quit;

Re: Proc SQL and OUTOBS

AJ_Brien — Fri, 14 Jun 2019 19:03:03 GMT

that worked, thank you!

topic Re: Proc SQL and OUTOBS in SAS Programming

Proc SQL and OUTOBS

Re: Proc SQL and OUTOBS

Re: Proc SQL and OUTOBS