Question: if user dont know how many locations are there in input, then how can we write a code in SAS Task : data one; input emp_id name$ loc$; datalines; 1 srinivas bang 2 sudhakar bang 3 qqqq hyd 4 hhhh hyd 5 bhanu mumbai 6 jjjjj mumbai ; run; Solution:; DATA Bang; set one(where=(loc='bang')); run; DATA Hyd; set one(where=(loc='hyd')); run; DATA Mumbai; set one(where=(loc='mumbai')); run;
... View more