I am trying to run a time series plot with multiple lines, but I can't figure out how to group the lines into colors.  Currently, I am getting a line for each LESID, which in turn produces a different line of a different color and pattern.  I still want a line for each LESID, but I just want 2 different line types:  a solid blue where POSNEG=Positive and a solid red where POSNEG=Negative.  The final graph should show 3 red lines and 7 blue lines.  Is it possible to make that change?  I have tried playing with the GROUP= option in the SERIES statement, but that just messes things up. data lesions;       input LESID POSNEG $ PCTCHG WEEKS;       informat pctchg percent9.1;       format pctchg percent9.1;       cards; 1     Negative    0.0%  0.0 1     Negative    0.0%  7.4 1     Negative    -3.9% 15.1 1     Negative    -19.2%      24.0 1     Negative    -19.2%      31.4 1     Negative    -26.9%      39.4 1     Negative    -26.9%      48.4 1     Negative    -19.2%      54.4 2     Positive    0.0%  0.0 2     Positive    0.0%  7.4 2     Positive    1.2%  15.4 2     Positive    3.7%  24.1 2     Positive    -12.4%      31.4 2     Positive    -14.8%      41.1 2     Positive    -23.5%      48.4 2     Positive    -23.5%      55.4 3     Positive    0.0%  0.0 3     Positive    -2.9% 7.4 3     Positive    -4.3% 15.4 3     Positive    1.4%  24.1 3     Positive    1.4%  31.4 3     Positive    1.4%  41.1 3     Positive    -54.3%      48.4 3     Positive    -1.4% 55.4 4     Positive    0.0%  0.0 4     Positive    8.3%  7.4 4     Positive    -16.7%      15.4 4     Positive    -8.3% 24.1 4     Positive    -8.3% 31.4 4     Positive    -8.3% 41.1 4     Positive    8.3%  48.4 4     Positive    8.3%  55.4 5     Positive    0.0%  0.0 5     Positive    3.0%  7.4 5     Positive    -3.0% 15.4 5     Positive    9.1%  24.1 5     Positive    3.0%  31.4 5     Positive    15.2% 41.1 5     Positive    9.1%  48.4 5     Positive    3.0%  55.4 6     Positive    0.0%  0.0 6     Positive    -25.0%      4.1 7     Negative    0.0%  0.0 7     Negative    -5.9% 4.1 8     Positive    0.0%  0.0 8     Positive    -11.1%      4.1 9     Positive    0.0%  0.0 9     Positive    -24.0%      4.1 10    Negative    0.0%  0.0 10    Negative    5.6%  7.3 10    Negative    0.0%  13.3 ; run; goptions reset=all; proc sgplot data=lesions;       series x=weeks y=pctchg / group=lesid;       refline 0.20 -0.30 / lineattrs=(pattern=2);       xaxis label='Time on Study (weeks)' values=(0 to 60 by 6);       yaxis grid label='Percent Change from Baseline' values=(-1 to 0.6 by 0.2); run; quit; ... View more

I don't know if this is even possible, but I'm just going to throw this question out there. I was wondering if SAS has the ability to create folders?  For example, suppose I automatically run code every week that generates a host of output files.  Suppose I output them in C:\SAS\Reports, but I want to have a new subfolder with the date each time the reports are generated so that this week they are output to C:\SAS\Reports\2015-02-20 and next week they are output to C:\SAS\Reports\2015-02-27, and so on.  This way, I don't have to manually create a new folder each time and move all the files from one place to another. Is this possible? ... View more

