topic Re: Keeping data in SAS Programming

Keeping data

Barkamih — Thu, 06 Dec 2018 16:23:26 GMT

Hil all

I'm Looking for your help by using this code.

this variable main_breed has many different names, I just want to keep only records that have HO and FR, So, I'm using this code and it worked perfectly to keep HO bata by using main_breed information,

my question How I can keep HO and FR together by editing this code?

regards

data Want;
set have;
if main_breed  ne 'HO' then delete;
run;quit;

Re: Keeping data

PeterClemmensen — Thu, 06 Dec 2018 16:25:20 GMT

Like this?

data Want;
set have;
where main_breed in ('HO', 'FR');
run;

Re: Keeping data

Reeza — Thu, 06 Dec 2018 16:26:38 GMT

In and NOT IN.

https://documentation.sas.com/?docsetId=lrcon&docsetTarget=p00iah2thp63bmn1lt20esag14lh.htm&docsetVersion=9.4&locale=en#p0xgxvo2we2mqrn1kteecpv1opx0

Re: Keeping data

r_behata — Thu, 06 Dec 2018 16:28:14 GMT

This code will write to the output where the main_breed is both HO and FR.

data Want;
set have;
if main_breed  in ('HO','FR') ;
run;

Re: Keeping data

ShiroAmada — Mon, 10 Dec 2018 09:06:17 GMT

Try this.

data Want;
set have;
where upcase(main_breed)  in ('HO','FR');
run;

What I did:

#1. Remove the quit; statement. Why? It's not required in the data step.

#2. I replaced IF with a WHERE condition. Why? IF or WHERE will work but I think WHERE is more appropriate.

#3. I include a character function UPCASE. Why? This is to standardize the values to "HO" and "FR". Unless "ho" and "HO" in your records are 2 separate codes.

Also, you might want to try PROC SQL. Optionally, you can sort the records too by using the order by clause.

proc sql;
  create table WANT as
select * from HAVE
where upcase(main_breed) in ("HO","FR");
*order by <insert a variable to sort.  user comma to delimit the 2 or more variables>;
quit;