topic put vars labels as values in a new data set in SAS Programming

put vars labels as values in a new data set

Ronein — Wed, 27 Apr 2022 05:46:44 GMT

Hello

I want to create a data set that will contain 1 row .

The values in this row will be the variables labels.

what is the way to do it please?

Data have;
label ID='customer_ID'
       X1='Weight'
	   X2='Height'
	   X3='Education'
	   W='Health';
Input ID X1 X2 X3 W;
cards;
111 10 20 30 40
222 15 30 45 60
777 30 20 20 80
;
run;

Data wanted;
Input ID $ X1 $ X2 $ X3 $ W $;
cards;
cust_ID
Weight
Height
Education
Health
;
Run;
/***The question-How to create wanted data set autmctically***/

Re: put vars labels as values in a new data set

japelin — Wed, 27 Apr 2022 05:58:30 GMT

proc contents data=have out=cont(keep=NAME LABEL) noprint;
run;
proc transpose data=cont out=want(drop=_NAME_ _LABEL_);
  var LABEL;
  ID NAME;
run;

Re: put vars labels as values in a new data set

andreas_lds — Wed, 27 Apr 2022 06:01:05 GMT

I am 100% sure that this question has been asked and answered multiple times, so please use the search function.

Are you 100% sure that the values of all labels have values that are valid for variable names?

Re: put vars labels as values in a new data set

Ronein — Wed, 27 Apr 2022 06:03:55 GMT

I didn't ask to put the labels as variables names.

I asked to put these values as values and use same variables names (and define them as chars)