How to change column label to column name? Thanks.

[beewise]

[PaigeMiller]

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;

[Tom]

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;