topic Re: Is there a sort option in PROC EXPORT? in New SAS User

Is there a sort option in PROC EXPORT?

cosmid — Tue, 07 Feb 2023 15:04:49 GMT

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!

Re: Is there a sort option in PROC EXPORT?

PaigeMiller — Tue, 07 Feb 2023 15:12:55 GMT

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

Re: Is there a sort option in PROC EXPORT?

FreelanceReinh — Tue, 07 Feb 2023 16:01:50 GMT

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;