Is there a sort option in PROC EXPORT?

[cosmid]

Hi,

If I have a data with var1 and var2, and I wanted the final .csv file to be sorted by var2, my question is:

Is it possible to sort the data in a PROC EXPORT step or the data can only be sorted by a PROC SORT before the PROC EXPORT?

If it is possible to sort using PROC EXPORT, what's the syntax?

Thanks!

[PaigeMiller · Accepted solution]

There is no sort option in PROC EXPORT. You would need to do the sorting in PROC SORT.

[FreelanceReinh]

Hi @cosmid,

You could define a PROC SQL view including an ORDER BY clause and apply PROC EXPORT to this view. Then the sorting will occur during the PROC EXPORT step and without creating a sorted dataset.

Example:

data have;
set sashelp.class(keep=age weight);
run;

proc sql;
create view have_s as
select * from have
order by weight;
quit;

proc export data=have_s 
outfile='C:\Temp\want.csv' dbms=csv replace;
run;