remove spaces from Column name

[buckeyefisher]

I am using EG 4.3. I have a field heading 'Date Founded'  (it has a space in between) that contains dates in the input excel sheet. I am not supposed to touch the input excel sheet.

Is there a way to access this field in SAS EG? I tried VALIDVARNAME = ANY option to ignore spaces but my data step is not recognizing the field. The program does not give error, simply ignores calculation in the data step.

[ballardw]

How did you bring the data into SAS? Proc import if using the file column headers to provide variable names generally turn all spaces and special characters to underscores. I would expect the variable name to be Date_founded.

[buckeyefisher]

no, it did not convert the input fields, I used proc import

proc import datafile= 'file A'

  dbms=xls out=A replace;

  sheet="xyz";

run;

[RW9]

I would suspect then as you don't have getnames=yes; option, that it has been read in using default names for the columns, e.g. col1 col2 etc.

[dsbihill · Accepted solution]

You can access the variable by typing it like this.  This will tell sas that it is a name litteral.

'Date Founded'n