topic Re: creating table in SAS Enterprise Guide

creating table

aabb — Fri, 31 Oct 2008 22:08:23 GMT

I have a very simple question-

I need to create a table with around 600 variables that, for many, are in the form A1 A2 A3 etc. Is there a way to quickly create these variables other than typing them into the table through the GUI and once they are there, is there a way to kind of 'find and replace' or rename? ex: A1 becomes B1 etc.

Thanks

Re: creating table

Patrick — Sat, 01 Nov 2008 12:57:43 GMT

Hi aabb

That's how you create the numeric vars A1-A600 and the character vars B1-B600;

data want;
array A {600};
array B {600} $10;
run;
proc contents data=want short;
quit;

The renaming part you asked for would also be possible but needs a bit more programming.

Why do you need this renaming? It sounds a bit odd...

Regards, Patrick

Re: creating table

LinusH — Mon, 03 Nov 2008 09:13:51 GMT

You can use variable lists in the rename statement/data set option:

data rename;
set want(rename=(a1-a600 = c1-c600));
run;

/Linus