How to convert the following merge step into joins. I just given the structure of the merge and in similar fashion I need to achieve the same in Joins. 'Khiref' is the variable which is common between the tables and it the relationship is many-to-many.    data want (drop=knkvpb knkvpb_v); merge work.varian1(in=vorige) in.grptabel(in=huidige); by khiref; if not vorige and huidige then do; knkbty = '6'; knkatv = knkatd_v; knkath = knkatd; end; if vorige and not huidige then do; knkbty='6'; knkatv = knkatd_v; knkath = knkatd; end; if vorige and huidige then do; if (knkatd ne knkatd_v) then do; knkbty = '6'; knkatv = knkatd_v; knkath = knkatd; end; run;  Sample data:    Below data is being used as input data sets but values of few variables differ between the datasets..   KHIREF KNDTOPD TLK KNKRSG INKWZK KNKKRT KNKATD KNDATLD BVILTS BVDBLTD PODVERD KNDBEGD KNDEIND KNKBIN POKSYN KNKTAS KNKBZA MIK ZTK PSI AGI PUKDET KNBJPN KNBCOW KNBTKS KNBKST AGIABR POKTYD PDK KNKVPB GNKSEC D1IPAR P2KBRN KNBJPB KNBKRT P2KPSH KNBCOT KNBCOA POKBDU 2011021557 30/09/2018 1 0 1 3 1 01/07/2008 1 11/05/2013 01/07/2019 01/07/2008 30/06/2019 0 0 0 1 3 10 418210038 45025 999 262.38 39.36 71.08 0.00 0 2 1 0 92094F00- 28 16 262.38 0.00 1 79.72 40.36 0 2011021549 30/09/2018 1 0 1 3 1 01/07/2008 1 11/05/2013 01/07/2019 01/07/2008 30/06/2019 0 0 0 1 3 10 418210038 31397 999 524.76 78.72 142.16 0.00 0 2 1 0 92094F00- 28 16 524.76 0.00 1 79.72 80.72 0 ... View more

How to convert the following merge step into joins. I just given the structure of the merge and in similar fashion I need to achieve the same in Joins. Data merge; If a(in=x) b(in=y); By id; If x and y; Then; Do; F=7; End; If x; Then; Do; F=3; End; If y; Then; Do; F=9; End; Run; ... View more

I have updated (just the data for one field) one CSV file in the UNIX server and that file should be read by File Writer transformation.But for some reasons, file writer transformation taking only the old file as I could see only the data from the old file in the resultant dataset.What would be likely cause for this issue? ... View more

I've a macro variable and it resolves to date value as follows.     SYMBOLGEN: Macro variable FIRSTDAYOFREPORTINGMONTH resolves to 01SEP2018 24 %put FirstDayofReportingMonth = &FirstDayofReportingMonth; FirstDayofReportingMonth = 01SEP2018 25 %put LastDayofReportingMonth = &LastDayofReportingMonth; SYMBOLGEN: Macro variable LASTDAYOFREPORTINGMONTH resolves to 30SEP2018 LastDayofReportingMonth = 30SEP2018 Now I need to extract the data based on date value and I should not hard code the date value. Therefore I tried to to filter the data with the use of macros, but I'm getting the error as mentioned below. Appreciate if someone of you tell me to know to extract the data with the help of date macro.       /*ERROR-1*/ 68 /* where KNDTOP between '01sep2018'd and '30sep2018'd*/ 69 where KNDTOP between &FirstDayofReportingMonth. and &LastDayofReportingMonth. SYMBOLGEN: Macro variable FIRSTDAYOFREPORTINGMONTH resolves to 01SEP2018 SYMBOLGEN: Macro variable LASTDAYOFREPORTINGMONTH resolves to 30SEP2018 NOTE 138-205: Line generated by the macro variable "FIRSTDAYOFREPORTINGMONTH". 69 01SEP2018 _______ 22 ERROR 22-322: Syntax error, expecting one of the following: !!, *, **, +, -, /, AND, ||. /*ERROR-2*/ 68 /* where KNDTOP between '01sep2018'd and '30sep2018'd*/ 69 where KNDTOP between '&FirstDayofReportingMonth.'d and '&LastDayofReportingMonth.'d ERROR: Invalid date/time/datetime constant '&FirstDayofReportingMonth.'d. ERROR: Invalid date/time/datetime constant '&LastDayofReportingMonth.'d.       ... View more