0 votes
in Software Defined Networking by
How to use IF THEN ELSE in PROC SQL?

1 Answer

0 votes
by

PROC SQL;

SELECT WEIGHT,

CASE

WHEN WEIGHT BETWEEN 0 AND 50 THEN ’LOW’

WHEN WEIGHT BETWEEN 51 AND 70 THEN ’MEDIUM’

WHEN WEIGHT BETWEEN 71 AND 100 THEN ’HIGH’

ELSE ’VERY HIGH’

END AS NEWWEIGHT FROM HEALTH;

QUIT;

...