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;
Easily handled in a DATA step
data want;
set bh_d_zab_x_alok;
by data_danych;
if first.data_danych;
run;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: