Sounds like you have hit the limit of the ability of that filename egine and your work around is just going to ignore the end of the file. You either need to update your SAS version (why are you still using a program that is over 7 years old when newer versions are available for no extra money?) or switch to using ZIP ro 7z or other utility that can handle those files. ... View more

In addition to my suggestion of building the program data vector to make call missing(of _pre -- _post) work as intended, I suggest you modify the code below,   from       if h.find() then do;         call missing (of _pre--_post_);         output;       end;       if not h.find();output;       if not h.find_next();output;   to       call missing (of _pre--_post_);       rc=h.find();       output;       do rc=h.find_next() by 0 while (rc=0);          output;          rc=h.find_next();       end;               It reduces the number of explicit output statments, and it accomodates cases in which a key value occurs more than twice. ... View more

You have two hash table, so you need two RC. data out_set; set in_set; length var1 var2 8; if _n_ =1 then do; declare hash h1(dataset: 'lkup_1',multidata:'y'); h1.defineKey('key1'); h1.defineData('var1'); h1.defineDone(); declare hash h2(dataset: 'lkup_2' , multidata:'y'); h2.defineKey('key2'); h2.defineData('var2'); h2.defineDone(); end; call missing(var1,var2); rc1= h1.find(); rc2= h2.find(); do while (rc1=0 and rc2=0); output; rc1= h1.find_next(); rc2= h2.find_next(); end; miss_flag = missing(var1); run; ... View more

Your macro parameter consists of two parts: ccyy and mm Macro DateText can extract ccyy and mm from an integer of a date: http://www.sascommunity.org/wiki/Macro_Loops_with_Dates#Macro_DateText %Macro Do_This         (start=%sysfunc(mdy(3,1,2012))         ,stop=%sysfunc(today())         ,interval=month ); %do ThisDate = &Start %to &Stop;     %let D_Begin = %sysfunc(intnx(&Interval,&start,0,begin));     %let D_End = %sysfunc(intnx(&Interval,&start,0,end));     %let ccyymm = %datetext(date=&ThisDate     ,text = %nrstr(work.&year-&mm     );     %put note: ccYYmm = &ccYYmm.;     *...;     %let &ThisDate = %eval(&D_End+1);     %end; %mend; %do_This() ... View more

In brief, you need a table called a SAS control table in a specified layout.  Then you just invoke      proc format cntlin = your_control_table ;      quit ; At a minimum the control table needs to have 3 columns which must be called start, label and fmtname.  The first is the initial value, the second is the formatted value, and the third is the name to be assigned to the format.  Values in the fmtname column are repeated for every row. You can create this table in SQL or in a datastep (imagining that the only possible marks are 0, 590, 60, 70, 80)      proc SQL ;           create table fmtcntl as                select  mark as start                     ,     grade as label                     ,     'gradefmt' as fmtname                from     grades_lkup ;      quit ;      proc format cntlin = fmtcntl ;      quit ; You can only have one cntlin table per proc format invocation, but the control table can have concatenated lists of lookups if each has thier own fmtname. If you want to create a character format you have to add an additional column called type which would hold the value 'C' for each row.  (The default is 'N' for a numeric format).  Fir a numeric informat, type = 'I'.  Other columns can hold additional information: eg end is the end value of a range.  You need that if your grade format has a continuous integer range.  Thus for your data (where end values have to be inferred) data fmtcntl ;      length       start     end     8     grade     $ 4 ;      retain      fmtname      'gradefmt' ;      set grades_lkup end = lastrow ;      start = lag (mark) ;      end = mark - 1 ;      label = lag (grade) ;      if    _N_ = 1        then return ;      output ;      if lastrow        then           do ;                start = mark ;                end   =  100 ;                label = grade ;                output ;           end ;      drop mark ; run ; This may seem more effort than is worth for a simple format, as in you example, but if you lookup table contains more than a few rows it can be worthwhile especially for lookup tables which are straight transformations. Richard in Oz ... View more