Help using Base SAS procedures

If Then Else?

Reply
Occasional Contributor
Posts: 16

If Then Else?

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;
Valued Guide
Posts: 2,175

Re: If Then Else?

The test is case-sensitive. Are your values mixed-case, just like your constants?
Super Contributor
Super Contributor
Posts: 3,174

Re: If Then Else?

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

PUTLOG _ALL_;

Scott Barry
SBBWorks, Inc.
Super User
Posts: 10,812

Re: If Then Else?

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.
Occasional Contributor
Posts: 16

Re: If Then Else?

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

- Sam
Ask a Question
Discussion stats
  • 4 replies
  • 157 views
  • 0 likes
  • 4 in conversation