Hello all, Below are my codes data temp1; merge a.icustay_FY17 a.nutrition_FY17 a.GI_FY17 a.NPO_FY17; by encounter date; run; proc print data=work.temp1; run; proc sort data=work.temp1; by encounter icu_stay; run; proc summary data=work.temp1; var ts; by encounter icu_stay; output out=temp2(keep=encounter icu_stay first last)min=first max=last; run; data work.temp3; merge work.temp1 work.temp2; by encounter icu_stay; rename first=admit_ts2; rename last=discharge_ts2; ts_24hr2=first+(60*60*24); format ts_24hr2 datetime16.; run; Issue is when I am running a proc print of temp1, it is showing me the variables coming from the file I am merging plus variables created in temp3 (for example admit_ts2, discharge_ts2,ts_24hr2,n_day). I haven't seen this thing in my 2 years of experience. I spoke to one of my colleague who is also a SAS programmer, more experienced than me. He said that he cannot see anything wrong in my codes and there is no error in log. He also didn't know that what is causing this unexpected behavior. He gave me a suggestion to move my files from shared folder to a personal folder and run the program. I am going to do this and see if it works. Please let me know if you can see any error or you have any suggestions. Thanks to all of you for replying
... View more