Howdy, I work at a data company and pull data all day :-). Some of our tables are large and the initial data pull can take a while. Is there a more efficient way than PROC SQL? Here is a typical data pull. Jeff PROC SQL;
CREATE TABLE WORK.TECH_01 AS
SELECT t1.industrysegment AS ProdLvl_1,
t1.categorygroup AS ProdLvl_2,
t1.category AS ProdLvl_3,
t1.subcategory AS ProdLvl_4,
t1.itemnumberunsuppressed AS iItem_uns,
t1.outletfamily,
t1.outlet_storeid,
t1.ppmonth,
t1.ppweek,
/* Dollars */
(SUM(t1.totalvalue)) AS Dollars,
/* Units */
(SUM(t1.unitssold)) AS Units
FROM TECSWP2.vw_tecmlwk_fact_nc_uns t1
WHERE t1.subcategory IN
(
60638,
60640
) AND t1.totalvalue >= 1 AND t1.unitssold >= 1 AND t1.ppmonth BETWEEN &Month-23 and &Month
GROUP BY t1.industrysegment,
t1.categorygroup,
t1.category,
t1.subcategory,
t1.itemnumberunsuppressed,
t1.outletfamily,
t1.outlet_storeid,
t1.ppmonth,
t1.ppweek;
QUIT;
... View more
