05-31-2016 12:44 PM
You may need to provide some actual examples. This example may give you a starting point.
data junk; x= 'Tuesday, June 1, 2016'; y=input(substr(x,index(x,' ')),anydtdte15.); format y mmddyy10.; run;
05-31-2016 01:26 PM
HI PGStats/Ballardw......Thanks for both your suggestions. I tried both of them and they gave me the exact same results with one problem. When the date had a single interger for the day number in the date ( Thu. May 7, 2015) , it produced a blank space otherwise worked perfect. Thanks
05-31-2016 01:50 PM
We would have to see your data and the actual code you ran to see what was generating the space.
I can't duplicate the issue with your Thu. May 7, 2015 example even inserting an additional space into the input between the month and the day of the month. It may be you have some sort of non-printable character or a double-byte conversion issue.
Need further help from the community? Please ask a new question.