topic Re: How to show one result in record in SAS Programming

How to show one result in record

Gieorgie — Mon, 04 Apr 2022 09:43:48 GMT

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;

Re: How to show one result in record

PaigeMiller — Mon, 04 Apr 2022 10:21:23 GMT

Easily handled in a DATA step

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

Re: How to show one result in record

Ksharp — Mon, 04 Apr 2022 11:44:02 GMT

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;

Re: How to show one result in record

Patrick — Mon, 04 Apr 2022 13:40:22 GMT

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;