SAS

[laxmanpai]

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 

[PaigeMiller]

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.

[laxmanpai]

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.

[SASKiwi]

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

[ballardw]

---

@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.

[ballardw]

---

@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;