The basic requirement is that you should have SAS and Excel installed on the same machine and of course WIndows OS. Though SAS these days does not recommend it, this is the only direct option you have as I know of. The following SAS reference has good examples. Do read this, if you have not read already done so. (https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hostwin/p0rbba3syo5gf1n1gf17jd7zzhwq.htm) This another good reference ( https://www.lexjansen.com/nesug/nesug05/pos/pos15.pdf ) .
The instructions are pretty clear. In case you have an error please post the logs.
... View more