Not sure how replacing the names with the labels will help you any. Are the names that generic that they are unusable?
If so why did they create generic variable names to begin with? Perhaps you are lucky and the reason the code is using generic names and labels is because they had names longer than 8 characters and they needed to get it to work with SAS version 6 or earlier so they made generic variable names and put the real name in to the label.
You might have better luck converting from wide to long format. Do you have unique ID variable (or some small set of variables that uniquely identify each observations)? If not you can add one easily.
If you run code like this you will get one dataset with 10K*5K observations that will have both the NAME, LABEL and the VALUE.
proc transpose data=have out=tall(rename=(col1=VALUE)) ;
by id ;
var _all_;
run;
Note that if you have any character variables then all variable (including the numeric variables) will be converted to character. If you have a mix of numeric and character variables you might want to make two datasets instead.
proc transpose data=have out=tall_numbers(rename=(col1=NUM_VALUE)) ;
by id ;
var _numeric_;
run;
proc transpose data=have out=tall_chars(rename=(col1=CHAR_VALUE)) ;
by id ;
var _character_;
run;
Now if you want you can reverse the transpose and just tell it to use the _LABEL_ variable instead of the _NAME_ variable when naming the variables.
proc transpose data=tall_numeric out=want ;
by id;
id _label_;
var num_value;
run;
