05-15-2014 10:05 AM
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.
05-15-2014 10:08 AM
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.
05-15-2014 10:22 AM
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.
Need further help from the community? Please ask a new question.