topic Re: subsetting multiple rows in a dataset in SAS Programming

subsetting multiple rows in a dataset

DingDing — Tue, 30 Aug 2016 07:34:47 GMT

I am wondering how to subset multiple rows in a dataset in SAS, any codes recommended? Thanks!

Re: subsetting multiple rows in a dataset

Kurt_Bremser — Tue, 30 Aug 2016 08:00:16 GMT

Please supply some example "have" and "want" data rows to illustrate your question.

Subsetting datasets as such is a very easy task, so you seem to have some additional requirements.

Re: subsetting multiple rows in a dataset

Astounding — Tue, 30 Aug 2016 13:29:40 GMT

Take a look at the WHERE statement. That's a common tool for the task, and can be used in both DATA and PROC steps. Its chief limitation is that it must base the subsetting decisions on variables that already exist in the incoming data set.

If you need to perform calculations first, and base the subsetting on the calculated values, take a look at the IF statement. (Not IF/THEN.) It's valid in a DATA step only.

Re: subsetting multiple rows in a dataset

LinusH — Tue, 30 Aug 2016 13:50:48 GMT

Another option if you wish to subset based on a list of values: use SQL inner join/sub-query with a look-up table.