You used my first suggestion, not my corrected suggestion.
Nick
[email protected]
Dev Vencappa
> >>
> Nick, Scott
> thanks for your suggestions. I do not seem to be able to
> replicate your codes for what I want to do. My longer
> alternative was to do the following (this is only a subset, I
> have more files like these)
>
> local z "ARG ARM AUS AUT BGD BOL CAN CHL CHN CMR COL CRI CYP
> DNK ECU EGY ESP ETH FIN FRA GBR GER GRC GTM HKG HND HUN IDN
> IND IRL IRN ITA JOR JPN KEN KOR KWT LKA LVA MAC MAR MDA MEX
> MWI MYS NLD NOR NPL NZL PAK PAN PER PHL POL PRT ROM SGP SWE
> THA TTO TUR TWN URY USA VEN ZAF"
>
> foreach x of local z{
> insheet using "C:\World Bank TPD data\\`x'bilateral.csv", clear
> gen country="`x'"
> keep if ccode=="MUS"
> sort year
> save "C:\World Bank TPD data\\`x'bilateral.dta", replace
> }
>
>
> I tried to replicate the above into Nick's codes as follows:
>
> ssc inst fs
> fs *bilateral.csv
> foreach f in `r(files)' {
> insheet using "C:\World Bank TPD data\\`"`f'"'",clear
> local country : substr local f "bilateral.csv"
> gen country = "`country'"
> save "C:\World Bank TPD data\\`"`country'"'bilateral.dta", replace
> }
>
> But it does not seem to produce the saved stata file I want
> in the last cmmand line. I guess somewhere I must have called
> the macros in a wrong way. Any suggestions?
>
> Many thanks
> Dev
>
> >>> [email protected] 07/19/05 2:19 am >>>
> Try again:
>
> Nick
> [email protected]
>
> > -----Original Message-----
> > From: Nick Cox
> > Sent: 19 July 2005 02:12
> > To: '[email protected]'
> > Subject: RE: RE: RE: reading the first X letters of a filename
> >
> >
> > ssc inst fs
> > fs *bilateral.csv
> > foreach f in `r(files)' {
> > insheet using `"`f'"'
> > local country : substr local f "bilateral.csv" ""
> > gen country = "`country'"
> > ...
> > }
> >
> > Nick
> > [email protected]
> >
*
* 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/
