Help using Base SAS procedures

aggregate data with proc export

Accepted Solution Solved
Reply
Contributor
Posts: 68
Accepted Solution

aggregate data with proc export

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


Accepted Solutions
Solution
‎06-02-2014 10:32 AM
Super User
Super User
Posts: 7,397

Re: aggregate data with proc export

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.

View solution in original post


All Replies
Super User
Posts: 17,784

Re: aggregate data with proc export

I believe you mean append data to a table?

I don't think it's possible Smiley Sad

Solution
‎06-02-2014 10:32 AM
Super User
Super User
Posts: 7,397

Re: aggregate data with proc export

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.

Contributor
Posts: 68

Re: aggregate data with proc export

I got it Smiley Happy

I followed your advice and it works, perhaps is not an elegant solution but for now it is sufficient.

thanks for your help

Super User
Posts: 10,483

Re: aggregate data with proc export

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 166 views
  • 3 likes
  • 4 in conversation