Hi,   I have four-ish SAS steps that i want to repeat until no more records are deleted in the last step. I was thinking do/until sounded right, but i have never used it before, so i wasn't sure.  So keep in mind, while i'm playing around with writing stuff, nothing is currently running.  This is pretty much abstract theory so far.   But i was thinking:   %macro %do %until (var=0);   blah - frequency   blah - second separate data step   blah - third separate data step   blah - other data step   blah - check dictionary tables for record counts   var=[record counts]-[record counts] %end; %mend;   So in step 5, it was grabbing the nobs from the dictionary tables, so could tell whether any records were deleted in step 4, and have a tangible count of it.  If no records were deleted, stop processing, if records were deleted, process the cycle again.   But then i realized i needed an iterative counter to track the datasets through each cycle and then i realized i had to write in a split path at the top so that first time through it would take one dataset to start, but second+ it would take the end table from the previous time through, and now i'm wondering if this is even the best way to do it.   What do you guys think?   Thanks. ... View more

Hi all,   I have an array code, and i'd like to convert bvar(i) to the actual variable name that it's referencing at the time and put it as text into another character field.  I've bolded it in the code. So i'd like for it to say xclm_thru## instead of bvar(i).   Any ideas?   Thanks     Data junk.x4b2_rewrite3 ;     /*new vars*/     array vvar(*) $200 case1 - case&max.;     array wvar(*) new_clm_from1 - new_clm_from&max.;     array xvar(*) new_clm_thru1 - new_clm_thru&max.;         set junk.x4b2_rewrite2;         /*existing vars*/         array avar(*) xclm_from1 - xclm_from&max.;         array bvar(*) xclm_thru1 - xclm_thru&max.;     do i=1 to &max.;         do j=2 to &max.;         by kecc_id;             if bvar(i) > avar(j) then do;                 wvar(i)=avar(i);    /*from*/                 xvar(i)=bvar(j);    /*thru*/                 vvar(i)="03 - bvar(i) next claim start date is earlier than current claim end date";             end;         end;     end;     format new_clm_from: new_clm_thru: mmddyy10.; run; ... View more

Hi,   I saw a couple of other posts on countw within a macro, but none addressed what i'm seeing.   I've inherited code, and i understand what it's doing (added commas between the list of words), but i keep getting errors when i try to run it.  Don't ask why one macro variable is another macro variable that holds the list.  I havent' gotten that far in cleaning it up yet... %let _mClist     = PROVHCFA seq_keyc HCFASAF DISCSTAT PDGNS_CD;             *define variables of interest; %macro test (varList = &_mClist);     %put _mClist     = &varList;                 *define variables of interest;     %let _mSelectedVar =;     %do i = 1 %to %sysfunc(countw(&varList.));             %if &i < %sysfunc(countw(&varList.)) %then                   %let _mSelectedVar = &_mSelectedVar %scan(&varList,%eval(&i)),;    /*if  < 5 then _mSelectedVar = _mSelectedVar + a comma*/             %else %let _mSelectedVar = &_mSelectedVar %scan(&varList,%eval(&i));    /*if last variable (ie, 5 < 5 will be false), then just _mSelectedVar, no comma*/     %end; %mend; %test (varlist=); When i run that, the log says: ERROR: The function COUNTW referenced by the %SYSFUNC or %QSYSFUNC macro function has too few        arguments. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric        operand is required. The condition was: %sysfunc(countw(&varList.)) ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro TEST will stop executing.   But i've seen countw with just a single macro input before, so i dont' know what it thinks is missing.   So then i replaced the macro variable with the actual variable list, and i get this in the log after each cycle: ERROR: The function COUNTW referenced by the %SYSFUNC or %QSYSFUNC macro function has too few        arguments.   Any ideas?   Thanks, Megan         ... View more

Hi all,   I ran a frequency and now i want to create a second table off the first table and make the numeric count into a character count so that i can suppress low turnout values with an asterisk.  Originally, i tried input(), since i was going from numeric to character.  In end, i tried all 4 options.   I run this one, and I get the "numeric values converted to character" in the log, and the count2 values are now "." for everything that should have an actual value: data test;       length count2 $5;       set junk.Part1a_count;       if 1 <= count <= 10 then count2="*";       else count2=input(count,8.);       where zipcode ne ""; run;   I run this one, and I get the "numeric values converted to character" in the log, but no values in count2 where there should be values.  Just blanks. data test;       length count2 $5;       set junk.Part1a_count;       if 1 <= count <= 10 then count2="*";       else count2=left(input(count,$5.));       where zipcode ne ""; run;   I run this, get no errors, but no values in count2 where there should be values.  Just blanks: data test;       length count2 $5;       set junk.Part1a_count;       if 1 <= count <= 10 then count2="*";       else count2=put(count,8.);       where zipcode ne ""; run;     If i run this, I get a warning in the log that count has already been defined as numeric, but it works. data test;       length count2 $5;       set junk.Part1a_count;       if 1 <= count <= 10 then count2="*";       else count2=left(put(count,$5.));       where zipcode ne ""; run;   What's the code to make it work, but without the warning message?   Thanks ... View more