topic Re: Using or operator in if and then statement in SAS Programming

Using or operator in if and then statement

knveraraju91 — Sat, 01 Oct 2016 04:13:03 GMT

Dear,

In my data vdate variable contains the following values. I used the following code to convert to isodate. But it gives me " Invalid argument to function INPUT function".

Pleas help why.]

I think my code looks ok.

id vdate(character)

1 17/Jul/2015

3 UN/Jan/2016

code;

if vdate ^= '' or compress(vdate,'/') ^= : 'UN' then date1=put(input(vdate,date11.),is8601da.);

;

Re: Using or operator in if and then statement

Reeza — Sat, 01 Oct 2016 04:45:55 GMT

The log should tell you the offending record which should help you narrow down the issue in your logic.

Also, verify if you want OR or AND

Re: Using or operator in if and then statement

Shmuel — Sat, 01 Oct 2016 09:17:47 GMT

What you realy meant by:

if vdate ^= '' or compress(vdate,'/') ^= : 'UN' then date1=put(input(vdate,date11.),is8601da.);

is if NOT (vdate = ' ' or compress(vdate,'/') = : 'UN' ) then date1=put(input(vdate,date11.),is8601da.);

which, after opening the brackets convert into:

if vdate ^= ' ' AND compress(vdate,'/') ^= : 'UN' then date1=put(input(vdate,date11.),is8601da.);

Other solution is: date1=put(input(vdate,?? date11.),is8601da.);

which in case of vdate is not valid then date1 is missing value.

Re: Using or operator in if and then statement

Astounding — Sat, 01 Oct 2016 10:29:31 GMT

While I agree with the earlier comments, it might be easiest to understand the observations you are processing if you switched to:

if not (vdate in : (' ', 'UN')) then .....;

The way you have written the logic, every single observation meets the IF conditions.