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

klharpe2 — Mon, 22 Feb 2016 17:27:38 GMT

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!

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

mohamed_zaki — Mon, 22 Feb 2016 17:33:44 GMT

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