You mention "only want to bring back the date", yet you have the YEAR function coded? Interesting.
You will also want to review PROC SQL procedure discussion in the SAS documentation, available at the SAS support http://support.sas.com/ website, along with other topic-related technical papers and conference presentations on relevant topics.
Scott Barry
SBBWorks, Inc.
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473669.htm
... View more