Hi,
I have created a prompt using the SAS stored process under EG 7.1 - please see the attached prompt window. However, even when i select the Gender = 'M', the report generated from the stored process shows all the records including Gender = 'F'. Can someone see whats going on here.
Please advise.
How is your SAS code using the MULTISELECT_GENDER macro variable? This code should work for the simple case that you show:
proc print data=sashelp.class;
where (sex eq "&MULTISELECT_GENDER");
run; quit;
Vince DelGobbo
SAS R&D
Very likely you haven't modified that task that uses the filter to exploit it properly. Take a look at that, and try to figure out what you need to do to use the value of your prompt selection...it will be a macro variable.
Tom
Thanks Tom.
Am looking at the LOG from the Stored process and the macro variable seem to resolve fine - user selects the "M" for Gender. Following is the partial paste from log. Not sure why the report from the Stored process also includes Gender = 'F' along with 'M'.
>>> SAS Macro Variables:
MULTISELECT_GENDER=M
MULTISELECT_GENDER_COUNT=1
Unfortunately, I don't currently have access to an SP environment, so I can't provide a recipe to follow. Someone else will have to pick it up from here.
How is your SAS code using the MULTISELECT_GENDER macro variable? This code should work for the simple case that you show:
proc print data=sashelp.class;
where (sex eq "&MULTISELECT_GENDER");
run; quit;
Vince DelGobbo
SAS R&D
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.