Or use a version control system (SVN, GIT etc.), e.g. save the tool in your tools area, then version control external that code to your local project. ... View more

How about (and yes, you are limited to 10 titles, though with split char/rtf codes etc. you can make more): data have;   attrib Name DOB Disease Classification status MMR1 TDate MMR2 Date PCR result Serology result format=$20.;   infile datalines delimiter=',' missover;   input Name $ DOB $ Disease $ Classification $ status $ MMR1 $ TDate $ MMR2 $ Date $ PCR $ result $ Serology $ result; datalines; John Doe,10/25/1986,Measles,Skin,Confirmed,10/25/1987,10/25/1994,Positive,Positive,01/01/2013,AAA,1234,Positive,112233 John Doe,10/25/1986,Measles,Skin,Confirmed,10/25/1987,10/25/1994,Positive,Negative,02/01/2013,ABA,44234,Positive,445566 ; run; proc sql;   create table LOOP as   select  distinct            NAME,           DOB,           DISEASE,           CLASSIFICATION,           STATUS,           MMR1   from    WORK.HAVE; quit; ods _all_ close; ods pdf file="s:\temp\rob\test.pdf" style=statistical; data _null_;   set loop;   call execute('title1 j=l "Name: '||strip(name)||'";                 title2 j=l "DOB: '||strip(dob)||'";                 title3 j=l "Disease: '||strip(disease)||'";                 title4 j=l "Classification: '||strip(classification)||'";                 title5 j=l "Status: '||strip(status)||'";                 title6 j=l "MMR1: '||strip(mmr1)||'";');   call execute('proc print data=have (where=(name="'||strip(name)||'")) noobs;                   var tdate mmr2 date pcr result serology;                 run;'); run; ods _all_ close; ... View more

Well, that template inherits from Factoid, then from common Factoid.  When I look at that template in sashelp.tmplcommon, it has its own subdirectories with value and label, code for value is: proc template;                                                                   define column Common.Column.Factoid.Value / store = SASHELP.TMPLCOMMON;          notes "Default Factoid value column";                                         dynamic value_just wmin wmax;                                                 width_max = wmax;                                                             width = wmin;                                                                 just = value_just;                                                         end;                                                                       run;                                                                          So I am thinking that you want to change width_max or width.  Never used this one myself though. ... View more

Well the below will give you the result.  However I am thinking your going to come up with problems.  For instance if you have Dec/Jan/Feb, without knowing the year then you can't say they are sequential, and they wouldn't work with my scenario.  What I would suggest is to create a variable - of type DDMMMYYYY - with the month given and the year.  Then default in 01 say, it doesn't matter as we wont use that.  Then use the INTCK function with months option. Anyways and SQL soloution: Data test;      Input customer_id Month $ Month_num Product $ ;      Datalines; 101 Jan 1 Cream 101 Dec 12 Powder 102 Feb 2 Cream 102 Mar 3 Paste 102 Apr 4 Brush 103 Sep 9 Cream 103 Jan 1 Paste 103 Nov 11 Cloth 104 Feb 2 Cream 104 Mar 3 Paste 104 May 5 Cloth 104 Apr 4 Brush ; Run; proc sql;   create table WANT as   select  distinct A.CUSTOMER_ID   from    TEST A   where   exists(select distinct THIS.CUSTOMER_ID from TEST THIS where THIS.CUSTOMER_ID=A.CUSTOMER_ID and THIS.MONTH_NUM=A.MONTH_NUM+1)     and   exists(select distinct THIS.CUSTOMER_ID from TEST THIS where THIS.CUSTOMER_ID=A.CUSTOMER_ID and THIS.MONTH_NUM=A.MONTH_NUM+2); quit; ... View more

For a cell in an export xls file to have a return you would need to embed the character for it.  In the same way as you would embed RTF code directly into text to get layout functionality.  I doubt also that proc export would be sufficient for that task.  I would suggest moving to ods tagsets.excelxp.   I couldn't see the split char at a quick glance and am leaving now. ... View more

Well, if its simply checking each column for a value and assigning a result then try (it generates a dataset with 100 if statements - I have assumed your value is 99): data _null_;   call execute('data want;                   set have;                   attrib result format=best.;                   result=0');   do i=1 to 100;     call execute('if ops_ko'||put(i,1.)||'=99 then result=1;');   end;   call execute('run;'); run; ... View more

Best to post your code and example of what data you have and what you would like it to look like. ... View more

Are you using SQL server?: http://support.microsoft.com/kb/273813 ... View more

Perhaps: ods graphics / reset=all height=13cm width=22cm; Adjusting the height and width should adjust the graphic, so if your titles/footnotes are outside that then they can be bigger. ... View more