Concatenating data frames in R versus SAS

Nordlund, Dan (DSHS/RDA) · 2012-08-23T23:38:08Z

> -----Original Message----- > From: r-help-bounces at r-project.org [mailto:r-help-bounces at r- > project.org] On Behalf Of ramoss > Sent: Thursday, August 23, 2012 1:55 PM > To: r-help at r-project.org > Subject: [R] Concatenating data frames in R versus SAS > > I am trying to concatenate 2 datasets that don't have exactly the same > column. > In SAS I did: data summary; > set agency prop; > run; > No problem > in R I get error message > summary Error in match.names(

Nordlund, Dan (DSHS/RDA)

Thu, Aug 23, 2012 4:38 PM

There may be a more R-ish way to do this, but here is a function to get you started.  

SASrbind <- function(x, y) {
  x[,setdiff(names(y),names(x))] <- NA
  y[,setdiff(names(x),names(y))] <- NA
  rbind(x,y)
  }

wanted <- SASrbind(agency,prop)


Hope this is helpful,

Dan

Daniel J. Nordlund
Washington State Department of Social and Health Services
Planning, Performance, and Accountability
Research and Data Analysis Division
Olympia, WA 98504-5204

Thread (4 messages)

ramoss Concatenating data frames in R versus SAS Aug 23 David Winsemius Concatenating data frames in R versus SAS Aug 23 Nordlund, Dan (DSHS/RDA) Concatenating data frames in R versus SAS Aug 23 ramoss Concatenating data frames in R versus SAS Aug 24