如何在local中正确嵌套local (附一个应用) ？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

I have thousands of city folders (say city1, city2, and so on, but in reality named like 北京, 上海, etc.)

Each folder further contains two subfolders: land and house.

So the directory structure is like

currentdictionary

  ---- city1

     ----- house

         ------ many .xlsx files

     ----- land

  ----- city2

  ----- city3

  ···

  ----- city1000

I want to get the complete list of all subdirs and do some manipulation (like import excel). I know there is a macro extended function:

1. local list: dir

复制代码

to handle this issue, but it seems it can only return the first tier of subdirs, like city_i, rather than those deeper ones.

I use the following snippet of codes to test my ideas, if the approach works, it should return a full list of city names and each city's project

set more off

cdG:\Data_backup\Soufang_data

local folder:dir . dirs "*"

foreach i oflocal folder {

     di "`i'"

     local `i'_house : dir "G:\Data_backup\Soufang_data/`i'\house" files"*.xlsx"

     foreach j of local `i'_house {

        di "`j'"

     }

}

However, the outcome on the screen is something like

city1

project100

project99

······

project1

It seems the code only loops one round, over the first city, but fails to come to city2,city3 and so on. I suspect it's due to my problematic writing of the local,espcially in this line

1. foreach j of local `i'_house

复制代码

but I'm not sure.

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Local OCA manipulation problematic Dictionary dictionary thousands structure function further

I think the most efficient way is to directly define a local macro containing all the city names, which you can get from running the dir comamnd or ls command. Copy the output of the command, paste into Excel, and keep only the city names. I do this kind of thing all the time. It takes only a minute to do.

Because this is so quick and easy, I never bothered to find a Stata command for it.