Sorry I realize now this is not quite right since the "d" function is
interpreting the label as May 9 2007.
On 9/11/07, Tim Wade <[email protected]> wrote:
> Dan, does something like this work?
>
> . input v1 v2 v3 v4 v5
>
> v1 v2 v3 v4 v5
> 1. 1 2 3 4 5
> 2. end
>
> . label var v1 "9/5/2007"
>
> . label var v2 "9/4/2007"
>
> . label var v3 "9/6/2007"
>
> . label var v4 "9/7/2007"
>
> . label var v5 "9/8/2007"
>
> . foreach var of varlist v1-v5 {
> 2. local lab`var': variable label `var'
> 3. local lab`var'=d(`lab`var'')
> 4. local lab`var': display %d `lab`var''
> 5. rename `var' rev_`lab`var''
> 6. }
>
> . desc
>
> Contains data
> obs: 1
> vars: 5
> size: 24 (99.9% of memory free)
> -------------------------------------------------------------------------------
> storage display value
> variable name type format label variable label
> -------------------------------------------------------------------------------
> rev_09may2007 float %9.0g 9/5/2007
> rev_09apr2007 float %9.0g 9/4/2007
> rev_09jun2007 float %9.0g 9/6/2007
> rev_09jul2007 float %9.0g 9/7/2007
> rev_09aug2007 float %9.0g 9/8/2007
> -------------------------------------------------------------------------------
> Sorted by:
> Note: dataset has changed since last saved
>
> Hope this helps, Tim
>
>
> On 9/7/07, Rodriguez, Dan <[email protected]> wrote:
> >
> >
> > I have a comma-delimited datafile that I need to process on a daily basis
> > within Stata where I need to convert the labels for about 200 columns into
> > variable names. The file looks like the following:
> >
> > acct name 9/5/2007 9/4/2007 8/31/2007
> > 84J Jacky 1 2 -1
> > B88 Mike -2 3 -1
> > B93 Mike 4 5 2
> >
> >
> > When I import this file into Stata I get:
> >
> > acct name v18 v19 v20
> > 84J Jacky 1 2 -1
> > B88 Mike 0 0 0
> > B93 Mike 0 0 0
> >
> > . desc
> >
> > Contains data
> > obs: 1,495
> > vars: 190
> > size: 1,728,220 (83.5% of memory free)
> > -------------------------------------------------------------------------------
> > storage display value
> > variable name type format label variable label
> > -------------------------------------------------------------------------------
> > acct str8 %9s Trading Acct
> > name str53 %53s Trader
> > v18 float %9.0g 9/5/2007
> > v19 float %9.0g 9/4/2007
> > v20 float %9.0g 8/31/2007
> > v21 float %9.0g 8/30/2007
> > v22 float %9.0g 8/29/2007
> > v23 float %9.0g 8/28/2007
> > v24 float %9.0g 8/27/2007
> > v25 float %9.0g 8/24/2007
> > v26 float %9.0g 8/23/2007
> > v27 float %9.0g 8/22/2007
> > v28 float %9.0g 8/21/2007
> > v29 float %9.0g 8/20/2007
> >
> > How can I change the variable names to rev_Sep5_2007, rev_Sep4_2007,
> > rev_Aug31_2007, etc.?
> >
> > I need to apply a reshape command to facilitate further analysis.
> >
> > Thank you,
> > Dan Rodriguez
> >
> > ==============================================================================
> Please
> > access the attached hyperlink for an important electronic communications
> > disclaimer:
> >
>
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> ==============================================================================
> >
> >
> >
>
*
* 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/
