Deleting observations with missing values using "if' statements

aongkeko — Thu, 28 Nov 2019 00:39:44 GMT

Hi,

It's me again the student newbie in SAS.

There are quite a number of issues and answers around this question but I am not familiar with the proc sql yet. I merged two big data sets that I need to analyze but all of of the variables have missing data. I am just wondering if there is a way to delete them in one go using the if-then statements? Below is my code for your reference. Appreciate any assistance! Thank you!

Filename F1 'C:\Users\among\OneDrive\Desktop\Study1_1.txt';
data study1;
infile F1;
infile F1 dsd dlm=',';
infile F1 missover;
input Patient_ID Age State $ Length_of_Stay Total_Charge;
run;
proc print data=study1;
run;

Filename F2 'C:\Users\among\OneDrive\Desktop\Study2_2.txt';
data study2;
infile F2;
infile F2 dsd dlm=',';
infile F2 missover;
input Patient_ID Group $ Test_Score;
run;
proc print data=study2;
run;

proc sort data=study1;
by Patient_ID;
run;
proc sort data=study2;
by Patient_ID;
run;

data final;
merge study1 study2;
by Patient_ID;
run;

proc print data=final;
run;

<successfully merged the data> but a lot of missing observations in all of the variables: Age State Length_of_Stay Total_Charge Group and Test_Score>

I tried

data final_1;
set final;
if Age=. then delete;
if State='' then delete;
if Length_of_Stay=. then delete;
if Total_Change=. then delete;
if Group='' then delete;
If Test_Score=. then delete;
run;

but it didn't work 🙂

Re: Deleting observations with missing values using "if' statements

Astounding — Thu, 28 Nov 2019 01:23:14 GMT

First step: combine the INFILE statements. For example:

infile F1 dsd missover;

As it stands now, each statement replaces the earlier statement, instead of adding to it.

topic Deleting observations with missing values using "if' statements in SAS Programming

Deleting observations with missing values using "if' statements

Re: Deleting observations with missing values using "if' statements