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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.