I would like to use the box to select the date, e.g. June 30, and then I would like to create a table from the library credit with two columns where Default is 1 This is my code, but nothing happens, the window does not appear, but with the dates from the initial start of the program. How to replace the code so that after pressing the runes, the date selection window will open and then create a table with these two items. Where is the mistake %let gv_dateDEF=%sysevalf(%bquote('&data.'d));
%let yy=%sysfunc( YEAR(&gv_dateDEF.),z4.);
%let mm=%sysfunc(MONTH(&gv_dateDEF.),z2.);
%let dd=%sysfunc( DAY(&gv_dateDEF.),z2.);
%let gv_tbl_date=%eval(%str(&yy&mm&dd));
proc sql;
create table NewDef as
select
spr_NRB,
where(spr_DEFAULT = 1)
from credit;
... View more
