SET SDTM Tamplate

Reply
Senior User
Posts: 1

SET SDTM Tamplate

[ Edited ]

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?

 

Super User
Posts: 10,255

Re: SET SDTM Tamplate

Posted in reply to anchensun

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Super User
Posts: 9,599

Re: SET SDTM Tamplate

Posted in reply to anchensun

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;
Ask a Question
Discussion stats
  • 2 replies
  • 68 views
  • 0 likes
  • 3 in conversation