topic SET SDTM Tamplate in SAS Programming

SET SDTM Tamplate

anchensun — Wed, 06 Jun 2018 12:54:25 GMT

I have a dataset with 5 variables including VNUMBER VNAME VLABEL VTYPE and VLENGTH. I want to set a table has all variables with the name from the VNAME value, label from VLABEL and length from VLENGTH. If VTYPE equal to 1, the variable is numeric. If VTYPE equal to 2, the variable is character. Here is the original dataset. How should program it?

Re: SET SDTM Tamplate

Kurt_Bremser — Wed, 06 Jun 2018 12:49:38 GMT

First of all, never supply example data in a picture. Unless you expect everyone else here to tediously type text from a picture.

See my footnotes for how to convert a dataset to data step code and how to post the resulting code so that it can be reliably run with copy/paste and submit.

For your question, look into call execute.

Re: SET SDTM Tamplate

RW9 — Wed, 06 Jun 2018 13:36:00 GMT

Not going to do it for you, but to start:

data _null_;
  set meta end=last;
  if _n_=1 then call execute('data want;');
  if vtype=1 then call execute(cat(' attrib ',strip(vname),';'));
  else call execute('...');
  if last then call execute(';run;');
run;