## Looking for a SAS function

Solved
Frequent Contributor
Posts: 102

# Looking for a SAS function

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

Accepted Solutions
Solution
‎12-09-2017 01:54 PM
PROC Star
Posts: 1,570

## Re: Looking for a SAS function

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;

All Replies
Solution
‎12-09-2017 01:54 PM
PROC Star
Posts: 1,570

## Re: Looking for a SAS function

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;

Frequent Contributor
Posts: 102

## Re: Looking for a SAS function

Thank you @novinosrin
PROC Star
Posts: 8,146

## Re: Looking for a SAS function

@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

Frequent Contributor
Posts: 102

## Re: Looking for a SAS function

Thanks @art
☑ This topic is solved.