topic rename variable in SAS Programming

rename variable

BrahmanandaRao — Tue, 19 Jan 2021 07:24:14 GMT

proc sql;
alter table students rename column  Sex to Gender;
quit;

here it shows error

PeterClemmensen — Tue, 19 Jan 2021 07:35:52 GMT

What does the error say? Are you sure you want to rename the variables like this?

Kurt_Bremser — Tue, 19 Jan 2021 07:46:06 GMT

Maxim 1: Read the Documentation.

ALTER TABLE in SQL. There is no RENAME clause for this SQL statement.

To rename columns, use the RENAME statement or the RENAME= dataset option in data steps, or do a SELECT with AS in SQL.

Shmuel — Tue, 19 Jan 2021 11:37:58 GMT

If you don't want to rewrite he dataset with the new column name, but do it inplace - you can use

proc datasets lib=<librray> nolist;
   modify <dataset name>;
     rename <current name> = <new name>;
quit;