topic Re: how to put the outputs of proc freq to excel file in ODS and Base Reporting

how to put the outputs of proc freq to excel file

Linlin — Tue, 27 Mar 2012 16:04:36 GMT

Hi All,

I need to update an excel file annually with numbers from outputs of Proc freq or proc tabulate. What I did in previous years was to update the numbers manually. How can I update the excel file by sas code?

Attached please find my excel file.

Thank you very much for your help!

Linlin

Re: how to put the outputs of proc freq to excel file

Haikuo — Tue, 27 Mar 2012 16:11:32 GMT

It seems to me a DDE task. DDE will grant you the flexibility , control and accuracy to put data elements into whatever excel cells. As long as your excel table not changing or changing but with codeable rules. This can't be told in a few sentences, So go ahead do a search DDE sugi paper to get you started.

Edit: on the other hand, if it is only annual job, I wonder if it is really worth the effort, as DDE involves strenuous hard coding.

Re: how to put the outputs of proc freq to excel file

Linlin — Tue, 27 Mar 2012 23:34:14 GMT

Hi Haikuo,

Thank you for your reply. I have figured out how to do it.

Thanks - Linlin