Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: RE: Replacing variable values after using collapse command


From   Matthew Krauchunas <krauchunasms@mymail.vcu.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Replacing variable values after using collapse command
Date   Mon, 5 Jul 2010 19:11:56 -0400

Outstanding!  Thank you very much for your patience and understanding.

V/R,
Matt

On Mon, Jul 5, 2010 at 6:33 PM, Martin Weiss <martin.weiss1@gmx.de> wrote:
>
> <>
>
> Calls for a different approach, then:
>
>
> ***********
> clear*
>
> input double oshpd_fac_no str30 facility_name int snf_medcare_days /*
> */      avg_occupancy_rate byte combined_finance
> 206071028       "OAK PARK CONVALESCENT HOSPITAL"        351     63.71   0
> 206071028       "OAK PARK CONVALESCENT HOSPITAL"        1371    75.46   0
> 206071028               "" 1722 72.506448       1
> 206371928       "THAT OTHER COMPANY"        355     65.71   0
> 206371928       "THAT OTHER COMPANY"        1321    75.32   0
> 206371928               "" 1712 72.5048       0
> end
>
> form oshpd_fac_no %9.0f
> list, noo
>
> bys  oshpd_fac_no: egen maxcomb=max(combined)
> bys oshpd_fac_no ( facility_name combined_finance): /*
> */  replace facility_name= facility_name[_N] if maxcomb==1
> by oshpd_fac_no: keep if (_n==1 & maxcomb==1) | maxcomb==0
>
> list, noo
> ***********
>
>
> HTH
> Martin
>
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Matthew
> Krauchunas
> Sent: Dienstag, 6. Juli 2010 00:13
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: RE: Replacing variable values after using collapse command
>
> Thank you that does indeed work.  However, is there a way to ensure I
> only combine the observations I have identified with the
> combined_finance indicator variable?  I ask because there are some
> observations that I do not want to combine because they have multiple
> financial periods due to a change in ownership.  I am trying different
> "if" commands, but I cannot strike upon the proper one.
>
> Thank you,
> Matt
>
> On Mon, Jul 5, 2010 at 5:03 PM, Martin Weiss <martin.weiss1@gmx.de> wrote:
>>
>> <>
>>
>> You may want to use -collapse- again:
>>
>> ***********
>> clear*
>>
>> input double oshpd_fac_no str30 facility_name int snf_medcare_days /*
>> */      avg_occupancy_rate byte combined_finance
>> 206071028       "OAK PARK CONVALESCENT HOSPITAL"        351     63.71   0
>> 206071028       "OAK PARK CONVALESCENT HOSPITAL"        1371    75.46   0
>> 206071028               "" 1722 72.506448       1
>> end
>>
>> form oshpd_fac_no %9.0f
>> list, noo
>>
>> collapse (first) facility_name (lastnm)  /*
>> */ snf_medcare_days avg_occupancy_rate  /*
>> */ combined_finance, by(oshpd_fac_no)
>>
>> list, noo
>> ***********
>>
>>
>> HTH
>> Martin
>>
>>
>> -----Original Message-----
>> From: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Matthew
>> Krauchunas
>> Sent: Montag, 5. Juli 2010 22:56
>> To: statalist@hsphsun2.harvard.edu
>> Subject: st: Replacing variable values after using collapse command
>>
>> Hello,
>>
>> I need advice on how to replace variable values.  I have financial
>> data that contained more than 1 financial report in a single calendar
>> year.  With much advice, I have been able to identify and combine
>> those periods using the collapse command.  I then saved this file and
>> combined it with the master file via the append command.  My problem
>> now though is  how to combine the string information in the master
>> file with the values obtained after the collapse command.  Here is an
>> abridged example:
>>
>> oshpd_fac_no    facility_name   snf_medcare_days        avg_occupancy_rate
>> combined_finance
>> 206071028       OAK PARK CONVALESCENT HOSPITAL  351     63.71   0
>> 206071028       OAK PARK CONVALESCENT HOSPITAL  1371    75.46   0
>> 206071028               1722    72.506448       1
>>
>>
>> The oshpd_fac_no is the California assigned id number per PHYSICAL
>> address, the facility name is self-explanatory, snf_medcare_days &
>> avg_occupancy_rate were two of the variables collapsed respectively,
>> and combined_finance is an indicator variable created to show that
>> this observation was created via the collapse command.  Now the crux
>> of the problem....I need to combine the string information from the
>> first two variables with the collapsed values in the third
>> observation.  Thus, it should look like this when finished::
>>
>> oshpd_fac_no    facility_name   snf_medcare_days        avg_occupancy_rate
>> combined_finance
>> 206071028       OAK PARK CONVALESCENT HOSPITAL  1722    72.506448       1
>>
>> Any ideas?
>>
>> Thank you for all the help thus far!
>> Matt
>> *
>> *   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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index