Housing Prices in New York-Newark-Jersey City as of November 2018










 

%Let Rank=1;
%Let MSA=New York-Newark-Jersey City, NY-NJ-PA;

PROC SQL;
CREATE TABLE WORK.QUERY
AS
SELECT * FROM ECON.HOUSING_HIST
WHERE
( HOUSING_HIST.Nielsen_Rank = &Rank )

ORDER BY 1 ASC;
QUIT;

proc means data=WORK.QUERY chartype mean sum vardef=df;
var Median_Listing_Price Median_Listing_Price_M_M Median_Listing_Price_Y_Y
Active_Listing_Count Active_Listing_Count_M_M Active_Listing_Count_Y_Y
Days_on_Market Days_on_Market_M_M Days_on_Market_Y_Y New_Listing_Count
New_Listing_Count_M_M New_Listing_Count_Y_Y Price_Increase_Count
Price_Increase_Count_M_M Price_Increase_Count_Y_Y Price_Decrease_Count
Price_Decrease_Count_M_M Price_Decrease_Count_Y_Y Pending_Listing_Count
Pending_Listing_Count_M_M Pending_Listing_Count_Y_Y Avg_Listing_Price
Avg_Listing_Price_M_M Avg_Listing_Price_Y_Y Total_Listing_Count
Total_Listing_Count_M_M Total_Listing_Count_Y_Y Pending_Ratio
Pending_Ratio_M_M Pending_Ratio_Y_Y;
class YY;
output out=WORK.Means_stats mean=sum= / autoname;
run;

ods graphics / reset width=6.4in height=4.8in imagemap;
proc sgplot data=WORK.MEANS_STATS;
title height=10pt &MSA;
footnote2 justify=left height=10pt “Source: National Realtor Association”;
vbar YY / response=Median_Listing_Price_Mean fillattrs=(color=Greeen
transparency=0.25) datalabel;
yaxis grid;
run;

proc sgplot data=ECON.HOUSING_HIST;
Where NIELSEN_RANK=&Rank;
vline Month / response=Median_Listing_Price_Y_Y;
yaxis grid;
run;

proc sgplot data=WORK.MEANS_STATS;
title height=10pt &MSA;
footnote2 justify=left height=10pt “Source: National Realtor Association”;
vbar YY / response=Median_Listing_Price_M_M_Sum fillattrs=(color=CX3177e0
transparency=0.25) datalabel;
yaxis grid;
run;
proc sgplot data=WORK.MEANS_STATS;
title height=10pt &MSA;
footnote2 justify=left height=10pt “Source: National Realtor Association”;
vbar YY / response=Avg_Listing_Price_Mean fillattrs=(color=Greeen
transparency=0.25) datalabel;
yaxis grid;
run;

proc sgplot data=WORK.MEANS_STATS;
title height=10pt &MSA;
footnote2 justify=left height=10pt “Source: National Realtor Association”;
vbar YY / response=Avg_Listing_Price_M_M_Sum fillattrs=(color=CX3177e0
transparency=0.25) datalabel;
yaxis grid;
run;
proc sgplot data=WORK.MEANS_STATS;
title height=10pt &MSA;
footnote2 justify=left height=10pt “Source: National Realtor Association”;
vbar YY / response=Total_Listing_Count_Mean fillattrs=(color=blue
transparency=0.25) datalabel;
yaxis grid;
run;
proc sgplot data=ECON.HOUSING_HIST;
title height=10pt &MSA;
Where NIELSEN_RANK=&Rank;
vline Month / response=Total_Listing_Count_Y_Y;
yaxis grid;
run;
proc sgplot data=WORK.MEANS_STATS;
title height=10pt &MSA;
footnote2 justify=left height=10pt “Source: National Realtor Association”;
vbar YY / response=Days_on_Market_Mean fillattrs=(color=red
transparency=0.25) datalabel;
yaxis grid;
run;
proc sgplot data=ECON.HOUSING_HIST;
title height=10pt &MSA;
Where NIELSEN_RANK=&Rank;
vline Month / response=Days_on_Market_Y_Y;
yaxis grid;
run;
ods graphics / reset;
title;
footnote2;