topic Re: Restrict a data set to a specific factor/label in ODS and Base Reporting

Restrict a data set to a specific factor/label

deleted_user — Thu, 01 Nov 2007 13:57:09 GMT

Hello,

I'm working with large datasets. With only a part of the dataset I want to do calculations. How can I filter or restrict my data set in such a manner that only the important data is included. I have columns with labels on which I can select.

e.g. a dataset:
Names dataA dataB
NameA 1 2
NameB 1 3
NameC 1 4
NameB 3 6
NameC 5 9
NameB 5 9
NameA 3 0
NameB 7 0

I want only the observations with the label NameB, thus the result must be the dataset:

Names dataA dataB
NameB 1 3
NameB 3 6
NameB 5 9
NameB 7 0

I tried some things with proc sort, but then the dataset is sorted according to the labels, but I want to exclude the data which have not the right label.

Thanks in advance,

Govert

Re: Restrict a data set to a specific factor/label

advoss — Thu, 01 Nov 2007 14:25:17 GMT

try something like:
proc sort data=instuff out=outstuff;
by var1 var2 ...;
where names = 'NameB';
run;

Re: Restrict a data set to a specific factor/label

deleted_user — Fri, 02 Nov 2007 09:37:08 GMT

I tried your suggestion yesterday night.

It works!

Thanks a lot!

govert

Re: Restrict a data set to a specific factor/label

deleted_user — Fri, 02 Nov 2007 12:23:26 GMT

Try This..

proc sql noprint;
create table dataset1 as
select * from dataset
where Names eq "NameB";
quit;

Srinu