DATA Step, Macro, Functions and more

How to export data to excel in specific variable order?

Reply
N/A
Posts: 0

How to export data to excel in specific variable order?

Hi,
I'll need to export sas data set to excel file. The variable names need to be in a specific order. I used file, put statement to make variable names in the correct order. But once I use proc export, the variables are in alphabet order again. Please help. Thanks,
N/A
Posts: 0

Re: How to export data to excel in specific variable order?

Hi,
I was able to output the data to csv file. Variable names are not in the file but they are in order I want. Anyone has idea to include variable names? Thanks,

%let dataout2=myfile.csv;
data _NULL_;
set mydata;
file "&dataout" DLM=',' LRECL=2000 ;
put firstvar secvar ........... lastvar;
run;
Super User
Posts: 5,258

Re: How to export data to excel in specific variable order?

Well, you already know the names of the variables, so just output them as character strings:

%let dataout=myfile.csv;
%let varNames=Age,Sex,Height;
data _null_;
call symput('varNames2',translate("&VARNAMES"," ",","));
run;

data _NULL_;
set sashelp.class;
file "~/&dataout" DLM=',' LRECL=2000 ;
if _n_ = 1 then put "&VARNAMES";
put &VARNAMES2;
run;

/Linus
Data never sleeps
SAS Employee
Posts: 160

Re: How to export data to excel in specific variable order?

Just use PROC SQL to order your variables in the order you want, before your PROC EXPORT.

[pre]proc sql;
create view EXPORT as
select variale1 as Variable_1
, mysasdata as Start_date format=ddmmyy.
, etc as last_var format=z10.
from mysasdata;
quit;

proc export.........[/pre]
Ask a Question
Discussion stats
  • 3 replies
  • 235 views
  • 0 likes
  • 3 in conversation