st: FW: RE: Looping gen sequentially over datasets

["Alex Sutherland" <as2140@cam.ac.uk>]

Dear Joe, dear Steve,

Thanks both for the solutions, that?s nailed it. Joe, I am slightly
embarrassed I didn?t know about the append option!

Regards,

Alex

Steve?s solution:
use "dataset1"
g id=1
lab def idlab foo
lab val id idlab
save, replace

forval i = 2/40 {
                append using "dataset`i'"
                replace id=`i' if (missing)id
}

save "newdata", replace

Joe?s:
local id=0
foreach file in "file1" "file2" ... {
       use `file', clear
       local ++id
       gen School_ID=`id'
       save , replace
} 


***********************************************************


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/