Proc EXPORT

This procedure is used to export the data set(s) we have in SAS into an external file in our hard drive. The exported data file can be in the shape of text files or excel files...

proc export data=dataname1 (where=(variable1='abc')) 

                  outfile='C:\test.xls' 

                  dbms=xls 

                  replace;

                  putnames=yes;

run;