topic Re: If Then Else? in SAS Procedures

If Then Else?

SamT — Fri, 04 Feb 2011 04:05:14 GMT

Hello,

I'm having trouble with a set. I'm trying to assign values (body types) with a code in a single new variable... but the output is assigning the one value CV and no PV's?

data Vehicles;
set name;
set othername key = varname/unique;
If _error_ then delete;
If ThreePrice = . then do;
ThreePrice = NewPrice;
end;

If BodyStyle in ('3D Hatchback','4D Sedan',...,'2D Softtop')
then do;
TYPE= 'PV';
end;
else do;
TYPE= 'CV';
end;

keep ...
rename ...

run;

Re: If Then Else?

Peter_C — Fri, 04 Feb 2011 09:18:34 GMT

The test is case-sensitive. Are your values mixed-case, just like your constants?

Re: If Then Else?

sbb — Fri, 04 Feb 2011 12:39:22 GMT

Suggest adding this line at various locations in your SAS program's DATA step for some diagnosis:

PUTLOG _ALL_;

Scott Barry
SBBWorks, Inc.

Re: If Then Else?

ballardw — Fri, 04 Feb 2011 21:21:37 GMT

I would generally use:

If upcase(BodyStyle) in ('3D HATCHBACK','4D SEDAN',...,'2D SOFTTOP')

because so many data sources tend to mess with case. The other thing to look for would be different numbers of spaces between your list in the "IN" clause and your data.

Re: If Then Else?

SamT — Mon, 07 Feb 2011 22:46:49 GMT

Thanks mate. Works now and I'll look out for it in the future too!

- Sam