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
Obsidian | Level 7 Shakti_Sourav
Obsidian | Level 7

Unable to filter the data in sas data integration studio

Posted 08-18-2023 06:09 AM (108 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 (97 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 (75 views)  |   In reply to Shakti_Sourav

Can you share the SQL generated by he transformation?

Data never sleeps
0 Likes
Reply

SAS INNOVATE 2024

Innovate_SAS_Blue.png

 

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • ‎08-18-2023 06:09 AM
  • 109 views
  • 0 likes
  • 3 in conversation