topic Re: Looking for a SAS function in SAS Programming

Looking for a SAS function

Jim_G — Sat, 09 Dec 2017 18:51:26 GMT

Input string :$80.;

cards;

1,3,5,3,7,2,

22,32,34,45,

;

Is there a SAS function that tells me how many fields that I have on this line or how many commas I have on this line ?

The first line the function would return 6, second line 4.

Thanks Jim

Re: Looking for a SAS function

novinosrin — Sat, 09 Dec 2017 18:54:08 GMT

is my understanding of your question correct?

data h;
input string :$80.;
cards;
1,3,5,3,7,2,
22,32,34,45,
;

data w;
set h;
k=count(string, ',');
run;

Re: Looking for a SAS function

Jim_G — Sat, 09 Dec 2017 18:56:01 GMT

Thank you @novinosrin

Re: Looking for a SAS function

art297 — Sat, 09 Dec 2017 19:37:49 GMT

@Jim_G: FWIW, you can also use the COUNTW function. That way, you will get the same answer regardless of whether the line does or doesn't end with a comma. e.g.:

data h;
  input string :$80.;
  cards;
1,3,5,3,7,2,
22,32,34,45,
1,3,5,3,7,2
22,32,34,45
;

data w;
  set h;
  k=countw(string, ',','t');
run;

Art, CEO, AnalystFinder.com

Re: Looking for a SAS function

Jim_G — Sat, 09 Dec 2017 19:47:28 GMT

Thanks @art