Sorry for the vague title.  I couldn't think of a way to summarize my task. I have a dataset that has a subject ID with a date that they came on the study (in MONYY7. format) and the number of months that they were on the study.  I want to create a long, vertical table that has one entry for every month they were on study.  I cannot picture an "easy" method to do this.  I can only imagine storing macro variables with distinct subject IDs and number of months then looping through all subjects and number of months.  I have 321 subjects, and the months go up to 21, so looping just doesn't seem as efficient as I would like.  Are there any ideas?  I was wondering if PROC TRANSPOSE would have such capabilities.tend a D Example Dataset: SUBJECT ORIGIN MONTHS 001 JAN2012 1 002 MAR2012 4 003 APR2012 3 004 SEP2012 9 Example Outcome: SUBJECT MONTH 001 JAN2012 002 MAR2012 002 APR2012 002 MAY2012 002 JUN2012 003 APR2012 003 MAY2012 003 JUN2012 004 SEP2012 004 OCT2012 004 NOV2012 004 DEC2012 004 JAN2013 004 FEB2013 004 MAR2013 004 APR2013 004 MAY2013 ... View more

I am trying to find a way to add unicode symbols in report pretext, specifically the ≥ symbol.  I am able to use superscripts in the text and make a footnote that uses the unicode symbols, but I can't figure out how to get it into the title.  Below are both examples (unicode atempt in a title and unicode in a footnote).  Can someone let me know if it is possible to use unicode in the pretext option?  I have heard people suggest copying the symbol from a Word document into my SAS code, but that doesn't work.  It may display in the code, but the output is just an equal (=) sign. proc template;    define style Styles.journal_noprehtml;       parent = styles.Journal;    style table from table / prehtml=''; /* Eliminate the 17 underscores after the report pretext */    end; run; options formchar="|____|+|___+=|_/\<>*" pageno=1 nonumber nodate orientation=portrait center; /***  Unicode in the title is not displaying correctly  ***/ ods listing close; ods rtf file="C:\Class_Unicode.rtf" style=journal_noprehtml; ods escapechar='~'; proc report data=sashelp.class nowindows style(report)={font=('Arial',9.5pt,bold italic) pretext="List of Students Weighing {\unicode 2265}100 Pounds"};       where weight>=100; run; ods rtf close; ods listing; /***  I can superscript the title and use the unicode in a footnote  ***/ ods listing close; ods rtf file="C:\Class_Superscript.rtf" style=journal_noprehtml; ods escapechar='~'; proc report data=sashelp.class nowindows style(report)={font=('Arial',9.5pt,bold italic) pretext="List of Students{\super 1}"};       where weight>=100; run; ods rtf text="~S={leftmargin=35% rightmargin=35% just=l font=('Arial', 9pt)}~{super 1} Only students weighing ~{unicode 2265}100 pounds are displayed."; ods rtf close; ods listing; ... View more

I have several macro variables that represent a numeric value.  I understand that macro variables are character strings, so I can't format them as I could a number.  I want the variables to display to 1 decimal point, but there are some that only an integer.  For example, I want the value "1" to display as "1.0".  I am trying to add the string ".0" to any variable that represents an integer.  The code below does not work.  It likes to remove the decimal and display "10" instead of "1.0".  Any ideas on how to retain the decimal point? %let zerodec=%quote(.0); %put ~~~&zerodec.~~~; %let dose1=1; %let dose1=%sysfunc(cat(&dose1.,%quote(&zerodec.))); %put ~~~&dose1.~~~; ... View more

