| Date: | Thu, 29 Sep 2005 10:06:37 -0400 |
|---|
| Reply-To: | Chang Chung <chang_y_chung@HOTMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Chang Chung <chang_y_chung@HOTMAIL.COM> |
|---|
| Subject: | Re: Quoting Conundrum |
|---|
|
On Thu, 29 Sep 2005 07:58:13 -0600, Michael Murff <mjm33@MSM1.BYU.EDU>
wrote:
>Hi SAS Aficionados,
>
>
>
>The following code actually works but the ubiquitous warnings are making me
>see green. I've tried a few of the quoting functions to eliminate the
>warnings, but with little success.
Hi, Michael,
You can mask most of them at the beginning with %superq(). HTH.
Cheers,
Chang
data embedamper;
input coname$;
datalines;
B&B
IBM
USSTEEL
;
run;
%macro ToomanyWarnings;
proc sql noprint;
select distinct coname
into :colist separated by ' '
from embedamper;
quit;
%let colist = %superq(colist); /* fixed */
%put &colist;
%let count=0;
%do %while(%qscan(&colist,&count+1,%str( )) ne %str());
%let count=%eval(&count+1);
%end;
%do i = 1 %to &count;
%let comp = %qscan(&colist,&i, %str( )); /* fixed */
%put ∁
%end;
%mend;
%ToomanyWarnings
/* on log -- (what warnings?)
B&B IBM USSTEEL
B&B
IBM
USSTEEL
*/
|
