topic Re: organize variables in a dataset in SAS Procedures

organize variables in a dataset

joel — Sat, 15 Mar 2008 17:48:10 GMT

Hello
Probably a dummy question but I am a novice !
I created a dataset and want simply to reorganize the variables in my logical order
I suppose some instruction using a proc statement or in a data set may help me but how ?
Thanks in advance
Joël

Re: organize variables in a dataset

Cynthia_sas — Sat, 15 Mar 2008 21:26:47 GMT

Hi:
You really do not have to worry about variable order, most procedures provide a way for you to control the order of the variables that you see on reports. For example, PROC PRINT has the VAR statement and PROC REPORT has the COLUMN statement.

[pre]
proc print data=sashelp.class;
title 'name age height on the report';
var name age height;
run;

proc print data=sashelp.class;
title 'different order';
var height weight age name;
run;
[/pre]

However, if you really want to reorder the variables in the data set, this SESUG user group paper contains some tips and techniques:
http://analytics.ncsu.edu/sesug/2002/PS12.pdf

cynthia

Re: organize variables in a dataset

joel — Mon, 17 Mar 2008 13:30:36 GMT

many thanks, Cynthia for your valuable help !
Joël