In visual data builder expression date function while creating data query condition - where tab : I want place conditions like  Where start_date between intnx(week,start_date, 0,'B') and  intnx(week,start_date, 0,'E')   having said - I want to see a list of only those records where startdate is within the current week's first date of week and last date of week.    ... View more

Data _null_; MyDate = Today(); format MyDate mmddyy10.; put "Current Date " MyDate;   next_rundate = intnx('week', MyDate, 1,'B'); format next_rundate mmddyy10. put "next Run Date " next_rundate;   /* A - This print correct date after one week in mm/dd/yyyy format*/  run;   /* I want to store value at above line in to below update statement and in database field is date time  current below command just store dot (.) in date field - what do I do to convert next_rundate  in correct format so I can update thru table */   proc sql; update lib.table1 set next_rundate = "&next_rundate" DT where id =&id.; Run;     ... View more

%macro Update_table(a, id, c) ;   prc sql noprint ; select id into :id  from libnew.table1 where program="&a" select value into :username from SASHelp.vmacro where name = 'sysuserid' run; %put &username;   Proc SQL; update table1 set Username = &username where id = &id.; run; %mend Update_table;   The issue is I want to use :username result value with my update. I just want to know what's the best way to use :username variable in the update so I can update the value stored in the username variable.   ... View more