cascading_prompt_test

[AshleyM]

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;

[twocanbazza]

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

Barry

[AshleyM]

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.

[twocanbazza]

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

[NN · Accepted solution]

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...

[AshleyM]

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.

[NN]

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..