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

How to export data to excel in specific variable order?

deleted_user — Tue, 28 Oct 2008 21:46:52 GMT

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,

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

deleted_user — Wed, 29 Oct 2008 00:03:38 GMT

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;

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

LinusH — Wed, 29 Oct 2008 11:09:57 GMT

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

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

GertNissen — Wed, 29 Oct 2008 12:50:28 GMT

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]