copy/paste from excel into sas data step

#1
Hello, I am trying to copy a table in excel and paste it into SAS (rather than using a proc import step). Because the excel is not in a comma delimited format, the pasted table is separated by space, and the space varies according to the variable length. As follows:
Code:
1/4/2010	26.65	26.80	0.15	 1	4768.91	4811.30	4758.20	4809.88
1/14/2010	26.86	26.89	-0.03	 0	4736.35	4771.94	4735.06	4750.21
Simply using an input statement doesn't work. What do I need to do to specify in input or format for that table to be automatically read into SAS?
 
Last edited: