topic Re: deleting observations in Dataset based on a category in SAS Programming

deleting observations in Dataset based on a category

ChuksManuel — Fri, 16 Nov 2018 08:03:15 GMT

Please i have a dataset in which i want to keep only people who are aged from 0-5. The data set have list of people up to 17 years but i just want to create a dataset of only kids that are aged 0-5 and for the data-set to retain all the variables. The age variable is is sc_age.

I initially tried using the "where" statement in the larger data step to specify the category but it was not helpful as i will want to run a logistic regression later.

Please how do i go about this and any help will be appreciated.

Re: deleting observations in Dataset based on a category

PeterClemmensen — Fri, 16 Nov 2018 08:11:24 GMT

Since I cant see your data, this code is untested.

data want;
   set have;
   where age between 0 and 5;
run;

Re: deleting observations in Dataset based on a category

Shmuel — Fri, 16 Nov 2018 08:14:32 GMT

Have you tried to subset the 0-5 age, using where statement, into a separate data-set

to be used for the regression?

data age0_5;
  set have (where=(sc_age le 5); /* or between 0 and 5 - to exclude missing */
run;