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?
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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.