topic Re: Can variable name be modified in SAS Studio? in SAS Software for Learning Community

Can variable name be modified in SAS Studio?

sasuser282 — Wed, 12 Oct 2022 13:00:37 GMT

Re: Can variable name be modified in SAS Studio?

Tom — Wed, 12 Oct 2022 13:08:51 GMT

Since you can use SAS/Studio to run SAS code then the answer is yes.

For help with what code you want to run you will need to provide more details.

Re: Can variable name be modified in SAS Studio?

Reeza — Wed, 12 Oct 2022 14:11:45 GMT

Only if you have write access to the data set.

Re: Can variable name be modified in SAS Studio?

sasuser282 — Wed, 09 Nov 2022 21:44:19 GMT

Thanks Rzzea. I uploaded data to SAS studio, and wanted to change variables names like we can do in SAS Enterprise Guide.

Re: Can variable name be modified in SAS Studio?

Reeza — Wed, 09 Nov 2022 21:48:50 GMT

And how did you do that in EG? Via the GUI or did you write code or a Task?

Re: Can variable name be modified in SAS Studio?

fja — Wed, 16 Nov 2022 10:16:35 GMT

Hello!

I do not know about manipulating metadata to rename variables, but what about simply copying the vars and dropping the old? Would that be a fix for you?

See the sketch below.

Cheers

data work.NewTestData;
	set work.TESTDATA;
	LovelyName = BadName;
	drop BadName;
run;

Re: Can variable name be modified in SAS Studio?

Tom — Wed, 16 Nov 2022 13:48:24 GMT

@fja wrote:

Hello!

I do not know about manipulating metadata to rename variables, but what about simply copying the vars and dropping the old? Would that be a fix for you?

See the sketch below.

Cheers
data work.NewTestData;
	set work.TESTDATA;
	LovelyName = BadName;
	drop BadName;
run;

Note it is simpler to rename the variable.

data work.NewTestData;
	set work.TESTDATA;
	rename BadName = LovelyName ;
run;