I am having a hard time getting through a macro IF-THEN statement.  I have the following code that does not seem to be working: %if %str(&protocol.)=%str(EC-FV-04) | %str(&protocol.)=%str(EC-FV-06) %then %do; ... %end; I am getting the error: "A character operand was found in the %EVAL function or %IF condition where a numeric operand is required."  I am assuming that the hyphens are telling SAS to do a mathematical subtraction, which it cannot do with characters (nor do I want it to do so).  I have tried various ways to run the comparison, but I am not having much luck. As a side note, is it possible to use the "in" operator in a macro?  I would like to be able to state: %if %str(&protocol.) in (%str(EC-FV-04),%str(EC-FV-06)) %then %do; ... %end; Here is my full code, if it will help: %macro CTSCHEDULE (protocol=%str(),drugstartdt=);       %let drugstartdt=%sysfunc(upcase(&drugstartdt.));       %put &drugstartdt.;       data _null_;             position=prxmatch("/\d\d[A-Z][A-Z][A-Z]\d{4}/","&drugstartdt.");             call symputx('position',position);       run;       %if %length(&drugstartdt.)^=9 %then %do;             %put ERROR: Incorrect Length.  DRUGSTARTDT must be in the form DDMMMYYYY.;             %return;       %end;       %if &position.^=1 %then %do;             %put ERROR: Incorrect Format.  DRUGSTARTDT must be in the form DDMMMYYYY.;             %return;       %end;       data schedule;             do CYCLE=1 to 30;                   do CYCLEWEEK=1 to 4;                         output;                   end;                    end;       run;       data schedule;             set schedule;             EVENT='C' || compress(put(cycle,best.)) || 'W' || compress(put(cycleweek,best.));             STUDYWEEK=_n_;             CTDT="&drugstartdt."d + (studyweek-1)*7;             format ctdt date9.;       run;       data ctschedule;             set schedule;             %if %str(&protocol.)=%str(EC-FV-04) | %str(&protocol.)=%str(EC-FV-06) %then %do;                   if studyweek<=24 & mod(studyweek,6)=0 then CT=1;                         else if studyweek>24 & mod(studyweek,8)=0 then CT=1;             %end;             %if %str(&protocol.)=%str(EC-FV-07) %then %do;                   if mod(studyweek,6)=0 then CT=1;             %end;             MINDT=ctdt-4;             MAXDT=ctdt+4;             format mindt maxdt date9.;             if CT=1;             drop CT;       run; %mend CTSCHEDULE; %ctschedule(protocol=%str(EC-FV-04),drugstartdt=06JAN2014); ... View more

I have data that has a character field with many vial numbers per patient.  I want to split it out into an individual observation per subject for each vial. For example, my data might look like this: data subjects;   length subject $3 vials $33;   input subject $ vials $;   cards; S01 10509,10511,10512 S02 09631,09636,09639,09640,09641 S03 11978,12059 ; run; I want to get it into this form: Subject Vial S01 10509 S01 10511 S01 10512 S02 09631 S02 09636 S02 09639 S02 09340 S02 09641 S03 11978 S03 12059 ... View more

I am trying to find a way to find the corresponding date to a summary value (like the minimum or maximum). For example, refer to the data below.  I want to find the date that matches the minimum value.  So, Subject 001 has a minimum value of 179, which occurs on 26MAR2013 (I want to keep the first time the minimum occurs).  Subject 002 has a minimum of 116 on 06JAN2013; Subject 003 has a minimum of 73 on 19AUG2013; and Subject 004 has a minimum of 107 on 24JUL2013.  I am sure that SQL can do this easily, but I can't find a way.  My current method is to use SQL to find the minimum value per patient.  Then I merge the original data with the minimum data on subject and value.  If they match, then I keep the record.  In the case that there is more than one date that matches the minimum (like Subject 001), then I sort the data again and keep the first record.  (See my code below).  Is there a simpler way to do this? data test;       input subj $ date value;       informat date date9.;       format date date9.;       cards; 001         01JAN2013   190 001         12FEB2013   184 001         26MAR2013   179 001         07MAY2013   179 002         06JAN2013   116 002         17FEB2013   123 002         31MAR2013   120 003         15APR2013   89 003         27MAY2013   76 003         08JUL2013   75 003         19AUG2013   73 004         20MAR2013   109 004         01MAY2013   112 004         12JUN2013   115 004         24JUL2013   107 004         04SEP2013   109 ; run; This is my current method: proc sql;       create table min as       select distinct subj, min(value) as value       from test       group by subj; quit; proc sort data=test;       by subj value; run; data test_min;       merge test min (in=in_min);       by subj value;       if in_min; run; proc sort data=test_min;       by subj date; run; data test_min;       set test_min;       by subj date;       if first.subj; run; ... View more