aggregate data with proc export

[SergioSanchez]

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

[Reeza]

I believe you mean append data to a table?

I don't think it's possible

[RW9 · Accepted solution]

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.

[SergioSanchez]

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

[ballardw]

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.