Thank you so much!
On Thu, Jun 4, 2009 at 2:25 PM, Austin Nichols <[email protected]> wrote:
> Pancho Villa <[email protected]> :
>
> clear
> input id value
> 1 15
> 2 14
> 3 22
> 4 31
> 5 12
> 6 10
> end
> g id_1=(id-mod(id-1,3)-1)/3+1
> g id_2=mod(id-1,3)+1
> l
>
>
> On Thu, Jun 4, 2009 at 2:15 PM, Pancho Villa <[email protected]> wrote:
>> Dear list,
>>
>> I have my data in this kind of form:
>>
>> id value
>> 1 15
>> 2 14
>> 3 22
>> 4 31
>> 5 12
>> 6 10
>>
>> id_1 id_2 value
>> 1 1 15
>> 1 2 14
>> 1 3 22
>> 2 1 31
>> 2 2 12
>> 2 3 10
>>
>> In other words, my data is stacked and would like to un-stack it. (I
>> can do reshape, I think. But this seems like a necessary first step.)
>>
>> Now, in my example, my id goes from 1 to 6, while I'd like id_1 to go
>> from 1 to 2 and id_2 from 1 to 3. In reality, my id goes from 1 to
>> 5084280, while I want id_1 to go from 1 to 2088 and id_2 from 1 to
>> 2435. (If you check, 2088 x 2435 = 5084280.)
>>
>> I'll really appreciate if you can share code addressing a very similar
>> problem so I can just paste it in my do file and tweak a few things.
>>
>
> *
> * 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/