Hi. I want to extract the most recent date from my data in each group. It's easy when I have a table ready. But when I want to extract from my metadata it doesn't work. especially with a where clause. My data is tooooooooo big. So I can't extract everything and then group it. Please help me. I used max(qtm.kalenderday) for the last data. PROC SQL; CONNECT TO ODBC AS mycon (datasrc=DMA_P); CREATE TABLE work.Company AS select * FROM CONNECTION TO mycon (SELECT qtm. Day, qtm. NR, qtm.name, qtm.kalenderday, qvm.WGnumber FROM dmameting_tr qvm, dm_ameting qtm, dmameting_wh WiK where qtm.qtmunitnr = WiK.meetunitnr and qtm.unitnr = qvm.unitnr and qtm.meettijdstip_dt = qvm.meettijdstip_dt and max(qtm.kalenderday) group by qvm.WGnumber ); run; DISCONNECT FROM mycon; QUIT; ... View more

Hi. In a sql data source, I want to extract a table with 4 columns with PROC SQL. But with a constrain. this constrain is a table (name: sleutel) with one column (name: sleutel2) which is stored in my laptop. This is my code. But it does not work. could you please help me?   data IA_data; set work.sleutel; run; PROC SQL; select ia.sleutel2 from IA_data ia; CONNECT TO ODBC AS mycon (datasrc=IA_P); select * FROM CONNECTION TO mycon (SELECT column1, column2, column3, column4 FROM ia_treinrit trr where column1 = ia.sleutel2 ); run; DISCONNECT FROM mycon; QUIT; ... View more