DATA Step, Macro, Functions and more

Looking for a SAS function

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 102
Accepted Solution

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;

View solution in original post


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

Posted in reply to novinosrin
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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 174 views
  • 1 like
  • 3 in conversation