I have a dataset with five variables I would like to use to display the data on a graph. The data is grouped by the first variable (p) and sub-grouped by the second variable (i) along the x-axis. The fourth variable (nor) determines the height of the point along the y-axis. The fifth variable (mnor) is the mean of the nor values for each subgroup.   I want to replace the circle with a unique symbol determined by the third variable (date), so that the graph is easier to interpret the results from different days the data was collected. I have been able to replace the point with the date but would prefer a symbol to minimize clutter. I've included a sample code below. The first graph is my original graph without including the date variable, and the second graph is replacing the points with the date value.   data samp; input p$ i date: date9. nor mnor; format date date9.; datalines; A 0 16May2024 1.230 1.000 A 0 23May2024 0.770 1.000 A 1 16May2024 0.014 0.021 A 1 23May2024 0.028 0.021 B 0 16May2024 1.576 1.504 B 0 23May2024 1.432 1.504 B 1 16May2024 0.064 0.071 B 1 23May2024 0.078 0.071 C 0 16May2024 0.432 0.510 C 0 23May2024 0.588 0.510 C 1 16May2024 0.011 0.009 C 1 23May2024 0.007 0.009 ; title "Example Graph 1"; proc sgplot data = samp noborder; scatter x = p y = nor / markerattrs = (symbol=CircleFilled) group = i groupdisplay = cluster; highlow x = p low = mnor high = mnor / nofill type = bar barwidth = 0.4 group = i groupdisplay = cluster; xaxis type = discrete labelattrs = (size = 9) display = (nolabel); yaxis labelattrs = (size = 9) display = (nolabel) grid; run; title "Example Graph 2"; proc sgplot data = samp noborder; scatter x = p y = nor / markercharattrs = (weight = bold) markerchar = date group = i groupdisplay = cluster; highlow x = p low = mnor high = mnor / nofill type = bar barwidth = 0.4 group = i groupdisplay = cluster; xaxis type = discrete labelattrs = (size = 9) display = (nolabel); yaxis labelattrs = (size = 9) display = (nolabel) grid; run; ... View more

I ran a dataset through proc freq and noticed I had missing values when I didn't expect any. Is there a way to output those values or print them so that I can determine what the issue might be? ... View more

I have a csv file where one of the variables is entered inconsistently in terms of capital and lower-case lettering (e.g. Married, married, MARRIED, ect.). I'm wanting to format the observations to be a single-letter value (e.g. M) for all case variants without including all variants in my code. Is there a way to tell SAS to ignore case sensitivity and focus on just the spelling when formatting the data? Open to work around as well. ... View more