topic Re: drop observations with certain value in SAS Programming

drop observations with certain value

Nieves — Sat, 26 Aug 2017 02:55:20 GMT

Hi,

I have a data set data1 and want to drop observations where month larger than t, and save the new data as data2.

How shall I do this?

Thanks

Re: drop observations with certain value

Jagadishkatam — Sat, 26 Aug 2017 03:17:56 GMT

Please provide a sample data of the variables you have with values. This will help to get better responses. Without the data it is very difficult to suggest the code.

Re: drop observations with certain value

Shmuel — Sat, 26 Aug 2017 05:27:18 GMT

Is January 2017 greater then December 2016 ?

Are you comparing just the month or the date ?

In what format is your date? Is Character? numeric? sas date?

If it is a character date - is it ddmmyy mmddyy or any othe format ?

The code will change according to your answer.

The best is to post example of your data.

Re: drop observations with certain value

KachiM — Sat, 26 Aug 2017 13:58:08 GMT

Suppose you are interested to drop all observations of SASHELP.CLASS where AGE = 14 to get new data as myclass.

data myclass;

set sashelp.class;

where AGE ^= 14;

run;

If you interested to drop those whose SEX = 'M' then do:

data myFemale;

set sashelp.class;

where Sex ^= 'M';

run;

Re: drop observations with certain value

Yavuz — Sat, 26 Aug 2017 15:13:13 GMT

Data data2;
Set data1;
If (month>t) then output data2;
Run;