put() function error proc sql

[Hayk]

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 · Accepted solution]

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]

OK, thanks a lot .