Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: odbc load, clear - does it clear labels?


From   "Grote, Veit Dr." <[email protected]>
To   <[email protected]>
Subject   st: odbc load, clear - does it clear labels?
Date   Mon, 26 Jul 2004 14:53:01 +0200

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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index