Bookmark and Share

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: Check for coding of new variables using data patterns


From   "Thirukumaran, Caroline Pinto" <cpt8913@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Check for coding of new variables using data patterns
Date   Tue, 22 Oct 2013 15:18:41 -0400

Thanks, David! The -groups- command is perfect!

On Tue, Oct 22, 2013 at 2:41 PM, Radwin, David <dradwin@rti.org> wrote:
> Caroline,
>
> How about -groups- (Nick Cox, SSC)?
>
> . groups var1 var2 var3 var4 var5 newvar
>
> David
> --
> David Radwin
> Senior Research Associate
> Education and Workforce Development Division
> RTI International
> 2150 Shattuck Ave., Suite 800
> Berkeley, CA 94704
> Phone: 510-665-8274
>
> www.rti.org
>
>
>> -----Original Message-----
>> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
>> statalist@hsphsun2.harvard.edu] On Behalf Of Thirukumaran, Caroline
> Pinto
>> Sent: Tuesday, October 22, 2013 11:19 AM
>> To: statalist@hsphsun2.harvard.edu
>> Subject: st: Check for coding of new variables using data patterns
>>
>> Hi,
>> Is there a way to check the coding of a newly created variable using
>> data patterns of variables that have used to create the new variable?
>>
>> As an example, newvar is a variable that has been created based on
>> values of var1-var5. The code used for creating the newvar variable is
>> as follows:
>> egen newvar=rsum(var1 var2 var3 var4 var5)
>>
>> To check that newvar has been correctly coded, it would be helpful to
>> have an output like the one below:
>>
>> newvar var1 var2 var3 var4 var5 Frequency
>> 0 0 0 0 0 0 10
>> 1 0 0 0 0 1 20
>> 1 0 1 0 0 0 40
>> 2 0 0 1 1 0 70
>> 2 0 1 1 0 0 80
>> 3 2 0 1 0 0 110
>> 3 1 0 1 0 1 120
>> 4 1 0 1 2 0 130
>>
>> -collapse-  gives an acceptable output (it does not give me the
>> frequency count) only when var1 -var5 are binary.
>>
>> I am using Stata 12.1 for Windows.
>>
>> I get the output tabulated above from SAS using the following code:
>> proc freq data=abc;
>>  tables newvar*var1*var2*var3*var4*var5 / list missing;
>> run;
>>
>> Many thanks in advance,
>> Caroline Thirukumaran
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index