Hi, i have  2 tables that I would like to merge Into a new 3rd table. table1 has "A" service only and table 2 has " B"service only. What I'm looking to do is count how many A-service were done and how many B-service were done in addition how many times service A-B were done on the same date. table-A Date.           ID.     Service 01/01/13     5A.      Service A 01/02/13.     6A.      Service A table-B Date.           ID.     Service 01/01/13     5A.      Service B 01/03/13.     6A.      Service B final table ID.      Service.    Date 5A.        2 A/B.      01/01/13 6A.        1 A.          01/02/13 6A.        1B.             01/03/13 Thank you in advance ... View more

HI I have this snippet of code where I'm trying to pull last month data. I would like it to pull last month data no matter when it's run. thanks for your assistance ... I attach  error log data temp; curr_date = "10Mar2013"d; first_day_prev_month = intnx('month',curr_date,-1,'B'); last_day_prev_month = intnx('month1',curr_date,-1,'E'); call symput('dt', "'"||put(first_day_prev_month, mmddyyd10.)||"'"); call symput('dt1', "'"||put(last_day_prev_month, mmddyyd10.)||"'d"); format curr_date first_day_prev_month last_day_prev_month mmddyyd10.; run; proc sql; connect to Access as db (path="T:\CCMS Production\CCMSProduction.accdb"); create table Dep as select * from connection to db (select * from [tbl_depositcompliance] where tbl_depositcompliance.Scheduled_Settle between &dt. and &dt1. ); quit; 1901  proc sql; 1902  connect to Access as db (path="T:\CCMS Production\CCMSProduction.accdb"); 1903  create table Dep as 1904  select * from connection to db (select * from [tbl_depositcompliance] 1905  where (tbl_depositcompliance.Scheduled_Settle SYMBOLGEN:  Macro variable DT resolves to '02-01-2013' 1905!                                               between &dt. SYMBOLGEN:  Macro variable DT1 resolves to '02-28-2013'd 1905!                                                            and &dt1.) 1906  ); ERROR: Prepare: Syntax error (missing operator) in query expression        '(tbl_depositcompliance.Scheduled_Settle between '02-01-2013' and '02-28-2013'd)'. SQL statement: select * from [tbl_depositcompliance] where (tbl_depositcompliance.Scheduled_Settle        between '02-01-2013' and '02-28-2013'd) 1907 1908  quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           4.42 seconds       cpu time            0.03 seconds ... View more

Hi, I have a data step where I'm converting a date/time field into just date and formatting it to monname5. ( I tried monyy5.) in the second table I would like to group by the month but it seems like even though its a month it still has days same number if it was days. in addition when I export it out to excel it converts the monname format back to a muddy format ...enclose is a snapshot of the script ...thanks for your assistance DATA DeActive ; set DeActive ; DATE=datepart(TranDate); FORMAT DATE monyy7.; RUN; proc sql; CREATE TABLE CCMS AS (SELECT Atmcodenumber, Date, AVG(DispCashAmt) As Avg_DispCashAmt , AVG(DispCashCnt)As Avg_DispCashCnt , Avg(CurrInitAmt) As Avg_Replen, Avg(CashAddAmt) As Avg_Cash_Add FROM DeActive    group by DATE,Atmcodenumber ); run; ... View more

Data Test_3; Set Test_3; if find(Deposit_Pull_Schedule,substr(left(put(today(),weekdate.)),1,3))-1 then deliveryday="NO ";else deliveryday="YES"; Run; I'm trying to create and IF statement currently in the cell I could have 1)MON 2)MON WED THU 3)MON TUE WED THU FRI I need the if statement to look at cell name Deposit_Pull_Schedule to see if there is a match. Since report is running from yesterday pull I would like it to look for all of THU only. Currently it gives me all no ... View more