topic delete missing/null blanks if numeric and text in SAS Procedures

delete missing/null blanks if numeric and text

podarum — Thu, 22 Dec 2011 16:23:22 GMT

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

delete missing/null blanks if numeric and text

art297 — Thu, 22 Dec 2011 16:36:07 GMT

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;

delete missing/null blanks if numeric and text

Ksharp — Fri, 23 Dec 2011 02:18:28 GMT

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