|
Data defines the model by dint of genetic programming, producing the best decile table.
|
|
SAS RENAME Coding
Bruce Ratner, PhD |
|
|
Example 1: Renaming a Column at Time of Output
This example uses RENAME= in the DATA statement to show that the column is renamed when it is written to the output table.
The column keeps its original name, X, during processing.
data two(rename=(x=keys))
method run();
set one;
z=x+y;
run;
enddata;
Example 2: Renaming a Column at Time of Input
This example renames column X to a column named KEYS in the SET statement,
which is a rename before DS2 processing.
KEYS, not X, is the name to use for the column for processing.
data three;
set one(rename=(x AS keys));
z=keys+y;
run;
enddata;
Example3: Renaming Data Set Variables
These examples show the correct syntax for renaming variables using the RENAME statement:
 rename street=address;
rename time1=temp1 time2=temp2 time3=temp3;
rename name=Firstname score1-score3=Newscore1-Newscore3;
______
NOTE: I grabbed this content from SAS online because I never remember the RENAME syntax.
Now, I know "where" to find it.
Mentioning WHERE, I have a similar problem recalling WHERE syntax.
So, I have a link for that as well.
|
| For more information about this article, call Bruce Ratner at 516.791.3544 or 1 800 DM STAT-1; or e-mail at br@dmstat1.com. |
| Sign-up for a free GenIQ webcast: Click here. |
|
|
br@dmstat1.com