Proc transpose and extract the labels

[mona4u]

Hi all, 

I have this data set which I used proc transpose to flip it but I still not able to get the results that I want because of the Qlabel Values. 

I want to get the labels of the variables. I thought about if I use if Qname=".."then Qlabel="..."  

but I want to check if I there are shortcuts to get the label names 

my data

USUBJID	StID	CRFID	IDVAR	IDVARVAL	QORIG	QEVAL
A3921024 1006 10061050	A3921024 1006	2650261	AESEQ	1	CRF

the result that I am targeting 

QNAME	QVAL	QLABEL	IDVAR	IDVARVAL	QORIG	QEVAL
USUBJID	A3921024 1006 10061050	SUBJECT ID	AESEQ	1	CRF
StID	A3921024 1006	Site id	AESEQ	1	CRF
CRFID	2650261	Crf ID	AESEQ	1	CRF

[ballardw]

It would help to show the code you are currently using.

On the PROC Transpose statement you can add the option Label= to name a variable to hold the label of transposed variables.

So I would guess that you want to add Label=Qlabel to the transpose code.

[mona4u]

I am not sure where to add it to my code!!

proc transpose data=prep_suppae out=trans
name=QNAM;
by USUBJID IDVAR IDVARVAL QORIG ;
var StID CRFID;
run;

[ballardw]

proc transpose data=prep_suppae out=trans
name=QNAM label=Qlabel;
by USUBJID IDVAR IDVARVAL QORIG ;
var StID CRFID;
run;

Should have the labels for Stid and CRFid in a variable named Qlabel, IF the variables have a label assigned.

Here is a brief example with other data:

proc sort data=sashelp.class out=work.class;
   by sex age;
run;
proc transpose data=work.class
   name=qname  label=qlabel;
by sex age;
var height weight;
label height='Height at age'
      weight='Weight at age'
;
run;

The Sashelp.class data set does not have any variable labels assigned and hence no value for qlabel without them. Putting a label statement in the transpose code makes them available for the step to demonstrate the result. If only one of the variables has a label only those rows of the output have a value for  qlabel.

If you are wanting labels for other variables we'll need more information and possibly example data.