Hi DartibaliRodrigo, Thank you for the suggestion and I tried your code but my physical location is on the server side, so seems like it does not work. However, I do get an email from SAS support and actually this is a very simple problem and I just forgot the range= option. I mean I just need to specify the range start from second row. I guess the only issue for this method is you have to know how many rows in your excel file but you can always give a large number though. Thank you again for your help!
... View more