Hello Statalist,

I have bunches of vairables named like ABC_daily_count_costANDinsulinAN Breitbart_daily_count_costANDins CNN_daily_count_costANDinsulinAN Daily_Beast_daily_count_costANDi. And I want 1)remove anything behind "daily_count" and 2) replace "daily_count" with "cd_1". I can write separately like
Code:
rename ABC_daily_count_costANDinsulinAN ABC_cd_1
I wonder if I can write a loop like
Code:
foreach var of varlist ABC_daily_count_costANDinsulinAN Breitbart_daily_count_costANDins CNN_daily_count_costANDinsulinAN Daily_Beast_daily_count_costANDi
and then loop the above two steps for each variable names. But I don't know how to write the loop. Would you help me out? Thanks very much.