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]
Re: st: RE: Data management
From
Dilip Pandey <[email protected]>
To
[email protected]
Subject
Re: st: RE: Data management
Date
Fri, 23 Jul 2010 11:25:44 -0500
Nick,
Thanks for your suggestion. In this database a person can be
hospitalized 2 or more times. The first hospital encounter has final
bill information. The second hospital encounter has 2 interim bills
and 1 final bill. Please suggest stata code to collapse billing
information for second hospital encounter only . Procedure variables
are string for those bills.
Thanks.
Dilip
On Fri, Jul 23, 2010 at 10:58 AM, Nick Cox <[email protected]> wrote:
> . help collapse
>
> Nick
> [email protected]
>
> Dilip Pandey
>
> I am analyzing administrative database. There are multiple billing
> submitted for one event. I would like to create one record for each
> event. Please suggest how to collapse multiple billing records into
> one record per event for an individual.
>
> Example
>
> ID billid Amt($) bill from
> bill thru proc1 proc2 proc3 proc4
> billtype
>
> 1 x1 345 20050128
> 20050131 123 345
> interim
>
> 1 x2 1000 20050201
> 20050203 993 452 462
> interim
>
> 1 x3 2000 20050204
> 20050206 991
> interim
>
> 1 x4 150 20050207
> 20050210 414 416
> Final
>
> Apparently the billing is for services rendered between 20050128 thru
> 20050210. Multiple bills/claims were submitted for one episode. I will
> highly appreciate suggestion for collapsing information from interim
> bills into the final one to create one record for an episode without
> loosing information from interim bill/claim.
>
> *
> * 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/