Thanks everyone for the reminders on posting, I don't do it often but good to be aware of the conventions.    Also, thanks for the tips, I think Proc Report might work better for me.   ER. ... View more

thank you! I realized that some weeks in one of seasons were missing so the order was not going to appear the way I expected. Otherwise, the custom order worked. appreciate it. ER ... View more

Thank you.  I contacted SAS support and indeed it is a bug.  It has been reported.  I used the columns=  option and it worked.  ... View more

How does SAS know percent1 maps to 60601 and percent9 maps to 90210 for example? Do you have a lookup table with that information? ... View more

You can use wildcards on the INFILE statement. You will also want to use the FILENAME and EOV options on the INFILE statement. Here is a simple example. data _null_;   do file='one.txt','two.txt' ;     fname=catx('\',pathname('work'),file);     file out filevar=fname ;     do i=1 to 10; put i; end;   end; run; data want ;   length fname file $200;   infile "%sysfunc(pathname(work))\*.txt" eov=eov filename=fname;   input @;   if _n_=1 or eov then do;      input // i ;   file = scan(fname,-1,'\');     output;   end; eov=0; run; ... View more