Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    Reshape data

    Hi all,

    I am new to Stata and looking forward to your help. I have a data set as below. Now I want to reshape the data in a way like this. For each province code and each sector, there are 4 values (Xinside , Xoutside, Yinside, Youtside). For example, with sector SA: Xinside takes value of SA1, Xoutside takes value of SA2, Yinside takes value of SA3, Youtside takes value of SA4. Similarly with sector SB, Xinside takes value of SB1, Xoutside takes value of SB2, Yinside takes value of SB3, Youtside takes value of SB4.

    Thank you so much!

    province_code sector Xinside Xoutside Yinside Youtside
    01 SA =SA1 =SA2 =SA3 =SA4
    01 SB = SB1 =SB2 =SB3 =SB4
    01 SC =SC1 = SC2 =SC3 =SC4
    02 SA =SA1 =SA2 =SA3 =SA4
    02 SB = SB1 =SB2 =SB3 =SB4
    02 SC =SC1 = SC2 =SC3 =SC4

    ..........

    Code:
    * Example generated by -dataex-. To install: ssc install dataex
clear
input str2 province_code double(SA1 SB1 SA2 SB2 SA3 SB3 SA4 SB4)
"01"   .0017028445145115256   .0023350135888904333 .0027798395603895187  .003866626648232341  .0032214559614658356   .0026982827112078667  .003193654352799058  .003946760203689337
"02" 2.2668098154099425e-06 4.3661353288371174e-07 .0010311652440577745 .0013394771376624703    .00012961495667696  .00003826236570603214   .00145593355409801   .00144189374987036
"04"   9.48622891883133e-06  9.362609034724301e-07 .0010859231697395444 .0014460007660090923 .00027693057199940085  .00008032988262129948 .0014870421728119254 .0015489415964111686
"06" 1.8351720427745022e-06 1.3309504538483452e-06 .0014738109894096851 .0020369139965623617 .00024348367878701538  .00007328458741540089  .002012549201026559  .002170742955058813
"08"  .00004927282498101704  .00002754034176177811  .001687829615548253 .0023708653170615435    .00017632229719311  .00007144319533836097  .002346463967114687  .002534029306843877
"10"  .00005120598143548705   .0001467945839976892  .001009129686281085 .0013067257823422551 .00028849055524915457   .0000831772485980764 .0014164414023980498 .0014237106079235673
"11"  4.704503169250529e-07   8.50977812660858e-08 .0008340633357875049 .0010294286767020822 .00007864148210501298 .000023371698262053542 .0011569468770176172 .0011110674822703004
"12"  9.737310335822258e-08  4.393074348740811e-08 .0008678166195750237  .001108692493289709 .00008263061317848042 .000024556327844038606 .0012552007101476192 .0011817096965387464
"14"  .00005009195228922181 2.2453000383393373e-06 .0010513151064515114 .0013743038289248943 .00010716960969148204 .000015399406038341112 .0014694144483655691 .0014814117457717657
"15"  .00001266374601982534  .00001801215148589108 .0014964803121984005 .0020525807049125433 .00009320750541519374 .000042225015931762755  .002118574222549796  .002202667761594057
"17"  .00003325173747725785  .00012189798871986568  .002167253289371729 .0030037332326173782  .0001175434808828868  .00014876178465783596 .0029857417102903128 .0032136316876858473
"19"   .0001812164846342057  .00036016071680933237  .002272969111800194 .0032080525998026133 .00011535507655935362  .00032754367566667497 .0031311234924942255 .0034290498588234186
"20" 4.1578791751817334e-06  5.357782811188372e-06 .0015846044989302754 .0022476466838270426 .00002110242348862812  7.101197752490407e-06   .00213994481600821  .002382711274549365
"22"   .0005151873920112848   .0009650223073549569 .0018406492890790105 .0028689114842563868  .0006282348185777664   .0009953118860721588 .0023043539840728045  .002966989064589143
"24"  .00011236395221203566   .0008246264769695699   .00337726017460227  .004167719278484583 .00009751928882906213   .0008076958474703133  .004248818848282099  .004268562886863947
"25"  .00021918908169027418    .000541477173101157 .0021379273384809494  .002876258920878172  .0002489642647560686   .0005015744245611131  .002982761012390256 .0031382604502141476
"26"   .0005272763664834201   .0004620105028152466 .0026877315249294043 .0038829008117318153  .0005896876100450754   .0006803064025007188  .003776876488700509  .004078262485563755
"27"   .0017601746367290616   .0009898170828819275  .003226278815418482 .0054006571881473064   .001571690198034048    .000614448101259768  .004554080776870251 .0057909549213945866
"30"   .0010835365392267704   .0017955780494958162  .003087795339524746  .004643709398806095   .000987241743132472    .001909421756863594  .004006664734333754  .004789671860635281
"31"   .0007570912130177021    .002052270108833909 .0024980700109153986 .0037880311720073223  .0005505657754838467   .0018994836136698723  .003208762500435114  .004002417903393507
"33"   .0024051435757428408    .002118404023349285  .002964629326015711  .005154718644917011    .00258005247451365   .0021009277552366257   .00397306215018034  .005455915816128254
"34"  .00018088413344230503   .0013814779231324792 .0028941514901816845 .0049915132112801075 .00018963517504744232   .0013891906710341573  .003685123287141323 .0052523440681397915
"35"   .0013322684681043029   .0012916254345327616 .0031784232705831528   .00523053202778101  .0015233702724799514    .001316963229328394  .004200153052806854  .005529090296477079
"36"  .00007385506614809856    .001861297758296132 .0034307055175304413   .00493431743234396 .00017861292872112244    .001987170660868287  .004313657991588116  .005142864305526018
"37"  .00009798141400096938   .0004254069644957781  .002770421328023076 .0044634356163442135  .0001917613117257133  .00045229613897390664 .0036341429222375155  .004737412091344595
"38"  .00022105957032181323  .00033740687649697065 .0017730165272951126 .0025339059066027403 .00036000245017930865   .0004358410369604826  .002351778792217374 .0026809684932231903
"40"    .000250945333391428  .00010715381358750165 .0013464536750689149 .0017093272181227803 .00038688836502842605  .00012907740892842412 .0017704976489767432 .0018434145022183657
"42"  .00011959639232372865 .000049910813686437905 .0014546456513926387  .001642908900976181 .00011653011461021379  .00005581405639532022 .0019867352675646544  .001783775514923036
"44" .000021331670723157004 .000017806571122491732 .0012412146897986531 .0014354619197547436 .00006556274456670508  .00002408753425697796 .0016345304902642965 .0015503079630434513
"45" .000052105016948189586  .00004643744614440948 .0012739236699417233 .0015664012171328068 .00010415868746349588  .00004894711310043931 .0016765405889600515 .0016901461640372872
"46"  .00013892659626435488   .0007981329108588398 .0013310345821082592 .0013519988860934973 .00023860723013058305   .0008430058369413018 .0017222315073013306 .0014655833365395665
"48"  .00048814472393132746   .0005182325839996338 .0014299657195806503 .0016217931406572461  .0007349224179051816   .0005753443692810833 .0018132551340386271   .00175852223765105
"49"  .00007965120312292129  .00027831242186948657 .0017288393573835492 .0015649973647668958 .00018541442113928497   .0003592004650272429 .0019939590711146593 .0016245798906311393
"51"    .000976475072093308  .00035261298762634397 .0013840387109667063 .0015329810557886958  .0004942654632031918  .00017250215751118958  .001890520565211773 .0017056999495252967
"52"   .0021573405247181654   .0016854980494827032 .0016985628753900528  .001539943739771843   .003229052759706974   .0017808953998610377  .002143647987395525 .0016693479847162962
"54"  .00016449209942948073 .000059754889662144706  .001898552873171866 .0016924346564337611  .0002538384578656405  .00005095314554637298  .002439855830743909 .0018534192349761724
"56"   .0007694060914218426  .00009878237324301153 .0019396524876356125 .0018729915609583259  .0010547301499173045   .0001483806554460898  .002500896342098713  .002047549933195114
"58"  .00011073510540882126 .000015471965525648557  .002497478388249874  .002288603689521551 .00018343461852055043 .000030130448067211546 .0032116088550537825  .002513215644285083
"60"  .00011488758900668472  .00007409410318359733 .0034095721784979105 .0033900728449225426 .00021072608069516718  .00008674594573676586  .004287926480174065 .0037082864437252283
"62" .000044999374949838966  2.244673282802978e-07 .0017589172348380089 .0016573884058743715 .00007939439819892868  7.374467259069206e-06  .002261462854221463  .001811148365959525
"64" .000030873179639456794 .000010825554454640951   .00185329036321491 .0017235290724784136  .0000992676941677928 .000028987104087718762  .002359886886551976 .0018788059242069721
"66"  .00003777281744987704  2.491456598363584e-06  .002479135524481535 .0023273960687220097 .00011863640247611329 .000023852944650570862  .003149912692606449 .0025482731871306896
"67" .000011926284969376866  1.705498334558797e-06 .0033268907573074102 .0032248341012746096 .00005525918459170498 .000012813492503482848  .004191969987004995 .0035333926789462566
"68" .000032439242204418406  .00007013029244262725  .002651411108672619  .002477050991728902 .00012527474609669298  .00008879934466676787 .0033713725861161947  .002717122435569763
"70"    .000638691068161279  .00028539675986394286 .0060675074346363544  .006553248036652803  .0008471759501844645    .000362249615136534  .007401642855256796   .00710644107311964
"72"   .0006479388102889061   .0010733037488535047  .006031285971403122  .005901316646486521  .0008107150788418949   .0013987562851980329  .007435283157974482  .006370128132402897
"74"    .005727310664951801    .005393190775066614  .012292602099478245  .015969978645443916   .005461476277559996    .005238075274974108  .015814410522580147   .01768515817821026
"75"   .0025936737656593323    .007039367221295834  .013609088025987148  .011849846690893173  .0029197458643466234      .0079191904515028  .016514969989657402   .01237177662551403
"77"   .0022035851143300533    .001105962204746902  .006022269371896982  .006633353885263205  .0029690610244870186   .0012058807769790292  .007457934785634279  .007225374691188335
"79"    .011245563626289368     .01103996206074953  .009289693087339401  .011386469937860966   .015235140919685364    .011700869537889957  .010462543927133083  .012403602711856365
"80"    .002000081120058894    .001315586850978434  .010187365114688873  .009554114192724228   .002288633491843939    .001398621709086001  .012992248870432377  .010534781031310558
"82"     .00126982806250453   .0006448886706493795  .009818125516176224  .008571946993470192    .00170160923153162   .0009008192573674023  .012215515598654747  .009333925321698189
"83"   .0003574647125788033   .0003756814112421125   .00903412513434887  .007310775574296713  .0005212054238654673    .000438420771388337  .011393708176910877   .00820174254477024
"84"  .00010516143083805218  .00005078702452010475  .006455049384385347  .005013388115912676  .0002361162332817912  .00014851093874312937  .008182006888091564  .005545525345951319
"86"   .0008264689240604639  .00017225908231921494    .0072225546464324  .004873041063547134  .0011589734349399805  .00035557744558900595  .009204063564538956  .005374052096158266
"87"    .001980534987524152  .00007848576933611184 .0054506342858076096  .004367089830338955    .00259189959615469  .00010218781244475394  .006947407964617014  .004869790747761726
"89"   .0005190693773329258  .00009446396143175662  .005550559144467115 .0035929810255765915  .0008034195634536445  .00017067596490960568  .007090290077030659  .003998359199613333
"91"  .00036564102629199624 6.6292323026573285e-06  .004174604546278715  .002890660660341382  .0005791375297121704  .00008835677726892754 .0053259823471307755 .0031957824248820543
"92"    .003102849470451474  .00023834308376535773 .0053694406524300575  .003932346124202013   .004021514672785997  .00021963039762340486  .006892621051520109  .004427039064466953
"93"   .0008679997408762574   .0001231305650435388  .005061539355665445 .0031776500400155783   .001025536796078086   .0001417056773789227  .006550326943397522  .003550951601937413
"94"   .0006639200146310031 .000030653405701741576  .004740877076983452  .003150083590298891  .0009185033268295228  .00005576018520514481   .00608148192986846  .003514490555971861
"95"   .0006225401302799582 .000013419630704447627  .004899532534182072  .003167904680594802  .0008500161347910762  .00003946797005482949  .006297638639807701 .0035267553757876158
"96"   .0007956812623888254  .00007267692853929475 .0030534896068274975 .0022149174474179745  .0010472933063283563  .00002870619391615037  .003921011462807655 .0024692595470696688
end


    [/CODE]
    Tags: None
  • #2
    I'm not sure I understand correctly what you want. But perhaps it is this:
    Code:
    rename (S*#) S*X#
reshape long @X1 @X2 @X3 @X4, i(province_code) j(sector) string
rename X1 Xinside
rename X2 Xoutside
rename X3 Yinside
rename X4 Youtside

    Comment

    • #3
      Hi Clyde Schechter

      Thank you so much for helping me again. Really appreciate that. It is really interesting to know the way to rename variables the way you suggested.

      Comment

      Previous Next
      Working...
      X