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
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.
Hi Haikuo,
Thank you for your reply. I have figured out how to do it.
Thanks - Linlin
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: