Looking for a SAS function

[Jim_G]

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

[novinosrin · Accepted solution]

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;

[Jim_G]

Thank you @novinosrin

[art297]

@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

[Jim_G]

Thanks @art