How to change column label to column name? Thanks.

beewise — Fri, 18 Nov 2022 13:47:28 GMT

Re: How to change column label to column name? Thanks.

PaigeMiller — Fri, 18 Nov 2022 14:09:28 GMT

proc datasets library=work nolist; /* or if it is not a WORK data set, use the appropriate libname instead of work */
    modify datasetname;
    rename ibesname=company_name;
run; quit;

Re: How to change column label to column name? Thanks.

Tom — Fri, 18 Nov 2022 15:01:03 GMT

It kind of looks like from that picture that the label has a space in it. That will not work well as a variable name. Either it will be invalid, or it you set the VALIDVARNAME option to ANY then it will require that you use a name literal to reference it. I would suggest either replacing the space with an underscore or using CaMeL case to mark the starts of new words in the name.

And to the general case a label can be up to 256 bytes long and a name can only be up to 32 bytes long. So you cannot always use the label as a name.

If you do want to change the name use the RENAME statement (or perhaps the RENAME= dataset option).

If you want to change the label use the LABEL statement.

data want;
  set have;
  rename ibesname=CompanyName ;
  label ibesname='IBES Name' ;
run;

topic Re: How to change column label to column name? Thanks. in New SAS User

How to change column label to column name? Thanks.

Re: How to change column label to column name? Thanks.

Re: How to change column label to column name? Thanks.