topic Re: If/else statement in New SAS User

If/else statement

derrickwilliams — Wed, 01 Dec 2021 13:21:06 GMT

Hello, I'm knew to SAS. I'm trying to understand what the If/else statement is accomplishing in this code.

IF dateCommaFinder = 0 THEN

date = input(strDate,MMDDYY10.);

FORMAT date MMDDYY10.;

day = day(date);

mnth=month(date);

year=year(date);

END;

ELSE

date3 = SUBSTR(strDate, dateCommaFinder+2);

dateSpaceFinder=INDEX(date3, ' ');

month = SUBSTR(date3, 1, dateSpaceFinder);

SELECT (month);

Re: If/else statement

Kurt_Bremser — Wed, 01 Dec 2021 13:27:15 GMT

As posted, it causes a syntax error because it is incomplete.

The SELECT statement starts a block that has to be terminated by an END, and the ELSE DO also needs an END.

Re: If/else statement

AMSAS — Wed, 01 Dec 2021 15:39:06 GMT

It also looks like you are missing semi-colons after both DO statements
You might want to fix your indentation, so that code in a do/end statement is aligned

Go check the documentation for examples, and build your code up little by little

IF-THEN/ELSE Statement

DO Statement

SELECT Statement

IF dateCommaFinder = 0 THEN
  DO ;
    date = input(strDate,MMDDYY10.);
    FORMAT date MMDDYY10.;
    day = day(date);
    mnth=month(date);
    year=year(date);
  END;
ELSE
  DO ;
    date3 = SUBSTR(strDate, dateCommaFinder+2);
    dateSpaceFinder=INDEX(date3, ' ');
    month = SUBSTR(date3, 1, dateSpaceFinder);
    SELECT (month);
      when(<value>)
        do ;
          <some code>
        end ;
        ...
        otherwise        
        do ;
          <some code>
        end ;
      end ;
    end ;
  end ;

Re: If/else statement

ballardw — Wed, 01 Dec 2021 16:06:38 GMT

You might consider providing some examples of your StrDate variable where the DateCommaFinder is not 0. It is possible that you are doing a lot of string manipulation that is not actually needed but we couldn't tell that without explicit examples.