topic Re: Generate dynamically in SAS Programming

Generate dynamically

SASPhile — Fri, 09 Feb 2018 20:32:05 GMT

How to create a dataset dynmaically with the following below columns (metadata of columns in datasets generated without passing any hardcoding)?

DatasetName DatasetLabel VariableName VariableLabel DataType Length SASFormat

Re: Generate dynamically

Reeza — Fri, 09 Feb 2018 20:42:22 GMT

Try SASHELP.VTABLE and/or SASHELP.VCOLUMN.

@SASPhile wrote:

How to create a dataset dynmaically with the following below columns (metadata of columns in datasets generated without passing any hardcoding)?

DatasetName DatasetLabel VariableName VariableLabel DataType Length SASFormat

Re: Generate dynamically

ballardw — Fri, 09 Feb 2018 21:46:26 GMT

This will get descriptions of the tables that contain the data you want:

proc sql;
describe table dictionary.tables ;

describe table dictionary.columns ;
quit;

You'll have to describe the "dynamic" part as I don't see any.

Use Proc Sql to join the two dictionary tables on Libname and memname, request the other information you want and perhaps subset to the libname and/or data sets you want (is this the "dynamic" part?);

Re: Generate dynamically

PeterClemmensen — Fri, 09 Feb 2018 23:07:01 GMT

Read this

http://www2.sas.com/proceedings/sugi31/259-31.pdf