Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Nick Cox <njcoxstata@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: Some basic help on programming |
Date | Tue, 10 Apr 2012 10:11:15 +0100 |
You are doing a lot of renaming. -renvars- (Stata Journal) is one convenience tool that might help given your use of Stata 10. (-rename- in 12 is much more flexible.) Nick On Tue, Apr 10, 2012 at 9:50 AM, Prakash Singh <prakashbhu@gmail.com> wrote: > Maarten > I am sorry but its not like that. > For example in one lavel there is this item var in which we have ten > catagory (309-3019). Each of these item is for some head of > expenditute or receipt or sources of asset or sales etc. > > Let try again with the example of do file and sorry if I am not making > myself clear. > > use "level3_list.dta", clear > keep if item_code==309 > ren item_code item_code_manu > ren asicc_code asicc_code_manu > ren unit_quantity unit_quantity_manu > ren quantity quantity_manu > ren value value_manu > sort common_id > save "item309.dta",replace > > use "level3_list.dta", clear > keep if item_code==319 > ren item_code item_code_trade > ren asicc_code asicc_code_trade > ren unit_quantity unit_quantity_trade > ren quantity quantity_trade > ren value value_trade > sort common_id > save "item319.dta",replace > > here item (309-319) are operating expences under different heads like > manufacturing, transport, energy repair etc of the firm. So what I > need to do is break the data item wise to get value of operating > expences for different head and then merge the item wise data to get > vale of total operating expences of the firm. > > Prakash > * > * 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/