==========================================================
=========================================================================
Date:         Tue, 18 Feb 2003 14:43:40 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Re: Problem when using proc datasets
Content-type: text/plain; charset=iso-8859-1

on the other hand it is only a warning.
Even in v6, macro vars can become wider than 262.
The only quoted string among the "select" components
arrears to be the '=' and the "separated by " value

As a warning, it should not cause errors.

So, where a very wide macro variable  is used, there is a
good chance of truncation and unbalanced quote marks.
When faced with the same issue in v6, where the limit was
32K,  I had to generate and use an array of macro vars.
In v8 there is discussion over a 64K limit.......


HTH
Peter Crawford



Datum:         18/02/2003 01:12
An:            SAS-L@LISTSERV.UGA.EDU




Antwort an:    Robert Virgile <virgile@RCN.COM>

Betreff:       Re: Problem when using proc datasets
Nachrichtentext:

Sounds like you have identified the problem:  you have exceeded the
length of a character string that SAS can handle.  You don't mention how
many variables might be involved, or what version of SAS you are using.
The maximum length changes, depending on the release of SAS.

Good luck.

Bob V.


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@listserv.uga.edu] On Behalf Of Art
Shen
Sent: Monday, February 17, 2003 4:46 PM
To: SAS-L@listserv.uga.edu
Subject: Problem when using proc datasets

I have two data sets : (1) MYSET and (2) LABSET, which has two variables
VARNAME and LABELNAME matching the name and label of MYSET. I wrote the
following script to dynamicly add lables to variables of MYSET.
-------------------------
 proc sql;
   select trim(varname)||"="||trim(labelname)
   into :newlabel
   separated by " "
   from mylib.labelset;
quit;

proc datasets library=mylib;
   modify myset;
   label &newlabel;
 run;
quit;
----------------------------
It works at most of the time. However, when the string length stored in
:newlabel is over a limit, I get an error message:

WARNING 32-169: The quoted string currently being processed has become
more
than 262 characters long.  You may have unbalanced quotation marks

Does anyone have any ideas?

Art





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.