Another way might be to use a tempfile
. clear
. set obs 100
. gen y=_n
. tempfile mytmp
. save `mytmp', replace
. rename y x
. cross using `mytmp'
. sort x y
. gen r=x*y
Cheers
Joseph
On Fri, Sep 11, 2009 at 9:37 PM, Bert Jung <[email protected]> wrote:
> Hello Tim,
>
> A brute-force method may be to create multiple datasets (one for each
> multiplication) and append them. Probably not the most efficient
> approach but it works:
>
>
> * Example
> clear
> set obs 1000
>
> gen x = _n
>
> * Create datasets for y=x*2 ... y=x*4
>
> forvalues i = 2/4 {
> preserve
> tempfile tmp`i'
> gen y = x*`i'
> save `tmp`i''
> restore
> }
>
>
> * Now return to first dataset and append the others (note that i = 2/4
> as in above loop)
> gen y = x*1
>
> forvalues i = 2/4 {
> append using `tmp`i''
> }
>
> sum y
>
>
>
> Cheers,
> Bert
>
>
> On Thu, Sep 10, 2009 at 1:18 PM, Burnett, Tim
> <[email protected]> wrote:
>> Hello,
>>
>> I am at the end of my tether with Stata 10 and was hoping someone could help me:
>>
>> I have a dataset which I am trying to manipulate:
>>
>> Assuming the following variable:
>>
>> 1
>> 2
>> 3
>> 4
>> 5
>> 6
>> 7
>> 8
>>
>> I am trying to create a variable which will show:
>>
>> 1*1
>> 1*2
>> 1*3
>> 1*4
>> .
>> .
>> .
>> 2*1
>> 2*2
>> 2*3
>> 2*4
>> .
>> .
>> .
>> ...and so on.
>>
>>
>> I really don't know where to look as I can't think what this mathematical operation would be called. Maybe I'm just dim.
>>
>> Many thanks,
>>
>> Tim Burnett
>>
>> **********************************************************************
>> If you have received this email and it was not intended for you,
>> please let us know, and then delete it. Please treat our
>> information in confidence, as you would expect us to treat yours.
>>
>> All our information systems may be monitored to ensure
>> that they are operating correctly. Furthermore, the content of
>> emails and other data on these systems may be examined,
>> in exceptional circumstances, for the purpose of investigating
>> or detecting any unauthorised use.
>>
>>
>>
>>
>> The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) On leaving the GSi this email was certified virus free.
>> Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
>>
>>
>> *
>> * 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/
