Passing macro to variables to find the length

[R_Win]

Hi

I am having a Dataset in work library and the name of the dataset is trans_mon in this dataset 250-300 character variables are there now i want to find the length of character variables(length of the observartion).How can i do this by passing the macro .As i am having 2-3 datasets like this

[LinusH]

The SQL interface offers you the possibility to create macro variables from a query result. Information on column length is available in DICTIONARY.COLUMNS. You may wish to know whether the table is compressed or not, look in DICTIONARY.TABLES.

/Linus

[deleted_user]

Try using:
Proc contents