Hi SAS experts,   Am trying to control the hights of bar graph.How can I controll the hights of bar graph..Below is my code..please help   axis1 label=none major=none minor=none style=0 value=none; axis2 label=none; legend1 label=(position=top) position=(right middle) across=1 shape=bar(.11in,.11in); pattern1 v=solid color=CXB22222; pattern2 v=solid color=CXFF00FF; pattern3 v=solid color=CXB8860B; /*pattern4 v=solid color=CX8B4513;*/ /*pattern5 v=solid color=CX556B2F;*/ /*pattern6 v=solid color=CX6495ED;*/ /*pattern7 v=solid color=CX4169E1;*/ ods pdf file="path&name..pdf"; proc gchart data=test&name.; vbar3d YEAR / discrete sumvar=sales shape=cylinder subgroup=type cframe=grayaa caxis=black width=10 space=4 legend=legend1 maxis=axis2 raxis=axis1 des="total sales for &name."; run; quit; ods pdf close; ... View more

Hi SAS Experts,   Am trying to create two macro variables one for Year  one for Product in sashelp.prdsal2 dataset. When am substituting both the macro variable, the variables are resolving but the am unable to get the corresponding data. Below is my code... Please guide me about my mistake %LET YR=1995; %LET PD='SOFA'; PROC SQL; CREATE TABLE NEW AS SELECT DISTINCT PRODUCT,SUM(ACTUAL) AS TOTAL,STATE FROM SASHELP.PRDSAL2 WHERE YEAR=&YR. AND PRODUCT="&PD" GROUP BY STATE; QUIT; /*By using the above code am not getting any data and there is no error*/   PROC SQL; CREATE TABLE NEW1 AS SELECT DISTINCT PRODUCT,SUM(ACTUAL) AS TOTAL,STATE FROM SASHELP.PRDSAL2 WHERE YEAR=1995. AND PRODUCT="SOFA" GROUP BY STATE; QUIT; /*without using the macro variable am getting the information*/ ... View more