topic Re: split datasets by city wise with total no of observations in SAS Programming

split datasets by city wise with total no of observations

pavank — Thu, 04 Jul 2024 06:19:51 GMT

data cities;
    input city $;
    datalines;
chennai
mumbai
pune
chennai
mumbai
pune
;
run;

data chennai(keep=city) mumbai(keep=city) pune(keep=city);
    set cities;
    do i = 1 to 6;
        if city = 'chennai' then output chennai;
        else if city = 'mumbai' then output mumbai;
        else if city = 'pune' then output pune;
    end;
run;

Hi Experts,

Good Morning

Using above cites dataset i want split by city wise with total no of observations as per my code it gives 12 observations i want 6 observation for each city dataset in this case city dataset has 6 observations

i didn't get how to get total observations per each individual city

required output

Re: split datasets by city wise with total no of observations

andreas_lds — Thu, 04 Jul 2024 06:50:05 GMT

Each city appears twice in the data, for each observation the loop writes six obs to the city-datasets => 12 obs in each dataset.

Re: split datasets by city wise with total no of observations

pavank — Thu, 04 Jul 2024 07:53:57 GMT

data cities;
    input city $;
    datalines;
chennai
mumbai
pune
nodia
;
run;

data chennai mumbai pune noida;
    set cities nobs=nobs;
    do i = 1 to nobs;
        if city = 'chennai' then output chennai;
        else if city = 'mumbai' then output mumbai;
        else if city = 'pune' then output pune;
        else if city='nodia' then output noida;
    end;drop i;
run;

Hi @andreas_lds

Thank you I got it

Re: split datasets by city wise with total no of observations

mkeintz — Thu, 04 Jul 2024 22:33:07 GMT

@pavank wrote:

data cities;
    input city $;
    datalines;
chennai
mumbai
pune
nodia
;
run;

data chennai mumbai pune noida;
    set cities nobs=nobs;
    do i = 1 to nobs;
        if city = 'chennai' then output chennai;
        else if city = 'mumbai' then output mumbai;
        else if city = 'pune' then output pune;
        else if city='nodia' then output noida;
    end;drop i;
run;

You could eliminate ~~replace~~ the collection of IF and ELSE IF statements by using "where" parameters in the output dataset names:

data  chennai (where=(city='chennai'))  mumbai (where=(city='mumbai'))
      pune    (where=(city='pune'))     nodia  (where=(city='nodia')) ;
  set cities nobs=nobs;
  do i=1 to nobs;
    output;
  end;
  drop i;
run;