Help using Base SAS procedures

case statement

Reply
Super Contributor
Posts: 1,040

case statement

Hello,

 

I am using case statements like shown below. It throws an error

"Incorrect syntax near the keyword 'then'."

Can someone please help me write the correct syntax

Here, the Division table was used twice...

If its a medical student then we attribute the division value of the variable under admitting division(ACADADM)

If its a surgical student then we attribute the division value of the variable under performing division(ACADPERF)

 

CASE

WHEN (Type in('Medical') then ACADADM.Division

WHEN (Type in('Nonmedical') then ACADPERF.Division

 

Thnx a lot

END as MedType_ServiceLine,

PROC Star
Posts: 7,366

Re: case statement

I would just get rid of the left parentheses that immediately follow the string 'when'. Let us know if that corrects the problem.

 

Art, CEO, AnalystFinder.com

 

Super User
Posts: 5,260

Re: case statement

Since you are not utilising the in list you could simplify your code:
CASE Type
WHEN 'Medical' then...
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 152 views
  • 0 likes
  • 3 in conversation