Blanks in column name

[znhnm]

Hi, I uploaded a CSV file to SAS Studio, but this file has a column name with blank between two words. It causes problems when writing code referring to this variable. Is there a way to rename the variable to remove the blank so that I can refer to this column in my code? Thnak you!

[SASKiwi · Accepted solution]

There are at least three ways of dealing with this:

• remove the blanks from the CSV file and re-import the data
• run this statement to change the default behaviour (required in every submit): options validvarname = v7;
• rename the column once imported:

data want;
  set have;
  rename 'My Column with blanks'n = My_Column_without_blanks;
run;

•  

[andreas_lds]

Don't use proc import, write a data step reading the file.

[Kurt_Bremser]

Don't use PROC IMPORT, write the DATA step yourself. IMPORT is not needed for text files and causes unnecessary problems. See thousands of posts here.

As a stopgap measure, set

options validvarname=v7;

before PROC IMPORT.