Hi all
I have a code where I exported the data to an excel sheet and I wonder if is possible to aggregate data to the sheet without delete the data is placed before. My purpose is to make an accumulate with the data I exported from SAS and for making a dynamic table.
Regards
TBH I would import that data, append the data, and then write out a new file. Am not sure there is an easy way to modify data already present - Excel really isn't the best tool for data. You could also output your data to and Excel file and then copy and paste it in.
I believe you mean append data to a table?
I don't think it's possible
TBH I would import that data, append the data, and then write out a new file. Am not sure there is an easy way to modify data already present - Excel really isn't the best tool for data. You could also output your data to and Excel file and then copy and paste it in.
I got it
I followed your advice and it works, perhaps is not an elegant solution but for now it is sufficient.
thanks for your help
I believe this might be possibly using tagsets.excelxp and proc print followed by proc means with all output directed to the same page, ie sheet_interval=none option.
But without knowing which type of aggregation an current export method just a guess.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.