topic Make Column Name Change on Output file Remain in SAS Enterprise Guide

Make Column Name Change on Output file Remain

req41273 — Wed, 05 Jun 2019 12:13:33 GMT

On my output file, I am changing the name of my columns and building a query using the output dataset file using the new column name. I see the new column name in the output of the new query I am using. However, when I run the entire project, the column name change is not permanent. Can I make it a permanant column name change?

I'm changing the column name in the SAS output by first unprotecting the data, then going to properties window and typing in a new name.

Re: Make Column Name Change on Output file Remain

aaronh — Wed, 05 Jun 2019 13:28:55 GMT

Without knowing your procedures, it's difficult to know exactly what you coded. However, if all you want to do is to permanently rename column(s), you can consider either:

proc dataset lib=libname;
modify target_dataset;
rename old_var_name = new_var_name;
run;

or in a proc sql step:

proc sql;
select old_var1 as new_var1_name, 
           old_var2 as new_var2_name

from target_dataset;
quit;

Re: Make Column Name Change on Output file Remain

Kurt_Bremser — Wed, 05 Jun 2019 13:40:30 GMT

@req41273 wrote:

I'm changing the column name in the SAS output by first unprotecting the data, then going to properties window and typing in a new name.

Since this manual action is not recorded anywhere as a task in your project, it won't have any permanent effect.

Depending on how the dataset is created, there are numerous options to set the intended names.

Re: Make Column Name Change on Output file Remain

Reeza — Wed, 05 Jun 2019 16:01:11 GMT

There's a section in query builder itself to rename the new variables or change the name of a calculated variable. Ensure you're doing that within query builder not by manually changing the name in the sheet. That is manual and would need to be done every time.

Re: Make Column Name Change on Output file Remain

req41273 — Wed, 05 Jun 2019 18:47:49 GMT

where in query builder can this be done. Can you send me a step by step action on how to do this or a screen print?

Re: Make Column Name Change on Output file Remain

req41273 — Wed, 05 Jun 2019 18:48:33 GMT

where in query builder can this be done. Can you send me a step by step action on how to do this or a screen print

Re: Make Column Name Change on Output file Remain

req41273 — Wed, 05 Jun 2019 18:51:04 GMT

I've only seen where you can rename if it's a computed column, this column is not a computed column

Re: Make Column Name Change on Output file Remain

req41273 — Wed, 05 Jun 2019 19:38:30 GMT

Thanks

I found it.

Re: Make Column Name Change on Output file Remain

Reeza — Wed, 05 Jun 2019 19:47:47 GMT

Please post the answer for future users, especially if you're going to mark your comment as the answer. The solved is to help people who are searching find what the correct solution was quickly without reading through all the posts.

Re: Make Column Name Change on Output file Remain

Kurt_Bremser — Thu, 06 Jun 2019 05:27:56 GMT

This

@req41273 wrote:

Thanks

I found it.

is NOT a solution. Please post what you have really done, so others can profit from it. You got help here, so help others get help also.