data a; input name $ salary department $; datalines; rahul 100000 a rohit 90900 b nisha 8000 a pulkit 7000 b yashika 6000 a yash 11000 b ; run;
... View more
Department wise highest salary gt 10000 using proc sql
data a;
input name salary department;
datalines;
rahul 100000 a
rohit 90900 b
nisha 8000 a
pulkit 7000 b
yashika 6000 a
yash 11000 b
;
run;
... View more
data have; input father $ son $; cards; a b
b c
c d
d e ; run;
data want; input grandfather$ father $ son $; cards; a b c
b c d
c d e; run;
... View more
