topic Re: How to scan for a specific work or number in SAS Programming

How to scan for a specific work or number

binhle50 — Tue, 09 May 2023 15:53:25 GMT

I have this data:

data have;
input test $25. ;
cards;
0 | 0 | 0 | 0 | 0
0 | 1 | 0
1
2
0 | 24 | 0
0 | 0 | 0 | 23
0 | 0| 23 | 24 | 1
0 | 0
0 | 0 | 1
0
27
;
run;

And I want to have this:

data want;
input test $22. want 4. ;
cards;
0 | 0 | 0 | 0 | 0 1
0 | 1 | 0 0
1 0
2 0
0 | 24 | 0 0
0 | 0 | 0 | 23 0
0 | 0 | 23 | 24 | 1 0
0 | 0 1
0 | 0 | 1 0
0 1
27 0
;
run;

The values were separated by " | " and I need to find what obs that have ONLY zero. I tried to use a couple of procedures but NONE seems working properly. If anyone can help I would highly appreciate!

Best,

Re: How to scan for a specific work or number

yabwon — Tue, 09 May 2023 15:57:23 GMT

data have;
input test $25. ;
cards;
0 | 0 | 0 | 0 | 0
0 | 1 | 0
1
2
0 | 24 | 0
0 | 0 | 0 | 23
0 | 0| 23 | 24 | 1
0 | 0
0 | 0 | 1
0
27
;
run;
proc print;
run;

data want;
  set have;
  want=^lengthn(compress(test,"0|","s"));
run;
proc print;
run;

Re: How to scan for a specific work or number

binhle50 — Tue, 09 May 2023 16:03:10 GMT

Awesome! Thanks so much. It works perfectly

Re: How to scan for a specific work or number

Ksharp — Wed, 10 May 2023 13:08:24 GMT

For having some fun.

data have;
input test $25. ;
cards;
0 | 0 | 0 | 0 | 0
0 | 1 | 0
1
2
0 | 24 | 0
0 | 0 | 0 | 23
0 | 0| 23 | 24 | 1
0 | 0
0 | 0 | 1
0
27
;
run;


data want;
  set have;
  want=verify(test,"0| ")=0;
run;

proc print;
run;

Re: How to scan for a specific work or number

binhle50 — Wed, 10 May 2023 13:49:22 GMT

Wow that is fun. Awesome! Thanks!