DATA Step, Macro, Functions and more

Append the data in the excel

Reply
Contributor
Posts: 32

Append the data in the excel

Hi,

I need to append the data in the excel every month on a column wise using Libname excel method.    

For example:i need to append the data everymonth

How can i do this..it would be helpfull if you suggest me on the same

thanks

shruthi

Valued Guide
Posts: 2,175

Re: Append the data in the excel

1 libname pointing into the rangename in excel (the data to be extended))

libname exl 'your_workbook' ;

2

proc append base = exl.rangenam1 data= dataset_of_newrows ;

run ;

(but I have no sas/access to pc files to test this)

Ask a Question
Discussion stats
  • 1 reply
  • 210 views
  • 0 likes
  • 2 in conversation