data split_obs;
input name $ city$ ;
datalines;
A mumbai
B chennai
C pune
D chennai
F mumbai
;
run;
i want split observations as single dataset with name
like A dataset with name and city
So you want 5 separate data sets from this 1 data set? Also, what if more than one observation had the same name? And same Name and City? Like below
data split_obs;
input name $ city$ ;
datalines;
A mumbai
A mumbai
A pune
B chennai
C pune
D chennai
F mumbai
;
run;
I want those observations separated with single observation with cityname of the dataset
ex data_mumbai contains Name City
A mumbai
like that
Why? Having data as single lines in many data sets makes your programming harder.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.