Your SAS programs, embedded in web apps and elsewhere

cascading_prompt_test

Accepted Solution Solved
Reply
Contributor
Posts: 48
Accepted Solution

cascading_prompt_test

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;


Accepted Solutions
Solution
‎03-02-2012 10:52 AM
Regular Contributor
Regular Contributor
Posts: 166

cascading_prompt_test

Posted in reply to twocanbazza

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

View solution in original post


All Replies
Super Contributor
Posts: 356

cascading_prompt_test

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

Barry

Contributor
Posts: 48

Re: cascading_prompt_test

Posted in reply to twocanbazza

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.

Super Contributor
Posts: 356

cascading_prompt_test

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

Solution
‎03-02-2012 10:52 AM
Regular Contributor
Regular Contributor
Posts: 166

cascading_prompt_test

Posted in reply to twocanbazza

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

Contributor
Posts: 48

Re: cascading_prompt_test

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.

Regular Contributor
Regular Contributor
Posts: 166

cascading_prompt_test

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

🔒 This topic is solved and locked.

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

Discussion stats
  • 6 replies
  • 382 views
  • 0 likes
  • 3 in conversation