Date:         Mon, 1 Oct 2007 13:50:37 -0700
Reply-To:     "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject:      Why the quoted string length WARNING?
Content-Type: text/plain; charset="us-ascii"

Ok gang,

Why the WARNING?

I have also tried adding %unquote() in a couple places 
just in case it is referring to macro quoting, but it turns
out not to help.

I have also tried adding LENGTH AVAILABLE $5000;
which does not help either.

WIN v8.2 yields a message denoting a length more than 262.
AIX  v8.2 yields a message denoting a length more than 512.


So I'm drawing a blank.  Why the truncation and WARNING?


Is this a v8.2 INTO: issue?





proc sql noprint;
    select
           upcase(name) into :MYVARS separated by ","
    from
           dictionary.columns
    where
           lowcase(libname) eq 'work'
    and
           lowcase(memname) eq 'sample'
    ;
quit;
%put MYVARS is (%length(&MYVARS)); * 2499 ;
%put MYVARS is >&MYVARS<;
data _null_;
    available = "&MYVARS";
run;
    
263      available = "&MYVARS";
NOTE: Line generated by the macro variable "MYVARS".
1
"S001,S002,S003,S004,S005,S006,S007,S008,S009,S010,S011,S012,S013,S014,S
015,S016,S017,S018,
 
------------------------------------------------------------------------
-------------------
      32
1  !
S019,S020,S021,S022,S023,S024,S025,S026,S027,S028,S029,S030,S031,S032,S0
33,S034,S035,S036,S0
1  !
37,S038,S039,S040,S041,S042,S043,S044,S045,S046,S047,S048,S049,S050,S051
WARNING 32-169: The quoted string currently being processed has become
more than 262 characters
                long.  You may have unbalanced quotation marks.

264  run;




I can always do an alternative and avoid any warning messages such as:


data _null_;
    length stmp $5000;
    retain stmp '';
    set sashelp.vcolumn end=done;
    if lowcase(libname) eq 'work'
    and lowcase(memname) eq 'sample' then
        stmp = trim(stmp)||","||upcase(trim(name));
    if done then
        do;
            call symput('MYVARS2',trim(substr(left(stmp),2)));
        end;
run;
%put MYVARS2 is (%length(&MYVARS2)); * 2499 ;
%put MYVARS2 is >&MYVARS2<;



But it still hasn't come to me why the truncation and WARNING?






Mark Terjeson
Senior Programmer Analyst, IM&R
Russell Investments
253-439-2367


Russell
Global Leaders in Multi-Manager Investing

> The information contained in this message is intended only for the use
> of the recipient named above.  This message may contain confidential
> or undisclosed information.  If the reader of this message is not the
> intended recipient or an agent responsible for delivering to the
> intended recipient, you are hereby notified that you have received
> this message in error, and that any review, dissemination,
> distribution or copying of it is strictly prohibited.  If you have
> received this message in error, please notify us by telephone
> immediately at 253-439-2367. Thank you for your cooperation.
> 
> 
> 
>