Did you try quoting the filename?    open(quote(trim(mail_file)),..... Otherwise you will need to create a libref pointing the directory and then try to open the file using the traditional libname.member two level dataset name format. fname=scan(mail_file,-1,'/\'); dir=substr(mail_file,1,length(mail_file)-length(fname)); member=scan(fname,1,'.'); libref='MYDATA'; rc=libname(libref,dir,,'access=readonly'); ** test for error codes ?? ; rc=open('MYDATA.'||member,.....) ... ... View more

I know nothing about Web Report Studio, but if you are using PROC REPORT then it has a "friendly" feature of sorting even numeric variables by the character string used to display then unless you tell it otherwise by using ORDER=INTERNAL option in addtion to the ORDER option. define mydate / order order=internal; ... View more

Now if you want to also order by the date then you will need to first give it real dates and then copy the start and end dates to another variable that you can use to order. data one;   format serial 5. date start date9.;   input serial start date9. ;   date=start; cards; 101 01jan2008 101 01feb2008 101 01mar2008 102 01feb2007 102 01mar2007 102 01apr2007 run; data two ;   format serial 5. date end date9.;   input serial end date9.;   date=end; cards; 101 01jul2007 101 01aug2007 101 01sep2007 102 01may2008 102 01jun2008 102 01jul2008 run; data both ;   set one two;   by serial date ; run; options nocenter nodate nonumber linesize=50; proc print width=min; run; Obs    serial      date           start           end   1     101      01JUL2007            .     01JUL2007   2     101      01AUG2007            .     01AUG2007   3     101      01SEP2007            .     01SEP2007   4     101      01JAN2008    01JAN2008             .   5     101      01FEB2008    01FEB2008             .   6     101      01MAR2008    01MAR2008             .   7     102      01FEB2007    01FEB2007             .   8     102      01MAR2007    01MAR2007             .   9     102      01APR2007    01APR2007             . 10     102      01MAY2008            .     01MAY2008 11     102      01JUN2008            .     01JUN2008 12     102      01JUL2008            .     01JUL2008 ... View more

The basic idea of interleaving records from two (or more) dataset in ID order can by done with SET and BY statements. Did you want to more than that? data one;   input serial start $15. ; cards; 101 jan2008 101 feb2008 101 march2008 102 feb2007 102 march2007 102 april2007 run; data two ;   input serial end $15.; 101 july2007 101 aug2007 101 sept2007 102 may2008 102 june2008 102 july2008 run; data both ;   set one two;   by serial; run; Output: Obs    serial      start        end   1      101     jan2008   2      101     feb2008   3      101     march2008   4      101                  july2007   5      101                  aug2007   6      101                  sept2007   7      102     feb2007   8      102     march2007   9      102     april2007 10      102                  may2008 11      102                  june2008 12      102                  july200 ... View more

I find that it is MUCH easier to use the PUT statement to generate code than to try and build it into strings. I also find it much easier to use temporary files rather than source catalogs for code generation.  You can look at them much easier and use them in more places. I like to limit my line lengths to < 80 (really 72) so that both me and the computer can read the code more easily. Here is a version of your program that is more "SASified". filename compfile temp; *filename compfile catalog 'work.tmp.compfile.source'; data _null_;   file compfile lrecl=500;   do i=1 to 25 ;     put       'compute _' i z2. ';'     / 'if not notupper(substr(_' i z2. ',1,1)) then'     / '  call define (_col_,"style","style=[BACKGROUND=#A6CE39 FONT_WEIGHT=BOLD]")'     / ';'     / 'else call define (_col_,"style","style=[BACKGROUND=#A9A9A9 FONT_WEIGHT=BOLD]");'     / "if substr(_" i z2. ",1,1) = '<' then"     / "  call define (_col_,'style','style=[BACKGROUND=#FFCC33 FONT_WEIGHT=BOLD]')"     / ';'     / 'url = "http://fabwtsdev.imec.be:8080/eDocStorageWebGui/Imec.eDoc.StorageWebGui.xbap"'     / '  || "?CtxFormat=CtxName;CtxValue;Optional;EditMode&Ctx=";'     / "T = substr(_" i z2. ",1,1) || '" i z2. "';"     / 'url_SP = url || "LotId;" || compress(LOT_ID) || ";Man;NoEdit;Operation;"'     / '  || compress(Operation) || ";Man;NoEdit;DuploWaferId;" || compress(T) || ";Opt;Edit";'     / 'if _' i z2. " ne '-' and not notupper(substr(_" i z2. ",1,1)) then"     / "  CALL DEFINE(_COL_, 'URL', url_SP || ' target=""_blank""' )"     / ';'     / "endcomp;"     ;   end; run; I think that perhaps your issue is with the last CALL DEFINE statement. Do you need to separate the URL from the TARGET= option somehow?  Perhaps by using quote(trim(url_SP))? You should test getting the syntax for this correct in a very simple example. ... View more

You have a string that is quoted with double quotes (") that has embedded double quotes. You need to double the inner ones to get them to be treated as text instead of delimiters of the string. Example: put "Hello ""Sam""."; ... View more

Quoting still looks mismatched, but it is hard to tell.  Can you paste in a copy of the generated code? That should make it easier to tell if your code generation worked. How are you calling the generated code? Can you make a simplied version of the code (without this code generation step) that gets the URLs to open in a new tab/window? ... View more