Davide, There is a hotfix for what you are looking for 51580 - The XLSX engine is enhanced to write multiple sheets per Microsoft Excel file in the first maintenance release of SAS® 9.3 (TS1M1) ... View more

Just an FYI, I tried and working fine for me when used replace option. Here is the code. proc export data=want outfile='C:\want.xls' dbms=excel replace; run; ... View more

20923 - How REPLACE option works with PROC EXPORT and Excel files in SAS 9.1 ... View more

Can you clarify if this how your data is? Data set 1 200000 Andrew, Skype 000006 520001 Walker, Walker 000006 200000 Andrew, Skype 000006 520001 Walker, Walker 000006 000006 Smith, John 000007 000007 Phil, Elias 000010 000008 Turner, Sandra 200000 000010 Santa, Clause 200000 Data set 2 000006 Smith, John 000010 Santa, Clause 000007 Phil, Elias 200000 Andrew, Skype Output 200000 Andrew, Skype 000006 Smith, John 520001 Walker, Walker 000006 Smith, John 200000 Andrew, Skype 000006 Smith, John 520001 Walker, Walker 000006 Smith, John 000006 Smith, John 000007 Phil, Elias 000007 Phil, Elias 000010 Santa, Clause 000008 Turner, Sandra 200000 Andrew, Skype 000010 Santa, Clause 200000 Andrew, Skype ... View more

Import the excel sheet to convert it into sas data set and then join with ID's. ... View more

Thanks for clarifying. I read the question incorrectly then. You are correct. Thank you so much for your quick reply. ... View more

Hi Reeza Sorry, its not my intention to put you in the spot. I just want to learn. The code you provided is not working. I am returning empty data set. data temp3; input string $ 1-11; cards; abcXxX/ _jklxxx abc.jjj xXx()lll xxx*aaa ; run; data temp4; set temp3; if notalpha(string) > 0 then delete ; run; proc print data = temp4; run; I love to learn from Masters like you. ... View more

Look-Ahead and Look-Back - sasCommunity ... View more

data have; input id date; format date mmddyy10.; informat date mmddyy10.; cards; 1 10/25/2015 2 10/15/2015 3 10/10/2015 ; run; data want; set have; if id ne 1 then date_new=put(date,mmddyy10.); else date_new=put(date,date9.); run; proc print; run; ... View more