topic split observations as single datasets in SAS Programming https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867399#M342579 <PRE><CODE class=" language-sas">data split_obs; input name $ city$ ; datalines; A mumbai B chennai C pune D chennai F mumbai ; run; </CODE></PRE> <P>i want split observations as single dataset with name&nbsp;</P> <P>like A dataset with&nbsp; name and city&nbsp;</P> Fri, 31 Mar 2023 09:31:44 GMT BrahmanandaRao 2023-03-31T09:31:44Z split observations as single datasets https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867399#M342579 <PRE><CODE class=" language-sas">data split_obs; input name $ city$ ; datalines; A mumbai B chennai C pune D chennai F mumbai ; run; </CODE></PRE> <P>i want split observations as single dataset with name&nbsp;</P> <P>like A dataset with&nbsp; name and city&nbsp;</P> Fri, 31 Mar 2023 09:31:44 GMT https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867399#M342579 BrahmanandaRao 2023-03-31T09:31:44Z Re: split observations as single datasets https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867400#M342580 <P>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</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data split_obs; input name $ city$ ; datalines; A mumbai A mumbai A pune B chennai C pune D chennai F mumbai ; run;</CODE></PRE> Fri, 31 Mar 2023 09:34:39 GMT https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867400#M342580 PeterClemmensen 2023-03-31T09:34:39Z Re: split observations as single datasets https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867403#M342583 <P>I want those observations separated with single observation with cityname of the dataset</P> <P>ex data_mumbai&nbsp; &nbsp; &nbsp; contains&nbsp; Name&nbsp; &nbsp; &nbsp;City</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mumbai&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>like that</P> Fri, 31 Mar 2023 09:57:24 GMT https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867403#M342583 BrahmanandaRao 2023-03-31T09:57:24Z Re: split observations as single datasets https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867404#M342584 <P>Why? Having data as single lines in many data sets makes your programming harder.</P> Fri, 31 Mar 2023 09:47:42 GMT https://communities.sas.com/t5/SAS-Programming/split-observations-as-single-datasets/m-p/867404#M342584 PaigeMiller 2023-03-31T09:47:42Z