proc sql noprint; create table test as select a.*, b.one from dat1 as a left join dat2 as b on a.id eq b.id and ((a.date1 eq b.date1) or (b.date1 <= a.date1 <= b.date2)) quit;     How do I write this using merge statement ?   I was able to write the below, but how do I add the condition (b.date1 <= a.date1 <= b.date2)) ?   data test; merge dat1(in=a) dat2(in=b); by id date1; if a; run;     Thanks for your help ... View more

How do I convert DATE9. format to ISO8601 date format ?   I need to convert the 10JAN2011 to 2011-01-10.   Is there a way to do this ? ... View more

Hi,   I need to display x-axis values with in the vertical axis. I used sgplot to generate the followinf figure. The values Fiscal 1 and  Fiscal 6 are going beyond the vertical axis (or out of the vertical bounds) which I don't want. How can I fix this?    I tried Thresholdmax and Thresholdmin options but with no luck. Is there any other way ? Please help   This is what I am getting       This is what I need   ... View more

Hi,   I need to calculate average of values for each group and create a new record in the same dataset with value as 'Average' in new variable.    This is what I have:   GROUP           VALUE                TYPE --------           ------------            -----------   1                     11    1                     11.5   1                     12.5   2                      14   2                      12   2                      13   This is what I need:   GROUP             VALUE               TYPE --------           ------------            -----------   1                     11    1                     11.50   1                     12.50   1                     11.66              Average   2                     14   2                     12   2                     12   2                     12.66              Average     Can someone please teach me what is the best way to do it ?   Thanks much !   ... View more

I am trying to convert character dates to numeric date9. format.    Some of the dates has only year, some has year-month, some has year-month-date as shown below   Chardate ----------- 2010-12-15 2010-10-04 2010-05 2011 2010-02-23 2011-04   numdate= input(chardate,yymmdd10.); format numdate date9.;   If I use the above input function it is throwing error :  Invalid argument to function INPUT at line ...   Is there any other way to do this ?     Thanks   ... View more

I have 4 treatment groups to be displayed in the graph. I need different linestyles (solid, dashed, etc ..) for each treatment group.  With the below code which I have written, I'm getting same linestyle for all 4.   How to use the linestyle option in sgplot ? Please enlighten me. I am a beginner. Thanks proc sgplot data = final noautolegend; xaxis label = 'Week'; yaxis label = 'Blood Pressure (mmHg)'; series x = visitname y = mean / group = trtp lineattrs = (pattern = 1) markers; keylegend/ title = 'Treatment '; scatter x = visitname y = mean / group = trtp yerrorlower = lower yerrorupper = upper ; run;     Thankyou ... View more