Dear Statalisters,
I am trying to solve the following problem: assign the observations of a variable as labels to the new variables generated after -sxpose2-.
Thanks to your contribution, I managed to import multiple Excel files from a folder and clean the data.
I've got the following structure of the data:

id name v1 v2 v3 v4
"id1" "label_id1" 234 367 111 898
"id2" "label_id2" 34 67 341 222
"id3" "label_id3" 24 37 121 254
"id4" "label_id4" 23 36 116 345

When I run the following code:

sxpose2, clear firstnames force varname
drop in 1/2

I get the result:
_varname id1 id2 id3 id4
v1 234 34 24 23
v2 367 67 37 36
v3 111 341 121 116
v4 898 222 116 345

My problem, that I cannot find a solution is: assign to variables id1, id2, id3 and id4 the labels from variable "name" from the initial dataset structure.
id1 - label_id1, label_id2 etc.

Thank you very much for your help!