data have;
input Name $ Gender $ City $12.;
datalines;
Srilakshmi Female Hyderabad
Vamika Female Bangalore
Prajwal Male Mumbai
;
run;
data want;
set have;
City = substr(City, 1, 1);
Gender = substr(Gender, 1, 1);
Name = substr(scan(Name, 1), 1, 1);
drop Name Gender City;
left_to_right=catx(' ',name,gender,city);
right_to_left=catx(' ',city,gender,name);
run;
Hi Guys ,
Here i want to extract first letter from each variable left to right and right to left
is it correct way or any other method to achieve could you please give solution
... View more