Dear User, I am trying to import several excel files and perform Kruskal –Wallis test test. Therefore, I have written loop code, but unable to do. Kindly suggest me.

cd "C:\Users\Biswa\Desktop\file"

global country "Ind Pak Chi Sri Bang"
foreach x of global country {
import excel "C:\Users\xx\Desktop\file\`x'.xlsx", sheet("Sheet1") firstrow
kwallis o, by(i)
clear "`x'"
}