grouping the data while extract it from database by where clause

BaharH — Fri, 05 Feb 2021 08:50:15 GMT

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;

Re: grouping the data while extract it from database by where clause

LinusH — Fri, 05 Feb 2021 09:42:26 GMT

Since you are using SQL pass through, this is not a SAS question really.

You should redirect this optimization inquire to forum specific for your source database.

topic Re: grouping the data while extract it from database by where clause in SAS Programming

grouping the data while extract it from database by where clause

Re: grouping the data while extract it from database by where clause