pcp.sas

libname mydata 'C:\Users\PhotonUser\My Files\Temporary Files';

proc import datafile="C:\Users\PhotonUser\My Files\Temporary Files\pcp_mean-2010_2014-all_counties.csv"
out=mydata.pcp dbms=CSV; 
run;

proc import datafile="C:\Users\PhotonUser\My Files\Temporary Files\farmers.csv"
out=mydata.farmers dbms=CSV;
run;

proc sort data=mydata.pcp;
by state county;
run;

proc sort data=mydata.farmers;
by state county;
run;

data mydata.merged;
merge mydata.farmers(in=a keep=State County farmer_id) mydata.pcp(in=b keep=State County pcp__2010_2014_mean_);
by state county;
if a and b;
run;