Dear Friends,
I am facing typical issue. My PROC SQL extraction and join works in EG, but not in DI Studio.
But in EG the join and extract is fine.
Anyone faced this before?
@Amitkmr1979
I pulled the following explanation from a track opened yesterday (this wouldn't happen to be you also?), hopefully this will help you understand it:
You will receive this error message when a procedure requires the data to be in a certain sorted order. The SORTEDBY flag on the table indicates the order of the data. However, the actual data in the table is not in the correct sorted order. This can happen when the SORTEDBY option is used to manually specify the sort order of a table. A flag called VALIDATED is set on the table to indicate if the data has been checked for correct order. The VALIDATED flag will be set to NO on the dataset when you use the SORTEDBY option to set the sort order of the table. In this case, SAS does not verify the data is in the correct sort order. The VALIDATED option will be YES when the table has been sorted by the SORT or SQL procedure.
You can execute the following sample code from the SAS Data Integration Studio Code Editor to find the settings for the table:
libname <libref> ....; /*libname statement to assign the library containing the table*/
proc contents <libref>.<tablename>;
run;
The output will be similar to the following:
You should sort the data in the required order using the SORT or SQL procedure to avoid the error message.
Please send a copy of the SAS program and a copy of the PROC CONTENTS of the table if this information does not resolve the issue.
@Amitkmr1979
I pulled the following explanation from a track opened yesterday (this wouldn't happen to be you also?), hopefully this will help you understand it:
You will receive this error message when a procedure requires the data to be in a certain sorted order. The SORTEDBY flag on the table indicates the order of the data. However, the actual data in the table is not in the correct sorted order. This can happen when the SORTEDBY option is used to manually specify the sort order of a table. A flag called VALIDATED is set on the table to indicate if the data has been checked for correct order. The VALIDATED flag will be set to NO on the dataset when you use the SORTEDBY option to set the sort order of the table. In this case, SAS does not verify the data is in the correct sort order. The VALIDATED option will be YES when the table has been sorted by the SORT or SQL procedure.
You can execute the following sample code from the SAS Data Integration Studio Code Editor to find the settings for the table:
libname <libref> ....; /*libname statement to assign the library containing the table*/
proc contents <libref>.<tablename>;
run;
The output will be similar to the following:
You should sort the data in the required order using the SORT or SQL procedure to avoid the error message.
Please send a copy of the SAS program and a copy of the PROC CONTENTS of the table if this information does not resolve the issue.
I cant be more than happy. you were right, the earlier mail was from my colleague which was sent. I am just trying to help them but I am continents apart.
It resolved the issue.
Thanks.
Hi AMSAS,
Can I call you ? I don't know how to insert my private number.
But my email ID is aka.amit@gmail.com.
If you okay for me to call.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.