topic Re: Proc Export: arranging output. in SAS Procedures

Proc Export: arranging output.

pequignot — Thu, 15 Jan 2015 14:56:37 GMT

How do I arrange/control columns when I use proc export?

I'm thinking of something like a "var" statement in proc print.

EG: I have a vbl called AGE, and another called AgeGrouped; when using export Age goes to Col B and AgeGrouped goes to Col F. I want to have them together to give to client, for his use..

Similar/related question: is there a way to arrange columns in a SAS dataset? If I could arrange things there then proc export might do what i want.

Re: Proc Export: arranging output.

Doc_Duke — Thu, 15 Jan 2015 15:14:20 GMT

Ordering the variables in a SAS data set requires understanding the Program Data Vector. Read this chapter and see if that solves your problem:

SAS(R) 9.2 Language Reference: Concepts, Second Edition

Re: Proc Export: arranging output.

markjc — Thu, 15 Jan 2015 15:53:49 GMT

'Retain' will change the column order. The Proc Export column order from the origional dataset is: name | Emp_Id | dept

After altering the datset using Retain, The Proc Export column order is: name | dept | Emp_Id

http://www.sascommunity.org/wiki/Re-ordering_variables

data people;

input name $ Emp_Id dept $;

datalines;

Timothy 225 Finance

Mark 301 Risk

Matt 249 IT

;

run;

* Change column order ;

Data people ;

Retain name dept Emp_Id;

Set people;

Run;

Re: Proc Export: arranging output.

RW9 — Thu, 15 Jan 2015 16:35:45 GMT

Alternaitvely, don't use proc export as you are basically letting some code guess what you want as output. There are other options out there:

- tagsets.excelxp + proc report - good for most uses.

- datastep to csv - Excel can read an interpret, flat text file so portable, virtually everything can read it.

- XML - your own particular XML creation, from datastep

Re: Proc Export: arranging output.

ballardw — Thu, 15 Jan 2015 17:01:28 GMT

And what's wrong with Proc print using NOOBS option?