Hi:
I'd use SASHELP or DICTIONARY tables. See below.
Also, for future reference, refer to this posting for how to use [pre] and [/pre] to preserve indentation:
http://support.sas.com/forums/thread.jspa?messageID=27609毙
cynthia
[pre]
** 1) Create table, but could just print from SQL;
proc sql;
create table structure as
select libname, memname, name, type, length,
format, informat, label
from dictionary.columns
where libname = 'SASHELP' and
memname = 'SHOES' and
upcase(type) = 'NUM';
run;
quit;
ods listing;
proc print data=work.structure;
title '1) Use DICTIONARY.COLUMNS';
run;
** 2) Just print directly from SASHELP.VCOLUMN;
PROC PRINT data=sashelp.vcolumn;
title '2) Use SASHELP.VCOLUMN';
where libname = 'SASHELP' and
memname = 'SHOES' and
upcase(type) = 'NUM';
var libname memname name type length format informat label;
run;
[/pre]