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:
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?
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