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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.