How can I force proc import to create all character variables in the output dataset from the Excel workbook? I can also get a csv version if that makes it easier.   The spreadsheet I'm working with has several hundred columns and most have numeric values, but in some, dashes exist.  ... View more

I have a series plot with error bars (series + highlow) where I had to add or subtract from the x axis values to separate the points. When I added the xaxis table to the plot, those values are also offset (I do not want this). I introduced a second hidden series plot using an X2 axis with the original values and tied the xaxis table to the X2 axis, but it didn't work. What am I missing?   Current code with the second series plot as described above:   proc sgplot data=stats2 dattrmap=myattrmap ; where param = "&&param&i"; highlow x=month low=llim high=ulim / group=eyefl attrid=eyefl highcap=serif lowcap=serif lineattrs = (thickness = 2) ; series x = month2 y = mean/lineattrs=(thickness = 0) markerattrs = (size = 0); series x=month y=mean/LINEATTRS= (THICKNESS= 2 ) group = EYEFL markers markerattrs = (size =7pt) grouporder = data name = 'Key' attrid = eyefl ; series x = month2 y = mean/ name = 'Key 2' lineattrs = (thickness = 0) markerattrs = (size = 0pt); yaxis values = (-10 to 10 by 1) grid valueattrs = (size = 7pt) labelattrs = (size = 7pt) label = 'Change from Baseline (dB)'; xaxis values = (0 to 3 by 1) offsetmin = 0.03 offsetmax = 0.03 valueattrs = (size = 7pt) labelattrs = (size = 7pt) label = 'Month'; Keylegend 'Key' /VALUEATTRS=(size=7pt family = 'Courier New') across = 6; xaxistable n/class = eyefl valueattrs = (size = 7pt) labelattrs = (size = 7pt) labelpos = left x2axis x = month2; run; ... View more

I am using the following code to create a clustered bar chart. The values are pre-summarized from MEANS using preloaded formats for a complete dataset.   On the X axis, Day should appear but then also an analysis category (formatted numeric value) should also appear (it does not, only Day appears). Also, no legend appears either. When I remove the keylegend line, a legend appears on the right, but it is not correct. What am I missing?         proc sgplot data=xxx; vbar day / response = n groupdisplay = cluster stat = sum group=CATEGORY colorresponse=avalca1n colormodel = (green gold red black lightblue grey darkblue darkred)transparency=0.2 datalabel DATALABELATTRS = (size = 7pt family = "Courier New") ; xaxis values = (0 ,30,90) labelattrs = GraphUnicodeText label = 'Day (Baseline Set to Day 0)' labelattrs = (size = 7pt family = "Courier New" ) valueattrs = (size = 7pt family = "Courier New"); yaxis values = (0 to 9 by 1) labelattrs = GraphUnicodeText label = 'n' grid labelattrs = (size = 7pt family = "Courier New" ) valueattrs = (size = 7pt family = "Courier New"); keylegend / valueattrs = GraphUnicodeText type=fillcolor title="" valueattrs = (size = 7pt family = "Courier New") sortorder = ascending; run;           ... View more