topic Re: What is wrong with my if, then, delete statement? in New SAS User

What is wrong with my if, then, delete statement?

mkit8 — Tue, 24 Mar 2020 07:51:27 GMT

Hello,

I am a new SAS user and am stumped on why my 'if then delete' statement is not working for the 'primary_site_labeled' variable.

Please see the attached PDF of my code.

I had the same problem with the 'age_recode_with_1_year_olds' variable, until I wrote a separate statement for each value that I wanted to be deleted, but I obviously don't want to write out every value for the 'primary_site_labeled' variable.

I also tried writing two statements (one with '<180' and the other with '>209') but then it said that there were no observations in my data set (there should still be hundreds of thousands).

Thanks,

Melody

Re: What is wrong with my if, then, delete statement?

Patrick — Tue, 24 Mar 2020 08:01:35 GMT

Welcome to the SAS Communities.

Can you please post your code using the running man icon

This gives us access to your code as properly formatted text so we can provide the amended code as answer without having to re-type it from some PDF. It's an easy fix.

Re: What is wrong with my if, then, delete statement?

Patrick — Tue, 24 Mar 2020 08:10:36 GMT

Ok, did the typing now. But please post next time code using the running man.

data save.new2;
  set save.new;
  if age_recode_with_1_year_olds in (0,1,2,3,4,29) then delete;
  else if 0<=primary_site_labeled<=179 then delete;
  else if 201<=primary_site_labeled<=809 then delete;
run;

You could also write it this way:

data save.new2;
  set save.new;
  if age_recode_with_1_year_olds in (0,1,2,3,4,29) 
    or 0<=primary_site_labeled<=179 
    or 201<=primary_site_labeled<=809 then
    delete;
run;

Re: What is wrong with my if, then, delete statement?

mkit8 — Tue, 24 Mar 2020 08:19:09 GMT

Thank you so much, Patrick! That works perfectly. I appreciate your help.

I'll make sure to share my code properly next time.

Melody

Re: What is wrong with my if, then, delete statement?

Patrick — Tue, 24 Mar 2020 08:36:49 GMT

Hi Melody,

Glad that it helped. And now the last step for how these SAS Forums work: If an answer resolves your problem then accept it as solution. This not only shows everybody else that this question is answered, it also helps people searching existing discussions for answers to quickly get to a post which provides a solution.

Cheers,

Patrick