I have 26 variables that contain some observations as NA. Is there a way (
olther than "
drop if var==NA" for each variable)
to drop all observations that contain "NA"s for any variable?Code:
* Example generated by -dataex-. To install: ssc install dataex clear input double id str17 mtb0 str9(ebv0 debt0 ebit0 ta1 ni1) str8 cfo1 302319 "NA" "-1364" "376" "-1055" "117" "-476" "-278" 303063 ".83" "-544" "952" "-2402" "1486" "-667" "-1365" 282874 "238.15" "200229" "32358" "35823" "260814" "30219" "1883" 214440 "261.88" "164534" "0" "6766" "166933" "6752" "-3199" 378443 "1394.28" "2887794" "0" "-760338" "11451238" "-391191" "350907" 301631 "81305.81" "16763000" "7864000" "7905000" "35994000" "5142000" "6999000" 283489 "6.9" "NA" "NA" "NA" "9699" "-21888" "-9224" end
0 Response to Droping "NA"s
Post a Comment