Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: AW: 回复： st: AW: AW: 回复： AW: 回复： st: AW: do file
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
st: AW: 回复： st: AW: AW: 回复： AW: 回复： st: AW: do file
Date
Mon, 8 Mar 2010 13:51:00 +0100
<>
" is this a right way?"
Maybe, maybe not, but -duplicates drop- should be more straightforward...
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von lydia huang
Gesendet: Montag, 8. März 2010 13:46
An: [email protected]
Betreff: st: 回复： st: AW: AW: 回复： AW: 回复： st: AW: do file
Dear Maryin, and Neil,
Thank you very much. i still don't know what's wrong with that merge do-file, but i identified and dropped duplicates by using
sort patient_id admission_diagnosis diagnosis_desc other_diagnosis
quietly by patient_id admission_diagnosis diagnosis_desc other_diagnosis: gen dup = cond(_N==1,0,_n)
tabulate dup
drop if dup>1
is this a right way?
best wishes
lydia
--- 10年3月8日，周一, Martin Weiss <[email protected]> 写道：
> 发件人: Martin Weiss <[email protected]>
> 主题: st: AW: AW: 回复： AW: 回复： st: AW: do file
> 收件人: [email protected]
> 日期: 2010年3月8日,周一,下午8:33
>
> <>
>
> " To check for uniqueness, use -isid-."
>
>
>
> Neil`s suggestion to use - duplicates report patient_id- is
> probably even better, given that -isid- returns only a
> binary decision (yes/no) while -duplicates- shows more
> details.
>
>
> ***
> clear*
> inp id
> 1
> 2
> 3
> 4
> 5
> end
> isid id
> di in r _rc
> duplicates report id
> inp
> 4
> end
> cap isid id
> di in r _rc
> duplicates report id
> ***
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]]
> Im Auftrag von Martin Weiss
> Gesendet: Montag, 8. März 2010 13:06
> An: [email protected]
> Betreff: st: AW: 回复： AW: 回复： st: AW: do file
>
>
> <>
>
> Well, paste the output of -tabulate- into an email.
>
> To check for uniqueness, use -isid-.
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]]
> Im Auftrag von lydia huang
> Gesendet: Montag, 8. März 2010 12:30
> An: [email protected]
> Betreff: st: 回复： AW: 回复： st: AW: do file
>
> after i use the do-file, i typed -ta _merge-, then it come
> out a table with the titles in the first row: _merge, Freq.,
> Percent, Cum.,is this the right outcome?
>
> --- 10年3月8日，周一, Martin Weiss <[email protected]>
> 写道：
>
> > 发件人: Martin Weiss <[email protected]>
> > 主题: AW: 回复： st: AW: do file
> > 收件人: [email protected]
> > 日期: 2010年3月8日,周一,下午7:05
> >
> > <>
> >
> >
> >
> > Just do everything the way you used to, and type -ta
> > _merge- once you are done. Do not change your original
> code,
> > just append the command at the end.
> >
> >
> >
> > HTH
> > Martin
> >
> >
> > -----Ursprüngliche Nachricht-----
> > Von: [email protected]
> > [mailto:[email protected]]
> > Im Auftrag von lydia huang
> > Gesendet: Montag, 8. März 2010 12:03
> > An: [email protected]
> > Betreff: st: 回复： st: AW: do file
> >
> > Dear Martin
> > i mean twice present, and after i changed all the
> -merge-
> > to -ta_merge-, it writes"unrecognized command:
> ta_merge".
> > what's next?
> > Best wishes
> > Lydia
> >
> > --- 10年3月8日，周一, Martin Weiss <[email protected]>
> > 写道：
> >
> > > 发件人: Martin Weiss <[email protected]>
> > > 主题: st: AW: do file
> > > 收件人: [email protected]
> > > 日期: 2010年3月8日,周一,下午6:29
> > >
> > > <>
> > >
> > >
> > >
> > > What does "doubled" mean? Doubled in value or
> twice
> > present
> > > where there was only one entry previously? Try to
> find
> > out
> > > what happened in the -merge-r by typing -ta
> > _merge-...
> > >
> > >
> > >
> > > HTH
> > > Martin
> > >
> > >
> > > -----Urspr眉ngliche Nachricht-----
> > > Von: [email protected]
> > > [mailto:[email protected]]
> > > Im Auftrag von lydia huang
> > > Gesendet: Montag, 8. M盲rz 2010 11:25
> > > An: [email protected]
> > > Betreff: st: do file
> > >
> > > Dear Statalist,
> > > is there any thing wrong with the following
> do-file:
> > > /* sort and save the using data*/
> > > cd H:\my\2007
> > > use written, clear
> > > sort patient_id
> > > save, replace
> > >
> > > /* sort the master data*/
> > > use 13, clear
> > > sort patient_id
> > >
> > > /* merge based on "patient_id" and save*/
> > > merge patient_id using written
> > > save final07, replace
> > >
> > >
> > > i don't know why, but all the observations in
> the
> > final07
> > > have doubled.Why has this happened? what can i
> do?
> > > Best wishes
> > > Lydia
> > >
> > >
> > >
> > >
> > >
> > > *
> > > * For searches and help try:
> > > * http://www.stata.com/help.cgi?search
> > > * http://www.stata.com/support/statalist/faq
> > > * http://www.ats.ucla.edu/stat/stata/
> > >
> > >
> > > *
> > > * For searches and help try:
> > > * http://www.stata.com/help.cgi?search
> > > * http://www.stata.com/support/statalist/faq
> > > * http://www.ats.ucla.edu/stat/stata/
> > >
> >
> >
> >
> >
> >
> > *
> > * For searches and help try:
> > * http://www.stata.com/help.cgi?search
> > * http://www.stata.com/support/statalist/faq
> > * http://www.ats.ucla.edu/stat/stata/
> >
> >
> > *
> > * For searches and help try:
> > * http://www.stata.com/help.cgi?search
> > * http://www.stata.com/support/statalist/faq
> > * http://www.ats.ucla.edu/stat/stata/
> >
>
>
>
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/