Hello, I'm having trouble getting my color graphs to appear in addition to charts. This is what I have so far 1. PROC IMPORT OUT=salesByProductByDate DATAFILE= "/home/emilymoore20/EPG194/output/myTestFolder/BSA570v4_Week3_assignment_data.xlsx" 2. DBMS=xlsx REPLACE; 3. GETNAMES=YES; 4. RUN; 5. 6. DATA salesByProductByDate; 7. SET salesByProductByDate; 8. year = YEAR(date); 9. month = YEAR(date); 10. RUN; 11. 12. PROC REPORT DATA=salesByProductByDate NOWD; 13. COLUMN ('Sales' year month) product,(sales); 14. DEFINE year / GROUP STYLE (header)={background=lightgreen}; 15. DEFINE month / GROUP STYLE (header)={background=lightgreen}; 16. DEFINE product / ACROSS ' ' STYLE(header)={background=lightyellow}; 17. DEFINE sales / SUM STYLE(header)={background=lightyellow} FORMAT=DOLLAR15.2; 18. BREAK AFTER year /SUMMARIZE DOL DUL; 19. RBREAK AFTER/SUMMARIZE; 20. COMPUTE AFTER year; 21. CALL DEFINE('year','style','style=Header{pretext="SubTotal " tagattr="Type:String"}'); 22. ENDCOMP; 23. COMPUTE AFTER; 24. CALL DEFINE('year','style','style=Header{pretext="Grand Total " tagattr="Type:String"}'); 25. ENDCOMP; 26. RUN 27. 28. TITLE '2015 Sales By Product'; 29. PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2015)); 30. VBAR product / RESPONSE=sales CATEGORYORDER=respasc GROUP=month 31.GROUPDISPLAY=cluster 32. STAT=sum DATASKIN=gloss; 33. XAXIS DISPLAY=(nolabel noticks); 34.YAXIS GRID; 35. RUN; etc 36. TITLE '2016 Sales By Product'; 37. PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2016)); 38. VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster 39. STAT=sum DATASKIN=gloss; 40. XAXIS DISPLAY=(nolabel noticks); 41. YAXIS GRID; 42. RUN;
... View more