Not sure how many variables you have, but one alternative
is to create copies that are only nonmissing when non-duplicate.
Eg,
foreach V of varlist [vars] {
gen `V'_p=`V' if unique==1
}
So you get a set of variables that are non-missing only for
-unique- equal to 1. Just an idea.
hth,
Jeph
Robert Duval wrote:
Hi Tom,
Thanks for the suggestion, however it doesn't really get at what I want,...
After defining tsset, I want to create variables like
gen z = x-l.x
and keep this variables in the dataset. For the duplicate obs. z
should take missing values.
By using -preserve- / -restore- I lose z after restoring the old dataset.
Any other suggestion will be greatly appreciated
robert
On 11/11/06, Thomas Erdmann <[email protected]> wrote:
Couldnt you work with -preserve- and -restore- ?
duplicates tag x y, generate(dup)
preserve
drop if dup~=0
tsset x y
...
restore
Wouldn't it be better to keep one of the duplicate observations?
Duplicates drop, force
Instead of
Drop if dup~=0
- Tom
-----Urspr�ngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Robert Duval
Gesendet: Samstag, 11. November 2006 21:21
An: [email protected]
Betreff: st: tsset on subsample of observations
Dear All,
Is there a way to tsset a subsample of my observations?
I want to perform operations that involve time series commands, but if
I consider my entire dataset I have repeated time values within the
panel.
I would like to Stata to tsset my observations for that subset of obs.
that are uniquely identified within each panel... something like:
tsset x y if unique==1
Is there a way to do this?
Otherwise I would be forced to drop the repeated observations, but
since I need those obs. for other exercises this will force me to save
datasets: one with duplicates and another one without them. Something
that seems highly inefficient.
Any help would be greatly appreciated.
robert
*
* 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/
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.0/524 - Release Date:
08.11.2006
*
* 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/
*
* 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/
*
* 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/
