I figured as much, but it was worth a shot.  Thanks for following up.   Jim ... View more

Hi, without data it's not entirely clear what you want. I read this as you want the "new" B value to become the value for A, IF the first character of "old B" value is a number/digit and you want to switch the A value to the "new" B? Like this: Is this what you meant? If so, assuming the data (WORK.FAKEDATA) shown in the first PROC PRINT, this program using ANYDIGIT and SUBSTR does the swap. You can look in the doc to find out what those functions do, as well as looking up the RENAME= option. Of course, you may need to tweak the program based on the real names and lengths of your real variables. The Final dataset is called WORK.SWITCH. Cynthia data switch;   set fakedata(rename=(b=oldb));   if anydigit(substr(oldb,1,1)) = 1 then do;      b = a;      a=oldb;   end;   else do;      b = oldb;   end; run;    proc print data=switch;   title 'Switched data (can drop OLDB var after verifying)';   var a b oldb; run; title; ... View more

If you have opened the database then MS Access locked it and you can't use this method. Or double check the exact name and path, once in awhile a not-obvious space creeps into a path: TAPDB_For SCRR or TABDB_For  SCRR   <= 2 spaces ... View more

Another Solution with Data Step. You need to have the data set, HAVE. to be pre-sorted by Child. The array size is taken as 4 but can be extended as desired. data want; array t $1 Treatment_1 - Treatment_4; do until(last.Child);    set have;    by Child;    if first.Child then i = 1; t = Treatment; i + 1; end;    else if Treatment ^= t[i - 1] then do; t = Treatment; i + 1; end; end; drop i Treatment; run; ... View more

No need for double proc freq , just add an option NLEVELS . if I am not making a mistake . data class;set sashelp.class;run; proc sort data=class;by sex;run; ods select NLevels; ods output NLevels=want; proc freq data=class nlevels; by sex; tables age; run; Xia Keshan ... View more