12-09-2017 01:51 PM
Input string :$80.;
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.
12-09-2017 02:37 PM
@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
Need further help from the community? Please ask a new question.