topic Re: case statement in SAS Procedures

case statement

robertrao — Tue, 18 Apr 2017 03:05:43 GMT

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,

art297 — Tue, 18 Apr 2017 03:16:54 GMT

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

LinusH — Tue, 18 Apr 2017 05:26:45 GMT

Since you are not utilising the in list you could simplify your code:
CASE Type
WHEN 'Medical' then...