Advertisement
leannemcn13

multiple conditions in proc sql

Nov 28th, 2016
380
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SAS 0.24 KB | None | 0 0
  1. PROC SQL;
  2.  SELECT WEIGHT,
  3.  CASE
  4.  WHEN WEIGHT BETWEEN 0 AND 50 THEN ’LOW’
  5.  WHEN WEIGHT BETWEEN 51 AND 70 THEN ’MEDIUM’
  6.  WHEN WEIGHT BETWEEN 71 AND 100 THEN ’HIGH’
  7.  ELSE ’VERY HIGH’
  8.  END AS NEWWEIGHT
  9.  FROM HEALTH;
  10. QUIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement