求教stata编程问题，非常感谢

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

<p>希望打下帮我编个小程序，现在有HS-6位码的各种商品各个国家的单位出口价格（p）和出口量(q),在求出各种商品的世界平均价格（uv）后，把商品分成低、中、高三类，划分原则如下：</p><p>For each HS-6 product, we compute the world unit value average (noted UV). We then classify each flow:</p><p>– Flows with unit values verifying UV−25%, UV+25% belong to the medium range, along</p><p>with the last decile of [min,  UV−25%] and the first decile of [  UV + 25%, max].</p><p>– The first nine deciles of [min, UV−25%] are considered low range.</p><p>– The last nine deciles of [UV +25%, max] are considered high range.</p><p>谢谢大家的帮助。</p>

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：求教stata stata编程 Stata 非常感谢 tata average product medium values world

Supposing your dataset is as follows:

name  price

A     10

A     15

…    …

B     20

B     30

…    …

 

Hope the Stata codes below will help you to solve your problem.

 

 

sort name

egen int gname = group(name)

qui tabu gname

local ngname = `r(r)'

forvalue i = 1(1)`ngname' {

  qui sum price if gname == `i', d

  gen int group`i' = irecode(price,`r(p25)',`r(p75)') if gname == `i'

}

sort name price group1-group`ngname'