topic Re: Do/Select statement not working when formatting dates. in SAS Programming

Do/Select statement not working when formatting dates.

bknitch — Thu, 26 Aug 2021 20:35:33 GMT

I'm receiving the following error for the code above:

31         	format incdt mmddyy10.;
32         		incmonthid = YEAR(disdt_c)*100+MONTH(disdt_c);
33         		yr = YEAR(disdt_c);
34         	end;
            ___
            161
35             else do;
               ____
               160
ERROR 161-185: No matching DO/SELECT statement.

ERROR 160-185: No matching IF-THEN clause.

Not sure what the issue is.

Re: Do/Select statement not working when formatting dates.

Kurt_Bremser — Thu, 26 Aug 2021 20:04:13 GMT

What it says. A END ends a block that starts either with DO or SELECT.

Please post your complete data step code so we can correct it.

Re: Do/Select statement not working when formatting dates.

bknitch — Thu, 26 Aug 2021 20:09:33 GMT

I've edited the post to reflect the entire code

Re: Do/Select statement not working when formatting dates.

Kurt_Bremser — Thu, 26 Aug 2021 20:17:43 GMT

ELSE can only be used as the second branch of an IF statement.

To me it seems your code misses

if /* condition */
then do;

before

incmonthid = YEAR(disdt_c)*100+MONTH(disdt_c)

Re: Do/Select statement not working when formatting dates.

bknitch — Thu, 26 Aug 2021 20:36:29 GMT

@kurtbrmser this actually was the solution! Thank you i just placed it in the incorrect spot.