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 (486 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 (475 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 (453 views)  |   In reply to Shakti_Sourav

Can you share the SQL generated by he transformation?

Data never sleeps
0 Likes
Reply

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 487 views
  • 0 likes
  • 3 in conversation