topic aggregate data with proc export in SAS Procedures

aggregate data with proc export

SergioSanchez — Mon, 02 Jun 2014 14:17:47 GMT

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

Re: aggregate data with proc export

Reeza — Mon, 02 Jun 2014 14:32:17 GMT

I believe you mean append data to a table?

I don't think it's possible

Re: aggregate data with proc export

RW9 — Mon, 02 Jun 2014 14:32:51 GMT

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.

Re: aggregate data with proc export

SergioSanchez — Mon, 02 Jun 2014 15:37:13 GMT

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

Re: aggregate data with proc export

ballardw — Mon, 02 Jun 2014 15:37:51 GMT

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.