I am trying to use the Code 08 Correlation folder in SAS Studio and I keep getting errors in the log

[Rhicks58]

Hello SAS community.  I am a beginner using SAS studio and I am trying to get my simple excel spreadsheet variables to be accepted and processed by the program when I hit the run button.  My variables come back as errors in the log.

This is my SAS Work.Import file.

I tried to use the Code 08a Correlations file:

This is what comes back in the log.

What can I do to clear up the errors?  Thanks in advance.

[PaigeMiller · Accepted solution]

There are no underscores in the variable names. Apparently you have set the SAS option VALIDVARNAME to ANY, and so variable names have spaces in them. To refer to variable names with spaces, you would use, for example: 'Number of Vehicles'n

[Rhicks58]

This is what I ran using your instructions;

This is what showed up in the error log this time;

[Rhicks58]

This is what I ran using your instructions;

This is what showed up in the error log this time;

[Rhicks58]

I was missing the (') in front of the variable as you said. It went through with no errors. Thanks a lot!