In pc sas , I opened a program but with same file name,i kept files in several places. After few modifications of program, getting doubt, which location file currently modified? is there any option in pcs sas to display path of program? when i put cursor on this icon in the below screenshot, i would like to get full path of program somewhere of sas editor.   ... View more

You misunderstood my question( may be not clear from my side) Explanation:  I opened a program in sas and full path of that program to be displayed in somewhere of sas editor. is there anywhere options/settings to display? tool using is pc sas.             ... View more

  data both onlyA onlyB merge datasetA(in=first) datasetB(in=second); by sumtotal dT SYS PR AGT PID DATE; if first and second then output both; else if first and not second then output onlyA else if second and not first then output onlyB run; WARNING: Multiple lengths were specified for the BY variable sys by input data sets. This might cause unexpected results. WARNING: Multiple lengths were specified for the BY variable pr by input data sets. This might cause unexpected results. WARNING: Multiple lengths were specified for the BY variable agt by input data sets. This might cause unexpected results. WARNING: Multiple lengths were specified for the BY variable pid by input data sets. This might cause unexpected results. NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: There were 423581 observations read from the data set WORK.datasetA. NOTE: There were 420182 observations read from the data set WORK.datasetB. NOTE: The data set WORK.BOTH has 376201 observations and 7 variables. NOTE: The data set WORK.onlyA has 47380 observations and 7 variables. NOTE: The data set WORK.ONLYP5 has 43981 observations and 7 variables. ------------log--------------------------------------------------------------------------------------   merge conflicts confirmation I exported datasetA and datasetB seperately and then pasted these two in a new different excel(47380+43981 rows),Again imported in sas and used the proc sql to find the unique records and found only 3500+ unique records(means record may be in WORK.onlyA or may be in WORK.onlyB)   if any issues with log , how "both" contains that many number of records? I am totally confused can you help me.     ... View more

Thanks a lot. Oracle has Date datatype. helpful: Yes, Your solution is working as expected.   combined 2steps: month(datepart(post_date)) as month,  is also working fine. ... View more