topic Re: Output Parts of a String in Developers

Output Parts of a String

DavidPhillips2 — Wed, 20 May 2015 20:53:42 GMT

In SAS 9.2

Is there a simple way to split a string?

E.g.

%Let baseString = D1 D2 D3;

For I = 0 to end;

Output D1 the first time;

Output D2 the second time;

Output D3 the third time;

End loop;

I do not want to do this in a data step.

Re: Output Parts of a String

BrunoSilva — Wed, 20 May 2015 20:59:32 GMT

Hello,

How about using macro?

Best regards

Re: Output Parts of a String

Tom — Wed, 20 May 2015 21:07:40 GMT

SCAN() or %SCAN()

data _null_;

basestring='D1 D2 D3';

do i=1 to countw(basestring);

word = scan(basestring,i);

put i= word=;

end;

run;

%do i=1 %to %sysfunc(countw(&basestring));

%let word = %scan(&basestring,&i);

%put i=&i word=&word;

%end;

Re: Output Parts of a String

KenDodds — Wed, 20 May 2015 21:42:08 GMT

Here is a macro that I use that also puts everything you might need into macro variables. (I have just improved it a bit by stealing Tom's idea of using countw).

%MACRO makelist(base,list);

* create a set of macro variables named base1, base2 ... with values from list + list returned as <base>list;

%PUT &base &list;

%GLOBAL n&base &base.list;

%LET &base.list =&list;

%LET n&base=%sysfunc(countw(&list));

%DO i=1 %TO &&n&base;

%GLOBAL &&base&&n&base;

%LET &&base&&n&base=%SCAN(&list,&&n&base);

%END ; ;

%PUT n&base = &&n&base;

%DO i=1 %TO &&n&base; %PUT &base&i &&&base&i; %END;

%MEND;

%makelist(test,D1 D2 D3);

Then you can reference them with a loop in a macro eg. ...

PROC MEANS;

VAR &testlist; * D1 D2 D3;

OUTPUT OUT=testmeans MEAN=%DO I=1 %TO &ntest; &&test&i..m %END; ;

The output dataset contains means in the variables D1m D2m and D3m.

Re: Output Parts of a String

Astounding — Thu, 21 May 2015 12:34:36 GMT

A reference that might help:

http://blogs.sas.com/content/publishing/2015/01/30/sas-authors-tip-getting-the-macro-language-to-perform-a-do-loop-over-a-list-of-values/

Re: Output Parts of a String

DavidPhillips2 — Tue, 26 May 2015 17:52:51 GMT

data _null_;

degStudLevComma = "aa,b,a";

total = countc(&degStudLevComma, ',');

put "&total";

run;

In order to know when to end going through my string I need to use countc. My string is delimited by commas. When I do this I receive an error that I have too many arguments. I’m guessing this is because my variable has commas in it that are acting like variable separators.

Re: Output Parts of a String

Tom — Tue, 26 May 2015 18:03:05 GMT

You want the countW() function to see how many items are in your list. You can included commas if they are properly quoted.

Re: Output Parts of a String

DavidPhillips2 — Tue, 26 May 2015 18:28:45 GMT

This worked.

data _null_;

degStudLevComma = "D1,D2";

total = countw(degStudLevComma, ',');

put total;

run;

%macro testMacro();

%let degStudLevComma = "D1,D2";

%let total = %sysfunc(countw(&degStudLevComma, ','));

%put total &total;

%mend;

%testMacro();

Re: Output Parts of a String

Tom — Tue, 26 May 2015 18:41:01 GMT

Example with embedded commas.

%let x=This,list,has,"5, not 6 or 7,",words;

%let n=%sysfunc(countw(%superq(x),%str(,),qm));

%put &=n;

N=5