Help using Base SAS procedures

Handling Invalid Characters in Variable Name

Accepted Solution Solved
Reply
N/A
Posts: 1
Accepted Solution

Handling Invalid Characters in Variable Name

This may be a very simple question and maybe my newness to SAS is shining through, but I tried to do some research and haven't been able to find an answer. 

I have been working on redoing an existing PROC SQL program to change it to a PROC MEANS program, with great success.  I have already been able to reduce the time it takes the program to run from about 3-4 hours down to 3-4 minutes.  I have hit a bit of a wall though with trying to add one of the variables in the dataset to my CLASS statement.  The name of the existing variable is Channel(Finance Method), which the PROC SQL program seems to be able to handle okay, but my PROC MEANS statement doesn't allow and errors out.  In the PROC SQL command it was simply included with single quotes, which doesn't work for PROC MEANS.

Does anyone have any ideas how I could include this variable in my class statement?  Because of the size of the data set I can't really create a new data set just for this one problem, so I am trying to figure out how to work with the existing data set and read in this variable as part of my program.

The current report actually changes the variable to "Channel" for the final report, so I am okay with manipulating the data.

Thanks in advance.


Accepted Solutions
Solution
‎08-24-2015 08:18 AM
Super User
Posts: 9,687

Re: Handling Invalid Characters in Variable Name

Code: Program

options validvarname=any;
proc means data=x nway;
class 'Channel(Finance Method)'n;
var x;
run;

View solution in original post


All Replies
Solution
‎08-24-2015 08:18 AM
Super User
Posts: 9,687

Re: Handling Invalid Characters in Variable Name

Code: Program

options validvarname=any;
proc means data=x nway;
class 'Channel(Finance Method)'n;
var x;
run;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 235 views
  • 0 likes
  • 2 in conversation