Hi ,
I'm preparing for SAs certification Base exam . I have one question . Which will be more efficient between Select group and If statment. I coded this programs for practice using IF statment in one datasep and select group in another . both does same tasks but i would like to know which will be more efficeint for usage and why ? I know here I'm using test data so efficiney cant be known but still I'm curious to know which one will be better to use between select group and IF/then else statment and why ?
Program 1
DATA PATIENT;
INPUT ID $ SALARY DEPT $;
DATALINES;
1129 10000 A
1387 10000 B
2304 10000 C
4759 20000 E
5438 20000 F
6488 20000 G
9012 20000 H
;
DATA PATIENT1;
SET PATIENT;
LENGTH DEPT1 $6.;
IF DEPT IN ('A','B','C','D'') THEN DO DEPT1='ABCD';
ELSE IF DEPT IN ('F','G','H','I'')
THEN DEPT1='FGHI';
run;
DATA PATIENT2;
SET PATIENT;
LENGTH DEPT2 $6.;
SELECT (DEPT);
WHEN ('A','B','C','D') DEPT2='ABCDE';
WHEN ('F','G','H','I') DEPT2='FGHI';
OTHERWISE;
END;
Run;
Thanx
Manish