Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: replace a set of numbers with a second set of numbers


From   Tirthankar Chakravarty <tirthankar.chakravarty@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: replace a set of numbers with a second set of numbers
Date   Fri, 23 Jul 2010 06:17:00 +0530

Tyler,

I am assuming the existence of a separate lookup file of the form you report?
objectid        zone_id
1       =      201005050010
2       =      201005050020
3       =      201005050040
4       =      201005050030
5       =      201005050060
6       =      201005050050
7       =      201005050100
8       =      201005050110
9      =      201005050070
10      =      201005050130

...

279       =     201025050010
280       =     201025050080

In which case, try the following (brute force) example:
**********************************
// generate data of the type reported
clear*
set obs 280
g ego = _n
forv i=1/280 {
	g alter`i' = `i'
}
reshape long alter, i(ego) j(alternum)
drop if ego==alter
tostring ego alter, replace
g ego_alter = ego+"-"+alter
g randomdata = runiform()
drop ego alter
tempfile intermediate
save `intermediate', replace

// generate a separate lookup file
clear
set obs 280
g object_id = _n
g zone_id = ceil(runiform()*10e6)
tempfile lookup
save `lookup', replace

// merge the zone_ids in
use `intermediate', clear
drop alternum
split ego_alter, generate(id) parse("-") destring
preserve
use `lookup', clear
rename object_id id1
rename zone_id id1_zone_id
save `lookup', replace
restore
merge m:1 id1 using `lookup', gen(id1_merge)
preserve
use `lookup', clear
rename id1 id2
rename id1_zone_id id2_zone_id
save `lookup', replace
restore
merge m:1 id2 using `lookup', gen(id2_merge)

// clean up
drop *merge id?
tostring *zone*, replace
g egozone_alterzone =  id1_zone_id+"-"+id2_zone_id
drop  id1_zone_id id2_zone_id
browse
**********************************

T

2010/7/23 Tyler Frazier <tyfrazier@gmail.com>:
> I want to replace a set of numbers (1 to 280) with another set of
> numbers (201005050010 to ~201025050080)
>
> the file has the time and distance between each of the 280 different
> points (78,400 observations)
>
> 1 - 1
> 1 - 2
> 1 - 3
> 1 - 4
> ...
> 1 - 280
> ...
> 279 - 279
> 279 - 280
>
> but the set of numbers was exported with a default setting and I need
> to replace each number such that
>
> objectid        zone_id
> 1       =      201005050010
> 2       =      201005050020
> 3       =      201005050040
> 4       =      201005050030
> 5       =      201005050060
> 6       =      201005050050
> 7       =      201005050100
> 8       =      201005050110
> 9      =      201005050070
> 10      =      201005050130
>
> ...
>
> 279       =     201025050010
> 280       =     201025050080
>
> can someone make a suggestion for me regrading this? Im having
> difficulty figuring it out in Stata.
>
> Thanks,
> Ty
> *
> *   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/
>



-- 
To every ω-consistent recursive class κ of formulae there correspond
recursive class signs r, such that neither v Gen r nor Neg(v Gen r)
belongs to Flg(κ) (where v is the free variable of r).

*
*   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   |   Site index