Hi there,   I wonder if I can use %do_over or any other loop function to write the following code? by the way, the values in () are options following "pattern=" in proc sgplot %drawplot(dot); %drawplot(solid); %drawplot(dash); %drawplot(longdash);   Thanks!   ... View more

Hi SAS community!   I have a question about generating different color combinations for the sgplot. I know it might sound silly but it could really help me a lot!   The task is like that: proc sgplot data= test; series y=year x=banana / lineattrs=(color=Red pattern=dot) markerattrs=(color=Red symbol=circlefilled); series y=year x=strawberry / lineattrs=(color=black pattern=dot) markerattrs=(color=black symbol=circlefilled); series y=year x=grape / lineattrs=(color=blue pattern=dot) markerattrs=(color=blue symbol=circlefilled); title "production of fruit by year"; run; The plot draws several series of lines, and I JUST want to test for the color of banana line first, with color of red, then green , then blue, etc.etc, as well as the patterns... I've tried %array and % do_over but cannot make it work...     Thanks a lot!   ... View more

Hi there,   I have a wide form of longitudinal dataset recording scores of multiple times like this   ID Group   Time0 Time1 Time4 Time9 Time15 Time24 Time37 (...)   1  A           10        15        17        9          8            29         9 2  A            21       39        32        .           33          31         23 (...)   and I'm using array to convert this dataset to convert this dataset to the long form, like that   ID Group Time Score 1   A         0       10 1   A         1        15 (...)   Since there are lots of Timepoints in the wide data, and the numbers are irregular, I have to write a ton of "if...else" following the array, just to change values of variable "Time" in the new dataset.  I wonder if Is there any way to just extract the number following the variable Time0 Time4... and put it as the value in the new Time variable?   Thanks so much!   Joe ... View more

Hi there,   I'm trying to read data from a table that has multiple 'dimensions'. At first, it is just a 3 way table like this:                           smoker    nonsmoker male     white       10           20             others      20           30 female  white       30           40              others      30           30   and I just write: input gender race smoker count; cards; 1 1 1 10 1 1 2 20 ... however when the table becomes bigger and bigger and having more variables the task becomes quite hard (like the table in the attachment), and I'm wondering if there are any easier way to input data like that? ... View more