metadata with variables and then want to append it with my final data

[noda6003]

I have metadata with variables and then want to append it with my final data and only keep variables which are in final data and drop the remaining. when i do proc contents on metadata and transpose then all the variables are becoming numeric and i couldnt merge it with my final data. can you please help on how to do it.

proc contents
	data = sashelp.class
	noprint
	out = tmp (keep = name);
run;

proc transpose data=tmp out=tmp1(drop=_name_);
	id name;
run;

[ballardw]

Perhaps you should show use YOUR metadata data set and a small example of your "final data" and then what you expect for a result given those two example sets.

I am afraid that I can't guess what you actually want. Your example doesn't attempt to match or drop anything so it isn't clear what you mean by " keep variables which are in final data and drop the remaining" or why you think transpose is needed/wanted.

---

@noda6003 wrote:

I have metadata with variables and then want to append it with my final data and only keep variables which are in final data and drop the remaining. when i do proc contents on metadata and transpose then all the variables are becoming numeric and i couldnt merge it with my final data. can you please help on how to do it.

proc contents
	data = sashelp.class
	noprint
	out = tmp (keep = name);
run;

proc transpose data=tmp out=tmp1(drop=_name_);
	id name;
run;

---