Rename a variable that has a space in it

[ayosas]

the variable has a space in it, I checked using proc contents and both the label and var name have a space in them. I tried renaming using the rename option

this is the error I get 

77 rename education level = education_level;

ERROR: Alphabetic prefixes for enumerated variables (education-level) are different.

ERROR: Old and new variable name specifications for RENAME must be of the same type. Statement is ignored.

ERROR 79-322: Expecting a -.

[Kurt_Bremser]

For non-standard names, you have to use name literals:

rename 'education level'n = education_level;

[PaigeMiller]

You need

options validvarname=any;

and then you can rename with

rename 'education level'n = education_level;

notice the quotes and the letter n after the final quote

[Kurt_Bremser]

PS you can avoid this by issuing

options validvarname = v7;

before importing the data into SAS.

[ayosas]

So if this is an excel file, this option should go before proc import?

[Kurt_Bremser]

Yes. SAS will then convert the names to valid SAS names by replacing invalid characters with underlines.