Friday, December 5, 2008

Meta data Creation

Meta data creation in clinical trials comes handy to see what kind of variables are currently in a dataset and its attributes with format name and its decodes.

It should be a straight forward code using the procedures proc contents and proc format with few data steps.

proc contents data=libname.dsname out=contents(keep=memname name type fmtname length label rename=(format=fmtname));
run;

proc format fmlib cntlout=formats(keep=format start label rename=(label=label1));
run;

Merge datasets you have got by fmtname. Include a dummy variable comment to write later on it if you have any specific comments about the same.

data metadata;
merge contents formats;
by fmtname;
comment="";
run;

proc print noobs label;
run;

No comments: