topic Sub-setting data in SAS Programming

Sub-setting data

Ashokburnwal — Fri, 05 Mar 2021 11:13:59 GMT

I have a dataset which has a variable name city which contains more than 100 city names. How can I create tables by subsetting data according to each city for all the unique city names in city variable.

Re: Sub-setting data

andreas_lds — Fri, 05 Mar 2021 11:29:42 GMT

Do you want to create datasets or tables (a report)?

For the later: sort by "city" and use proc print with by-statement.

Re: Sub-setting data

Ashokburnwal — Fri, 05 Mar 2021 12:01:45 GMT

Create datasets.

Re: Sub-setting data

Amir — Fri, 05 Mar 2021 13:11:50 GMT

Hi @Ashokburnwal.,

The following code attempts to do what you require, making use of the sashelp.class data step as input and splitting it up by sex.

/* use sql to construct required data set names and output logic */
proc sql noprint;
   select distinct
       cat('ds_',sex)
      ,cat('when (', quote(sex), ') output ds_', sex)
   into
       :ds_names     separated by ' '
      ,:output_logic separated by ';'
   from
      sashelp.class
   ;
quit;

options symbolgen;

/* use the macro variables created in the sql in a data step with a select statement */
data &ds_names ds_issue;
   set sashelp.class;

   select(sex);
      &output_logic;
      otherwise output ds_issue;
   end;
run;

Kind regards,

Amir.

Re: Sub-setting data

Kurt_Bremser — Fri, 05 Mar 2021 14:18:59 GMT

@Ashokburnwal wrote:
Create datasets.

And why?

Mind that in about 90% of cases, splitting a dataset is not needed.

They only time in 20+ years of SAS work where I had to split a dataset was when it grew so much that sorting it in one piece cracked my quota in UTILLOC.