06-06-2018 08:45 AM - edited 06-06-2018 08:54 AM
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?
06-06-2018 08:49 AM
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.
06-06-2018 09:36 AM
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;