topic Re: Filter register with only one character in a character variable in SAS Programming

Filter register with only one character in a character variable

ramgouveia — Tue, 11 Oct 2022 08:38:35 GMT

I want to identify the registers in a SAS dataset that in a character variable contains only zeros.

How can I do this?

Re: Filter register with only one character in a character variable

PaigeMiller — Tue, 11 Oct 2022 10:55:04 GMT

all zeros can be identified as

input(yourvariablename,?? best32.)=0

Re: Filter register with only one character in a character variable

Tom — Wed, 12 Oct 2022 00:08:06 GMT

@ramgouveia wrote:

I want to identify the registers in a SAS dataset that in a character variable contains only zeros.

How can I do this?

So the variable is filled with zeros? So if the variable is defined as length $10 it has 10 zeros?

Or do you also want the strings that have 9 zeros and those with 8 zeros?

Try this:

data test;
  input string $5. ;
cards;
1
0
00
000
0000
00000
.
;

data want;
 set test;
 want=  verify(string||'x','0')>length(string) ;
run;

proc print;
run;

Result

Obs    string    want

 1     1           0
 2     0           1
 3     00          1
 4     000         1
 5     0000        1
 6     00000       1
 7                 0

Re: Filter register with only one character in a character variable

ramgouveia — Wed, 12 Oct 2022 09:21:08 GMT

Thank you @Tom

This is some example of the data I have:

data test;
  input string $9. ;
cards;
1103355
15126465
17007959
17008064
505495945
506795233
510150497
7133364
8418202
000000000
A36002541
000000000
a94150422
0
00
000
0000
00000
;

Your solution is a good solution.

This is a character variable. So I converted it into a numeric variable and all the "kind of" zeros were converted into a single zero.

I used the following code:

data CONT;
    set CONT;

    NP_N = input(NP, best12.) ;
run;

Re: Filter register with only one character in a character variable

ramgouveia — Wed, 12 Oct 2022 09:22:21 GMT

Thank you @PaigeMiller

I will use it.