I want my Dataset Variable names into observation to new dataset

[_el_doredo]

Hello Experts,

I am having 3 dataset under TEMPO library.

Dataset 1 name: Temp1 has 3 variables

Dataset 2 name: Temp2 has 4 variables

Dataset 3 name: Temp3 has 5 variables

In my new dataset called FINAL. I am having two variable names and i want all the variable names from Temp1,Temp2 and Temp2 dataset to be observation of this FINAL dataset.

I  want my output like this

Variable_Name	Dataset_Name
Name	Temp1
ID	Temp1
Amount	Temp1
Address	Temp2
SSN	Temp2
Product	Temp2
Discount	Temp2
MRP	Temp3
Cust_id	Temp3
Ref	Temp3
Outstanding_amt	Temp3
status	Temp3

Thanks in Advance

[AMSAS · Accepted solution]

Hi @_el_doredo 

You have a couple of simple options:

1. PROC CONTENTS / PROC DATASETS
2. Dictionary Tables

Here's an example

/* Create sample data */
data temp1 (keep=temp1var1 temp1var2) temp2(keep=temp2var1 temp2var2) temp3 (keep=temp3var1 temp3var2);
	temp1var1=1 ;
	temp1var2="test" ;
	temp2var1=1 ;
	temp2var2="test" ;
	temp3var1=1 ;
	temp3var2="test" ;

	output temp1 temp2 temp3 ;
run ;

data work.want ;
	set sashelp.vcolumn ;
	where libname="WORK" and memname in ("TEMP1","TEMP2","TEMP3") ;
run ;

[_el_doredo]

Thank you so much