Hi,
I just realised that - odbc load - with the option - clear - seems not to clear the labels of the data set in memory. Running the do-file twice is producing an error "label already defined". The short copy of the result window is below. I am using up-to-date Stata 8.2 Intercooled.
Veit
--> first run, it works:
. odbc load, table("Meldungen") dialog(complete) clear
. renvars, lower
. lab var doedel "Fehlmeldungen"
.
. lab def doedel ///
> 1"Doppel ohne FB" ///
> 2"Doppel mit FB" ///
> 3"Fehlm. ohne FB" ///
> 4"Fehlm. mit FB" ///
> 5"Fehlm. - nicht eindeutig"
. lab val doedel doedel
.
end of do-file
--> second run, it does not work:
. do "C:\DOKUME~1\vgrote\LOKALE~1\Temp\STD00000000.tmp"
. odbc load, table("Meldungen") dialog(complete) clear
. renvars, lower
. lab var doedel "Fehlmeldungen"
.
. lab def doedel ///
> 1"Doppel ohne FB" ///
> 2"Doppel mit FB" ///
> 3"Fehlm. ohne FB" ///
> 4"Fehlm. mit FB" ///
> 5"Fehlm. - nicht eindeutig"
label doedel already defined
r(110);
end of do-file
----------------------------------------
Dr. Veit Grote, MSc
Klinikum der Universit�t M�nchen
Dr. v. Haunersches Kinderspital
Lindwurmstr. 4
D-80337 M�nchen
Tel.: +49 (89) 5160-7798
Fax: +49 (89) 5160-2951
[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/