Does any one how to merge three FIA data (COND, PLOTSNAP, and TREE files) in one single file?
I realized i needed to provide more detail information. From FIA Datamart, we can manually download three csv files name (COND, PLOTSNAP, and TREE). These three large dataset have common variables that can be used to merge all three data into one. I have done this in SAS 9.3, and works great. BUT i am trying to use R to do similar work. Below i have provided SAS code that i used for merging. I would appreciate if you could help me converting SAS code into R.
In code below: T mean TREE, C means COND, and PS means PLOTSNAP csv file.
PROC SQL NOPRINT;
CREATE TABLE ALL AS
T. CN AS T_CN,
C. CN AS C_CN,
PS. CN AS PS_CN,
FROM PLOTSNAP PS, COND C, TREE T
/ AND C.COND_STATUS_CD IN (1,2,3) */
How do I do this in R?