Help using Base SAS procedures

case statement

Reply
Super Contributor
Posts: 1,041

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,480

Re: case statement

Posted in reply to robertrao

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,431

Re: case statement

Posted in reply to robertrao
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
  • 174 views
  • 0 likes
  • 3 in conversation