I have a variable in a text format..But it contains both numeric formats and text. I want to find out how many in that field are missing or blanks or null, regardless if they are ibn text format or numeric. If I use the is not missing and is not null, I also lose the numeric values in that field. Thanks
HAVE:
VAR1
abcd
dget
hfok
.
2343
/
jdio
4589
WANT:
abcd
dget
hfok
2343
/
jdio
4589
I probably don't understand what you are asking. For your example, not missing would suffice. e.g.:
data have;
infile cards truncover;
input VAR1 $;
cards;
abcd
dget
hfok
.
2343
/
jdio
4589
;
data want;
set have;
if not missing(var1);
run;
You can get it by enumerate the missing value you treat as missing value.
data have; infile cards truncover; input VAR1 $char8.; cards; abcd dget hfok . 2343 / jdio 4589 ; data want; set have; if left(var1) in ('.' ' ') then delete; run;
Ksharp
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.