Generate dynamically

SASPhile · Posted 02-09-2018 03:32 PM

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

Reeza · Posted 02-09-2018 03:42 PM

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

ballardw · Posted 02-09-2018 04:46 PM

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?);