Hi @VDD Your code is incorrect as there isn't ant /missing option in a proc sort. I think you prolly meant proc freq. Kindly verify the documentation online. Thanks ... View more

Since you're using SAS University Edition, you need to export it to the myfolders location you set up. So your export should be:   proc export data=lib.car_sales outfile='/folders/myfolders/Book1.xlsx' dbms=xlsx; run; @Ananyayadav wrote: hey..i m getting error in exporting file in sas.   my code was:  proc export data=lib.car_sales outfile='F:\SASUniversityEdition\myfolders\Book1.xlsx' dbms=xlsx; run;   and my error was:   ERROR: DBMS type XLSX not valid for export. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds   Please help me out.   ... View more

Also your path in the error does not match the path in shown code.   With errors it is best to copy the submitted code and the error message from the log and then paste into a code box here using the forum's {I} icon. The message windows will sometimes reformat the text moving some of the indicators SAS places for some error messages to a different location. Copying both from log removes questions about whether "code" shown was what was actually submitted. ... View more