cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Shakti_Sourav
Quartz | Level 8 Shakti_Sourav
Quartz | Level 8

Unable to filter the data in sas data integration studio

Posted 08-18-2023 06:09 AM (628 views)

Dear Team,

We are unable to filter the data in SAS Data integration studio. It's showing SQLPLAN Internal ERROR. 

I have attached a screenshot for your reference. 

Shakti_Sourav_0-1692353354038.png

 

Thanks & Regards

Shakti

 

0 Likes
Reply
2 REPLIES 2
JosvanderVelden
SAS Super FREQ JosvanderVelden
SAS Super FREQ

Re: Unable to filter the data in sas data integration studio

Posted 08-18-2023 06:27 AM (617 views)  |   In reply to Shakti_Sourav
Have a look at this note: https://support.sas.com/kb/42/425.html
And verify if the workaround resolves the issue you are facing.
0 Likes
Reply
LinusH
Tourmaline | Level 20 LinusH
Tourmaline | Level 20

Re: Unable to filter the data in sas data integration studio

Posted 08-21-2023 03:00 AM (595 views)  |   In reply to Shakti_Sourav

Can you share the SQL generated by he transformation?

Data never sleeps
0 Likes
Reply

sas-innovate-white.png

🚨 Early Bird Rate Extended!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Lock in the best rate now before the price increases on April 1.

Register now!

How to Concatenate Values

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

Watch How to Concatenate Values on YouTube

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
  • ‎08-18-2023 06:09 AM
  • 629 views
  • 0 likes
  • 3 in conversation