If Then Else?

[SamT]

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;

[Peter_C]

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

[sbb]

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

PUTLOG _ALL_;

Scott Barry
SBBWorks, Inc.

[ballardw]

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.

[SamT]

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

- Sam