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" <[email protected]>
To
[email protected]
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 <[email protected]> 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: [email protected] [mailto:owner-
>> [email protected]] On Behalf Of Thirukumaran, Caroline
> Pinto
>> Sent: Tuesday, October 22, 2013 11:19 AM
>> To: [email protected]
>> 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/