Help using Base SAS procedures

How do I delete missing data when reading in data from SPSS?

Accepted Solution Solved
Reply
New User
Posts: 1
Accepted Solution

How do I delete missing data when reading in data from SPSS?

How do I delete missing data when I read in data from SPSS?

 

This is my syntax now:

 

proc import
datafile="S:\DEWL.sav"
DBMS=sav
out=d
replace;
run;

 

I want to tell SAS to delete any observations that have missing data for 30 variables. I am using SAS 9.

 

Thanks!


Accepted Solutions
Solution
‎02-22-2016 12:53 PM
Super Contributor
Posts: 490

Re: How do I delete missing data when reading in data from SPSS?

data want;
 set d;
 if cmiss(of _all_) then delete;
run;

View solution in original post


All Replies
Solution
‎02-22-2016 12:53 PM
Super Contributor
Posts: 490

Re: How do I delete missing data when reading in data from SPSS?

data want;
 set d;
 if cmiss(of _all_) then delete;
run;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 219 views
  • 1 like
  • 2 in conversation