works great, thanks you. Although i just want 3 sheets in an excel file one named "All Data" that has all the data, second one with name "Some Data" that has only the selected columns passed in query (example would be appreciated) and the third sheet with name as schema that has only the column name type and size. proc contents data=new; run; works awesome but gives a whole lot of data, i just want column name type and size and i just want in the order they are not sorted alphabetically. Thanks in advance PS: The exact excel file that i want is attached
... View more