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.