How can I create date as well as unit for all the combinations. What's wrong with this code? Data dummy; date="&start."d; do while (date<="&enddt."d); output; date=intnx('day', date, 1, 's'); end; format date date9.; array unit[3] $ '45' '55' '65'; do i=1 to 3; unit = unit[i]; end; ... View more

Any one have any ready made macro to get different days of the month into Date9. format. first day of the month, first day of the last week Last day of the last week last saturday of last week First day of the current week etc.. some thing similar data _null_; yday=put(date()-1,date9.); today=put(date(),date9.); lsat=put(date()-1,date9.);*take last Saturday; to = put(date(),worddate18.); mthy= put(date(),monyy7.); %let fdlw=%sysfunc(intnx(week,%sysfunc(today()),-1,b),date9.); %put first_day=&fdlw ; %let last_sat=%sysfunc(intnx(week.7,%sysfunc(today()),0,b),date9.); %put last_sat=&last_sat ; %let ldlw=%sysfunc(intnx(week.7,%sysfunc(today()),0,b),date9.);*Last Saturday; %put ldlw=&ldlw ; %let fdcm_=put(date()-15,date9.); call symput('rptdt',to); call symput('rptnumdt',today); *05FEB2021; call symput('ydt',yday);*05FEB2021; call symput('fdcm',fdcm_ ); call symput('my',mthy);*FEB2021; run; %let ydate= &ydt.; * yesterday's date ; %let Mydate= &my.; * yesterday's date ; %let From_date= &ydt. ; %let To_date=&rptnumdt.; %let FirstDay_CurMon=&fdcm.; %put _all_; ... View more

I am working on a report to automatically send daily report to the users with a table in the body of the email. One of the requirement is to have a column for total count, prior week counts and this weeks counts( break down by day).. Not sure how to add the columns as the week progress with their respective header names.   started to get last week dates but not sure how to add the columns in the proc report.. some times there might not be any data for that day but still need to show for the 3 products..   %let fdlw=%sysfunc(intnx(week,%sysfunc(today()),-1,b),date9.); %put first_day=&fdlw ; %let ldlw=%sysfunc(intnx(week,%sysfunc(today()),0,b),date9.); %put last_day=&ldlw ;   PROC REPORT DATA=daily_Counts nowd HEADLINE HEADSKIP SPLIT='*'   style (report) = {background = white   font_face = "Verdana" font_size = 7pt just=left }   style (column) = {background = white CELLHEIGHT = 2.5%   font_face = "Verdana" font_size = 7pt just=left}   style (header) = {foreground = cx5e2750 font_face="Verdana"   font_size = 8pt just=left   background = white} ;      column product Description Total_counts Prior_week Day1 Day2      ;    define Product / display width= 15 "Product";    define Description / display width= 30 " Description ";    define Total_counts / display width= 30 " ";    define prior_week / display width= 30 "”;    define Day1 / display width= 30 " ";   run; Product Description Total Products in the system Total Products in the system Received Prior week( Sunday to Saturday) Total Products in the system Received Sunday Total Products in the system Received Monday 1235 Item1 3173 1070 73 34 5432 Item4 340 96 19 2 6574 Item5 5 2 - 3 ... View more

How to establish SQL server connection string in SAS  using the following credentials? Stored Procedure:       SSSP_RES_V12_Load   Thank you ... View more