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
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;
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: 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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.