topic Re: Unable to Rename Column names and Label to Uppercase in SAS Programming

SAS

laxmanpai — Mon, 10 May 2021 14:50:35 GMT

Hi,

I have a dataset abc which has 2 columns for example .

Dataset : abc

Columns : riskst_a label ='riskst_a'

claim label='claim'

I am creating one more dataset abcd by referencing this dataset abc.

In my new dataset abcd i want all the columns from the dataset abc to be converted to uppercase

including the labels.

Could you please let me know.

Regards

Laxman Pai

Re: SAS

PaigeMiller — Mon, 10 May 2021 14:55:29 GMT

Please help us all. Please go back and edit the Subject line of your original post to describe (briefly) the problem. A subject line of "SAS" is useless in the SAS forum.

Re: SAS

ballardw — Mon, 10 May 2021 15:09:29 GMT

@laxmanpai wrote:

Hi,

I have a dataset abc which has 2 columns for example .

Dataset : abc

Columns : riskst_a label ='riskst_a'

claim label='claim'

I am creating one more dataset abcd by referencing this dataset abc.

In my new dataset abcd i want all the columns from the dataset abc to be converted to uppercase

including the labels.

Could you please let me know.

Regards

Laxman Pai

By "olumns from the dataset abc to be converted to uppercase" do you mean the values of the variable or the name of the variable?

You can modify properties of a data set in place with Proc Datasets. To change values you would use a data step.

The "change" names or labels:

proc datasets library=work;
  modify abc ;
  rename riskst_a = RISKST_A      
         claim    = CLAIM
  ;
  label RISKST_A = "RISKST_A"     
        CLAIM    = "CLAIM"
  ;
  run;
quit;

Re: Unable to Rename Column names and Label to Uppercase

laxmanpai — Mon, 10 May 2021 15:21:18 GMT

Hi,

I am getting the error

"The HEADER/VARIABLE update function is not supported by the sasiosnf engine.

Actually the libref is sas is actually connected to the Library in Snowflake.

So i am getting the above error.

Re: Unable to Rename Column names and Label to Uppercase

SASKiwi — Mon, 10 May 2021 20:58:20 GMT

Please post the complete SAS log of the step giving you the error including the LIBNAME you are using.

Re: Unable to Rename Column names and Label to Uppercase

ballardw — Mon, 10 May 2021 21:18:12 GMT

@laxmanpai wrote:

Hi,

I am getting the error

"The HEADER/VARIABLE update function is not supported by the sasiosnf engine.

Actually the libref is sas is actually connected to the Library in Snowflake.

So i am getting the above error.

That pretty much says that SAS cannot change the properties of variables in the external data base. So you need to use SNOWFLAKE tools to change data in Snowflake. It may have helped a bit to provide this little bit of information in the first place as remote databases and what can be done depend a lot which database, how you connect and where you want to make a change.