proc mddb data=sashelp.prdsale out=sasuser.testmddb; class product / ascending; class prodtype /descending; class country / ascformatted; class year quarter / desformatted; class month / dsorder; hierarchy country / name = "geo+" display = yes; hierarchy year month quarter / name = "time+" display = yes; hierarchy prodtype product / name = "prodtype+" display = yes; var actual / n sum nmiss; var predict / n sum nmiss uss min max; run;