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

noda6003 — Wed, 03 Nov 2021 07:57:09 GMT

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;

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

ballardw — Wed, 03 Nov 2021 14:58:44 GMT

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;

topic metadata with variables and then want to append it with my final data in SAS Programming

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

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