%let sysmonth= %sysfunc(month("&sysdate"d)); %let sysyear= %sysfunc(year("&sysdate"d)); %put &sysmonth &sysyear; Remember that SYSDATE has the start date of the SAS session, not the calendar date at the time of execution. 3 Likes chuckdee4 Calcite | Level 5 Re: Extracting m...
300 600 d. Year Qtr Budget Sales 2001 2001 2002 3 4 1 500 400 700 300 300 600 3. Which one of the following programs is syntactically correct? a. proc sql; create table forecast as select a.*, b.sales from actual a, budget b where a.dept=b.dept and a.month=b.month; quit; ...
date2 date9.; /* Get the interval between the dates in years*/ Years_ = INTCK('YEAR',date1,date2); /* Get the interval between the dates in months*/ months_ = INTCK('MONTH',date1,date2); /* Get the week day from the date*/ weekday_ = WEEKDAY(date1); /* Get Today's ...
%let sysmonth= %sysfunc(month("&sysdate"d)); %let sysyear= %sysfunc(year("&sysdate"d)); %put &sysmonth &sysyear; Remember that SYSDATE has the start date of the SAS session, not the calendar date at the time of execution. 3 Likes chuckdee4 Calcite | Level 5 Re: Extracting m...
if I want to run the query in SAS, I don't find trunc(sysdate -1) select DISTINCT a.APPLICATION_ID, a.CRTD_USER_ID, a.FRM_TYP_IDFROM APPLICATION_CDIM a where weekday(a.updt_load_dttm) = 1; and get 0 row and not sure it's corrected to pull a day old from a column, updt...