Hi, I am wondering if there is an open source program that can replace SAS in handling data cleaning, database updates and functions like that. So far we are only using SAS base. I know R can be used in place of SAS as a statistical package but I am not sure if R is as capable in handling database and manipulations involving multiple data files ( about a few hundred thousands rows for some of them) I also use a lot of macros for these purposes and to my best knowledge R has no macro facility, there may be other ways to implement similar functionality but I haven't looked into it yet.
P.S. It has to have a windows version since we use windows at work.