I'm trying to merge to data sets into Energy Usage then run a proc reg by state after that. And the code comes back with the Energy Usage table empty and the proc reg failed. Any help would be appreciated! (Repost from a wrong section) libname Connor 'F:\Connor SAS\Final Project Econometrics';
data Connor.EnergyTransIncome;
set Connor.EnergyTransIncome; keep State Year Pop PopDens PetBarrels PetBarrelsPC LaneMiles StateGDPPerCapita;
run;
data Connor.Tax;
set Connor.Tax; keep State Gasoline Diesel;
run;
proc sort data= Connor.EnergyTransIncome; out=Connor.EnergyTransIncome_sort;
by State;
run;
proc print data=EnergyTransIncome_sort; run;
proc sort data= Connor.Tax; out=Connor.Tax_sort;
by State;
run;
proc print data= Connor.Tax_sort; run;
data Connor.EnergyUsage;
merge EnergyTransIncome Gastax;
by State;
run;
proc reg data=Connor.EnergyUsage;
model State= Year Pop PopDens LaneMiles StateGDPPerCapita;
run;
... View more