topic put() function error proc sql in SAS Programming

put() function error proc sql

Hayk — Fri, 30 Sep 2011 09:32:14 GMT

please assist me with this problem .

proc sql noprint;

select case

when SOME_ATTRIBUTE= 'Monthly' then put(intnx('dtDAY',DATETIME_VAR,1,'s'),best32.)

when SOME_ATTRIBUTE = 'Daily' then put(intnx('dtMONTH',DATETIME_VAR,1,'s',best32.)

end

into : mvNextDate

from work.SOME_TABLE

run;

ERROR 22-322: Syntax error, expecting one of the following: a name, *.

Resa — Fri, 30 Sep 2011 11:34:01 GMT

In case you copied the code directly, you have forgotten a close parenthesis in the second statement between 's' and ,best32.

Instead of put(intnx('dtMONTH',DATETIME_VAR,1,'s',best32.) it should be put(intnx('dtMONTH',DATETIME_VAR,1,'s'),best32.)

Hayk — Sat, 01 Oct 2011 08:55:54 GMT

OK, thanks a lot .