https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-data-in-SAS-Information-Map-Studio/m-p/70009#M6992 A search on support.sas.com for "information map studio subset" gives med 284 hits. I'm sure you can find the instructions needed here.<BR /> <BR /> /Linus Tue, 08 Sep 2009 13:30:00 GMT LinusH 2009-09-08T13:30:00Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-data-in-SAS-Information-Map-Studio/m-p/70008#M6991 Hi,<BR /> <BR /> I am trying to replicate a SQL report in SAS. I have created an information map with necessary tables that are required to create the report. I have given relationship between the tables in the relationship pane of the SAS Information Map Studio. I need to restrict the data using where clause, group by feature as in normal SQL. Kindly guide me to proceed further.<BR /> <BR /> Regards,<BR /> Sujeev Tue, 08 Sep 2009 10:09:18 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-data-in-SAS-Information-Map-Studio/m-p/70008#M6991 deleted_user 2009-09-08T10:09:18Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-data-in-SAS-Information-Map-Studio/m-p/70009#M6992 A search on support.sas.com for "information map studio subset" gives med 284 hits. I'm sure you can find the instructions needed here.<BR /> <BR /> /Linus Tue, 08 Sep 2009 13:30:00 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-data-in-SAS-Information-Map-Studio/m-p/70009#M6992 LinusH 2009-09-08T13:30:00Z