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'"
}
Related Posts with Loop for excel file import and Kruskal –Wallis test
lead (t+1) variablesDearest All I am confronting an issue I have a dataset which consists of 10574 observations panning…
Annualize monthly returnsDear Statalist users, I would like to annualize monthly returns on funds by using the following for…
Matching with replacement based on size and industryHi, I am currently doing my thesis and I am struggling with this problem. I have a panel dataset i…
Three way interaction without significant two way interaction?Hello, Does anyone know if it is legitimate to proceed with threeway interactions when the two-way …
Exporting a file with a list of variable names and variable labels.Hi all, I've been trying to export a file (Excel or anything) with two columns - first with a list o…
Subscribe to:
Post Comments (Atom)
0 Response to Loop for excel file import and Kruskal –Wallis test
Post a Comment