From: "Data _null_;" on
Don't know if you call it automatic or not...

title;



On 3/9/10, wlv(a)air.org <wlv(a)air.org> wrote:
> Hello there,
>
> I used the "View in Excel" a lot when I need to read the table in
> Excel. (The detail steps are: highlight the sas dataset in the
> explorer, and right click on it, then "view in excel" will pop up.
> Click on it, then the dataset will automatically export to excel).
>
> My question is: is there any way to remove the first two rows in the
> excel file (first line says "The SAS System", the second line is
> blank) in a programming way so that I don't have to remove them
> manually every time.
>
> THANK YOU!
> Wendy
>