BookmarkSubscribeRSS Feed
Linlin
Lapis Lazuli | Level 10

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

2 REPLIES 2
Haikuo
Onyx | Level 15

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.

Linlin
Lapis Lazuli | Level 10

Hi Haikuo,

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

Thanks - Linlin

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1409 views
  • 0 likes
  • 2 in conversation