st: Re: length of a string

[Kit Baum <baum@bc.edu>]

As -help limits- shows, a macro can contain at least 165,000  
characters. So pull the string variables' contents into a local macro  
and write them out with the -file- command.


. local one = string1[1]

. di "`one'"
I need to generate a string variable based on the values of another  
ones, but the length of
>  a string is limited to 244 characters (the resulting variable has  
to have more than 244
> characters). Who knows, what can I do?

. local two = string2[1]

. di "`two'"
I NEED TO GENERATE A STRING VARIABLE BASED ON THE VALUES OF ANOTHER  
ONES, BUT THE LENGTH OF
>  A STRING IS LIMITED TO 244 CHARACTERS (THE RESULTING VARIABLE HAS  
TO HAVE MORE THAN 244
> CHARACTERS). WHO KNOWS, WHAT CAN I DO?

. local both `one' `two'

. di "`both'"
I need to generate a string variable based on the values of another  
ones, but the length of
>  a string is limited to 244 characters (the resulting variable has  
to have more than 244
> characters). Who knows, what can I do? I NEED TO GENERATE A STRING  
VARIABLE BASED ON THE
> VALUES OF ANOTHER ONES, BUT THE LENGTH OF A STRING IS LIMITED TO  
244 CHARACTERS (THE RESU
> LTING VARIABLE HAS TO HAVE MORE THAN 244 CHARACTERS). WHO KNOWS,  
WHAT CAN I DO?

Note that local both is longer than 244. You can now write it to an  
external file with the file command.

Kit

Kit Baum, Boston College Economics and DIW Berlin
http://ideas.repec.org/e/pba1.html
An Introduction to Modern Econometrics Using Stata:
http://www.stata-press.com/books/imeus.html


On Feb 4, 2008, at 2:33 AM, statalist-digest wrote:


> The problem is that I should prepare the file to be imported in a  
> local made
> software (in Oracle). This suppose to obtain a string in which I  
> put the sql
> command and all the information from my variables. I solved this  
> problem by
> creating two string variables and then in Excel I put the  
> information from
> both together. But, I want to do this in an automatic manner.
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/