Hi All,   I'm a newbie and I need to run a query against 400+ tables in a DB2 database to capture the max last update. Is it possible to have multiple "select" statements using 1 DB2 connection?   Also, how can get the results in a form of a list, for example: table1 1/1/2021 table2 1/2/2021 table3 1/3/2021 table4 1/4/2021 table5 1/5/2021   Here's the program and when I run it, it only returns the result from the 1st select statement. No errors in the log.   %udb(DB2P) SELECT * FROM CONNECTION TO DB2( SELECT MAX(DT_LST_UPDT) AS CD_EVNT_ONE_DT_LST_UPDT FROM DB2PROD.CD_EVNT_ONE; SELECT MAX(DT_LST_UPDT) AS CD_EVNT_TWO_DT_LST_UPDT FROM DB2PROD.CD_EVNT_TWO; SELECT MAX(DT_LST_UPDT) AS CD_EVNT_THREE_DT_LST_UPDT FROM DB2PROD.CD_EVNT_THREE; SELECT MAX(DT_LST_UPDT) AS CD_EVNT_FOUR_DT_LST_UPDT FROM DB2PROD.CD_EVNT_FOUR; SELECT MAX(DT_LST_UPDT) AS CD_EVNT_FIVE_DT_LST_UPDT FROM DB2PROD.CD_EVNT_FIVE; ); quit;   Thank you so much in advance!   Mary ... View more

Hi There,   I'm new to SAS, using SAS Enterprise Guide 7.12 and running this code. I can't seem to get a distinct list based on the dttm_create. I tried using group by and having, sub-query and all other different variations but nothing seem to work. The SQL runs fine (no sql error) but just not returning the correct results.   Can someone please help? I've been at this for 2 days now Thank you so much in advance!   PROC SQL; CREATE TABLE WORK.TABLE2 AS SELECT DISTINCT ID1, ID2, CYCLE_DATE, AMT, STATUS, MAX(DTTM_CREATE) FORMAT=DATETIME25.6 AS MAX_of_DTTM_CREATE FROM WORK.TABLE1 WHERE ID1 = '123456789' GROUP BY ID1, ID2, CYCLE_DATE, AMT, STATUS, DTTM_CREATE; QUIT;   This is the result I'm getting but the SQL should only give me the first row. ID1 ID2 CYCLE_DATE AMOUNT STATUS MAX_of_DTTM_CREATE 123456789 987654321 31-Dec-19 1.67 Active 03JAN2020:03:04:35.353335 123456789 987654321 31-Dec-19 2.01 Active 06DEC2019:02:48:35.810525 ... View more