How to show one result in record

[Gieorgie]

I have a code that checks for me if there is any record for the last day of the month. However, I would need it to show me only one item, i.e. one record, not 148,000 dates as in the photo below

proc sql;
create table BH_D_ZAB_X_ALOK as 
select DATA_DANYCH as DATA_DANYCH from cmz.BH_D_ZAB_X_ALOK_&thismonth
             where DATA_DANYCH eq intnx('month',DATA_DANYCH,0,'e')
			 group by DATA_DANYCH

			  ;
quit;

[PaigeMiller]

Easily handled in a DATA step

data want;
    set bh_d_zab_x_alok;
    by data_danych;
    if first.data_danych;
run;

[Ksharp]

proc sql;
create table BH_D_ZAB_X_ALOK as
select distinct DATA_DANYCH as DATA_DANYCH from cmz.BH_D_ZAB_X_ALOK_&thismonth
where DATA_DANYCH eq intnx('month',DATA_DANYCH,0,'e')
group by DATA_DANYCH

;
quit;

[Patrick]

proc sql;
  create table BH_D_ZAB_X_ALOK as
    select max(DATA_DANYCH) as DATA_DANYCH 
    from cmz.BH_D_ZAB_X_ALOK_&thismonth
    where DATA_DANYCH eq intnx('month',DATA_DANYCH,0,'e')
  ;
quit;