Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: Tabulation task


From   Serguei Kaniovski <Serguei.Kaniovski@wifo.ac.at>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Tabulation task
Date   Fri, 15 Aug 2008 18:42:13 +0200

This helps a lot. Thanks
Serguei

Eva Poen schrieb:
Serguei,

if I understand correctly, you have two files.
File 1:
Name Country V1 V2 V3
Mr. X A 1 2 1
Ms. Y B 4 0 2

File 2:
Vote_id Vote_issue
1 important stuff
2 something else
3 anything


In order to merge Vote_issue into file 1, you need to -reshape- file 1
from wide to long:

reshape long V, i(Name) j(Vote_id)

which leads you to

Name Country Vote_id V
Mr. X A 1 1
Mr. X A 2 2
Mr. X A 3 1
Ms. Y B 1 4
Ms. Y B 2 0
Ms. Y B 3 2

You can then -merge- on Vote_id. I'm still not quite sure what you
want your tabulations to look like, but that should be an easy problem
to solve once you have the data together.

Hope this helps,
Eva


2008/8/15 Martin Weiss <martin.weiss@uni-tuebingen.de>:

Sounds like a problem for -destring- -tostring- -encode- -decode- to me...

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Serguei Kaniovski
Sent: Friday, August 15, 2008 10:45 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: RE: Tabulation task

The problem is that the VALUES of the variable Vote_id in second file
are contained in the NAMES of the Vx varibales in the first file. And I
cannot figure out how to work with this.

Serguei

Martin Weiss schrieb:

Not sure whether I get this problem right: if there is a unique key that
ties the person`s vote in the first file to the Vote _id in the second
file,

then -merge- on the unique key and - tabulate- (-tab2-) afterwards.

HTH
Martin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Serguei
Kaniovski

Sent: Friday, August 15, 2008 9:39 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: Tabulation task

Hallo,

I am stuck with the following tabulation tast. I have two datafiles. One
contains the following variables:

Name, Country, V1, V2, V3, V4, ... large number
where Vx signifies a persons vote on issue x (numeric, categorical)

A second file contains the issue types (string) of each vote as follows:

Vote_id, Vote_issue
where Vote _id is numeric and corresponds to 1, 2, 3, 4, ..., Vote_issue
is a string decribing the voting issue.

How can I read in the issue types and tabulate the V-variables by issue
and country?

Thank you very much,
Serguei
*
* 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   |   What's new   |   Site index