topic cascading_prompt_test in Developers

cascading_prompt_test

AshleyM — Wed, 29 Feb 2012 20:01:46 GMT

I wanted to follow along with this cascade_prompt_test but cannot get pass the first step. In order to copy the sashelp.prdsale data set to the STP librabies the corresponding usage note 35107 instructed me to use this code. However, I get the following error:

ERROR: User does not have appropriate authorization level for library OUT.

libname out "!sasroot\inttech\sample";

data out.prdsale;

set sashelp.prdsale;

run;

cascading_prompt_test

twocanbazza — Thu, 01 Mar 2012 00:04:53 GMT

My Guess is that you don't have permission to write to that library/folder - speak to your admin

Barry

Re: cascading_prompt_test

AshleyM — Thu, 01 Mar 2012 15:23:10 GMT

Thanks Barry. I spoke with IT and I have administrative privileges. I guess I'll have to contact SAS since I don't know why it's not working.

cascading_prompt_test

twocanbazza — Thu, 01 Mar 2012 22:45:09 GMT

If you are doing it as a STP it may not be your specific user ID that is accessing the library.

cascading_prompt_test

NN — Fri, 02 Mar 2012 15:52:54 GMT

Hi,

I would suggest that instead of copying your prdsale sample data to the root STPSamples directory , why dont you copy it to a library that is registered in your metadata and then follow the rest of the steps mentioned in the sasnote to register your table and use it in your prompts...

Re: cascading_prompt_test

AshleyM — Wed, 07 Mar 2012 20:12:37 GMT

To expand on cascading prompts, I'm trying to create a cascading prompt where the user selects "var1", he or she then has the option of selecting "var2". I've stored my data to a library in my metadata and when I specify the prompt type and values for the prompt "var1", I do not see my variable listed in the drop down menu. Are cascading prompts limited in that if "var1" is numeric I will not be able to choose this from the menu? I see "var2" but "var2" is also a character variable.

cascading_prompt_test

NN — Fri, 09 Mar 2012 14:08:55 GMT

Hi,

I think currently when defining your prompt for VAR1 you are selecting your promt type as TEXT i.e why you are unable yo view this variable in your dropdown list.

Try chaging the PROMPT TYPE to NUMERIC . you should be able to view your VAR1..