I am trying to write a program that will return details about variables in a dataset. The code below is close to what I need: libname VARLIST "<location>"; proc sql; create table dset_details as select memname, memtype, name, type, format from dictionary.columns where libname = "VARLIST"; quit; However, type only returns "num" for Date, Currency and Time variables. Where would I find data that returns the type as Date, Currency and Time similar to the view I would get if I accessed the dataset properties from Enterprise Guide (i.e. right click on a dataset in a SAS EG project and select "Properties" > "Columns") Thanks!
... View more