02-24-2016 01:18 PM
I have a folder names samples and there are n number of SAS files... all i need to do is extract Column Names, Datatype, Size and # of Records and dump it into an excel spreadsheet.
The desired spreadseet is attached.
PS: I am new to the SAS world so please answer the code with explanation if possible.
Thanks in advance.
02-28-2016 12:26 AM
Use below Contents procedure to get Column Names, Datatype, Size etc from SAS file by giving library name.
Repeat this or write a macro to get all the librarie's SAS files info and collate to one single SAS file.
proc contents data=&inlib..&indata out=contdata;
Export sas dataset contdata to an excel file using proc export.
02-28-2016 02:48 AM