When you export a dataset to Excel, you can use dataset options such as KEEP, RENAME, and WHERE in the DATA=-option. You can either use a one- or two-level SAS name (i.e., with or without libref). The DATA=-option specifies the SAS dataset you want to export. DBMS=-option to specify the file extension such as DBMS=xlsx.For instance, OUTFILE=”/folders/myfolders/export/cars.xlsx” OUTFILE=-option to define the output location and the file name.DATA=-option to specify the SAS dataset you want to export.To export data from SAS to Excel with PROC EXPORT you need to define at least three parameters: This procedure is easy-to-understand and provides many options. Export data from SAS to Excel with PROC EXPORT The EXPORT ProcedureĪn easy way to export a table from SAS to Excel is with the EXPORT procedure (PROC EXPORT).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |