BookmarkSubscribeRSS Feed
ncsthbell
Quartz | Level 8

Not sure if this is the right 'community' to post this.  I did not find one for "SAS Information Map Studio".  If this is incorrect, please let me know where I should post this question.

I have built a prompt in SAS Information Map Studio 4.2 that accepts user enter values.  The data item the prompt is associated with is stored in uppercase text.  I am having an issue of the report not returning rows because of the case.  For example, they enter "Incoming" and the data item is stored as "INCOMING".  I can not figure out how to capture the value the user enters and put the function 'UPCASE' on it.  On the edit filter screen it looks like this:

Filter name : note_topic_prompt

Data item   : note

Condition   :  Like

Values:

   Prompt user for values(s)

   &note_topic_prompt [note_topic_prompt]

Can I convert whatever they enter into upper case or do they specifically have to enter upper case?

Thanks

2 REPLIES 2
art297
Opal | Level 21

This note was from 3.1 but I presume that you can use the same logic.  I think that you only need to apply the upcase function.

http://support.sas.com/kb/36/499.html

twocanbazza
Quartz | Level 8

You can ignore case in your prompt, if that is any use

Barry

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1216 views
  • 0 likes
  • 3 in conversation