Hi @FreelanceReinh  Thank you for your suggestion, I test and see the chl_d was a view so I delete the view, what I received is : the warning move upto another set of datastep After all, I am pretty sure that the warning is caused by this datastep 449 /* Add one-day-ahead eta */ 450 options mergenoby=nowarn; 451 data previous_replace_/view=previous_replace_; 452 merge previous_replace previous_replace 453 (firstobs=2 keep=eta rename=(eta=eta_lead1)); 454 run; NOTE: DATA STEP view saved on file WORK.PREVIOUS_REPLACE_. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 455 options mergenoby=warn; My guess is, because I turn on and off mergenoby here, so it does not announce warning here, but afterwards, when I work on this dataset( previous_replace_ ), it announces the warning. For example 459 data chl_d;/*chl for daily*/ 460 set previous_replace_; /* Replace the filename based on previous step*/ 461 by gviidkey datadate; 462 year=year(DATADATE); 463 if last.gviidkey then 464 eta_lead1=.; 465 S_2DC=sqrt(max(4*(c-eta)*(c-eta_lead1), 0)); 466 467 468 if missing (c) or missing (eta) or missing (eta_lead1) then 469 S_2DC=.; 470 run; WARNING: No BY statement was specified for a MERGE statement. and 503 data chl_yc_d;/*chl for yearly corrected daily frequency*/ 504 set previous_replace_; /* Replace the filename based on previous step*/ 505 by gviidkey datadate; 506 year=year(DATADATE); 507 if last.gviidkey then 508 eta_lead1=.; 509 s_yc_d=(c-eta)*(c-eta_lead1); 510 if missing (c) or missing (eta) or missing (eta_lead1) then 511 s_yc_d=.; 512 label s_yc_d= daily chl of yearly-corrected method; 513 run; WARNING: No BY statement was specified for a MERGE statement.   Warmest regards. ... View more

Hi @Kurt_Bremser  Thank you for your suggestion, but I thought I set the option megernoby=warn already in my code, it can be seen from the log I posted previously 449 /* Add one-day-ahead eta */ 450 options mergenoby=nowarn; 451 data previous_replace_/view=previous_replace_; 452 merge previous_replace previous_replace 453 (firstobs=2 keep=eta rename=(eta=eta_lead1)); 454 run; NOTE: DATA STEP view saved on file WORK.PREVIOUS_REPLACE_. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 455 options mergenoby=warn;   Warm regards. ... View more

Thank you @FreelanceReinh for your dedicated explanation. I just delete the view for the mentioned dataset then rerun the whole code, so the log just gone. It took around 2 hours so I may go to bed and will come back to the result tomorrow morning.   Warmest regards and cheers, Phil. ... View more

@WarrenKuhfeld  Thank you for your reply. Because it is a large dataset so I want to ask one further question. So, we can fix it or we can also leave the warning but the result will not be wrong? I hope that I did not fall into a fallacy.   Warm regards. ... View more

Hi @FreelanceReinh  and @WarrenKuhfeld  Thank you for your reply, here is the log until it announces the warnings 449 /* Add one-day-ahead eta */ 450 options mergenoby=nowarn; 451 data previous_replace_/view=previous_replace_; 452 merge previous_replace previous_replace 453 (firstobs=2 keep=eta rename=(eta=eta_lead1)); 454 run; NOTE: DATA STEP view saved on file WORK.PREVIOUS_REPLACE_. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 455 options mergenoby=warn; 456 457 *Calculating s_2dc (s of two-day corrected method); 458 459 data chl_d/view=chl_d;/*chl for daily*/ 460 set previous_replace_; /* Replace the filename based on previous step*/ 461 by gviidkey datadate; 462 year=year(DATADATE); 463 if last.gviidkey then 464 eta_lead1=.; 465 S_2DC=sqrt(max(4*(c-eta)*(c-eta_lead1), 0)); 466 467 468 if missing (c) or missing (eta) or missing (eta_lead1) then 469 S_2DC=.; 470 run; NOTE: DATA STEP view saved on file WORK.CHL_D. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: View WORK.PREVIOUS_REPLACE_.VIEW used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 17 The SAS System 22:42 Thursday, March 25, 2021 NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 471 472 473 474 /*Calculating CHL for each firm per year*/ 475 proc means data=work.chl_d noprint; 476 by gviidkey year; 477 var S_2DC appday; 478 id LOC; 479 Output out=chl_2d_year (keep=gviidkey year LOC CHL_2d_c appdaysum where=(appdaysum >=12)) 480 mean=CHL_2d_c sum(appday)=APPDAYSUM; 481 /*Explain: mean of all S_2DC of one company in a year is called CHL 482 sum SC APPDAYSUM means SC is sum of S_2DC and APPDAYSUM is sum of APPDAY*/ 483 run; WARNING: No BY statement was specified for a MERGE statement. Thank you and warm regards, Phil. ... View more

Hi @ChrisHemedinger    Thank you for your dedicated guide, can I aks how could I do that "you would need these SAS programs to be in files outside of the project file" I extract them already, now how can I compare if I do not put them into one project to compare ?     Warm regards. ... View more

@ballardw  An amazing suggestion and explanation for me, which really benefits me in the future because I am keen on something that I can play with like that.   Warmest rergards. ... View more

Hi @ChrisHemedinger  Thank you for your suggestion,m but I use SAS EG 8.3, but when I open the property for a program in a project in SAS EG, I got this box, which does noit have the same function like yours And I right click on the project instead of the program, I have Could you please help me to sort it out? Warm regards. ... View more

Hi @qoit  Thank you for your solution, I am of curiosity, For example I want to get the monthly data after this day I replicate your code but it does not work, could you please help me to sort it out?   DATA SAMPLE3; SET romania (where=(datadate > "01JUL2005"m )); /*I changed from d to m here*/ run; proc means data=SAMPLE3; class curcdd; var exchg; run; The log is 35 SET romania (where=(datadate > "01JUL2005"m )); ____________ 49 22 76 ERROR: Syntax error while parsing WHERE clause. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, GE, GT, LE, LT, NE, OR, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. Warm regards.     ... View more

Hi @ChrisNZ  Thank you for your reply.   a. But I just created these two files in the same project in the same computer, so I am wondering how come they came from Unix/Linux and Windows respectively. It is quite strange to me. b. Yes, I did save as I mentioned and there is nothing change in the program in SAS EG, I may fall in a fallacy here, could you please hint me out?   Warm regards.     ... View more