BookmarkSubscribeRSS Feed
ralizadeh
Obsidian | Level 7

Hello, I'm using SAS Enterprise Guide 7.1, and this is what I accomplished with Query Builder. I inserted the DATE variable three times to the 'Select Data' tab, then used 'Summary' to find the COUNT, MIN, and MAX of the DATE variable. Everything worked out perfectly. 

 

Now, I would like to use the prompt instead. So, I've created a prompt with DATE as a variable. Again, DATE is the column name and its format is date in my dataset. The issue presently is that the prompt variable isn't listed as an option in the Query Builder. I only see the original dataset columns and not the prompt I created. Do you have any idea why?

 

Pictures are attached. 

 

Thank you

 

 

1.png

 

2.png

2 REPLIES 2
Aku
Obsidian | Level 7 Aku
Obsidian | Level 7

In static list you have enter values into list (below red circulated date). In dynamic list you can select values from the variable which is already existing in data.

ralizadeh
Obsidian | Level 7

What values to enter? I wouldn't need the prompt if I already knew the three numbers I needed!

I need to find the minimum, maximum, and count of the DATE variable. Tens of thousands of rows are stored in the table.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 1243 views
  • 0 likes
  • 2 in conversation