topic Re: What is the syntax for writing out variables that include spaces? in SAS Programming

What is the syntax for writing out variables that include spaces?

darrendu300 — Mon, 23 Oct 2023 01:04:03 GMT

I have a survey imported into SAS where the variables are the questions themselves (for example: "What is your age?")

I am just trying to get a idea of the contents of the dataset with functions like proc print but I'm not sure of the syntax.

How would I go writing those variables as in below?

proc print data=mydata;

var What is your age?; run;

I have tried with single and double quotation marks but no success yet.

Re: What is the syntax for writing out variables that include spaces?

Patrick — Mon, 23 Oct 2023 01:09:01 GMT

SAS variable names are limited to 32 characters so ideally try to import your data with more suitable variable names that conform to SAS naming conventions.

To use a variable with a non-conformant name you need to address it as a SAS Name Literal: '<name>'n

proc print data=mydata;
  var 'What is your age?'n; 
run;

Re: What is the syntax for writing out variables that include spaces?

Tom — Mon, 23 Oct 2023 02:03:41 GMT

You should put the description (or question text) into the LABEL attached to the variable instead of trying to use it as the NAME of the variable.

How did you IMPORT the data? Did you use PROC IMPORT?

If you must use PROC IMPORT then make sure to set the VALIDVARNAME option to V7 before running the PROC IMPORT step so it will make valid SAS names for the variables.

Do you have the data in a TEXT file, such as a CSV file?

In that case READ the data with your own data step and you can can control the names of the variables, including attaching the descriptive labels.