data; input a$ b$ c$ d name $; cards; Apple  Bat       Cat 100 A Grapes Ball    Dog       200  C Orange Racket Cow 300         D proc print; run; data; set; if name='A' then concat=catt(name,a); if name='B' then concat=catt(name,b); if name='C' then concat=catt(name,c); if name='D' then concat=catt(name,d);   proc print; run;   This works for me.   columns are not fixed.  Jim ... View more

data;   set; if name='A' then concat=catt(name,a); if name='B' then concat=catt(name,b); if name='C' then concat=catt(name,c); if name='D' then concat=catt(name,d);     Jim ... View more

On your input statement define the starting column of the comm field  like @49 comm 5.  . Thats because it does not have a '.'  to show the data is missing   Im not sure exactly what position comm starts in. also use the options Missing='  ';  you might have to define deptno also.   Jim ... View more

No Art,  I am from Ohio.  An old mainframe programmer.   Jim ... View more

Add these data steps to your code.   data new;  set have;   by cust_id year month;    retain holdage .; if first.cust_id then holdage=.; if customer_age not =. then holdage=customer_age; if last.cust_id then output; keep cust_id holdage; proc print; title 'new'; data three; merge have new ; by cust_id ; if customer_age=. then customer_age =holdage; if customer_age=. then delete; *else output; proc print data=three; id cust_id customer_age holdage; run;     Jim ... View more

further thinking data dups; set two; by lnno cycno dt_tm; unique=first.dt_tm and last.dt_tm; if not unique then output ... View more

Neal    data one; input @001 lnno $09. @010 cycno yymmdd6. @016 corrind $1. @017 dt_tm $10.; cards; 367940841170415Y1704181430 373065728170415 1704181430 175597502170415Y1704181431 175597502170415Y1704181430 199994811170415Y1704181430 019354533170415Y1704181430 180878441170415 1704181430 180878441170515 1704181431 158072200170415 1704181430 158072200170515Y1704181430 158072200170515 1704181430 122492196170415 1704181430 261454099170415 1704181430 261454099170415Y1704181430 143798189170415 1704181430 143798189170415 1704181430 367940841170415 1704181430 373065728170415Y1704181430 430912595170415Y1704181430 000808229170415 1704181430 430912595170415 1704181430 199994811170415 1704181430 199994811170415 1704181430 019354533170415 1704181430 019354533170415Y1704181430 029267455170415Y1704181430 122381807170415 1704181430 029267455170415 1704172150 122382609170415Y1704180100 122382609170415 0000000000 ; proc sort out=two ; by lnno cycno dt_tm; proc print; title "two"; run;   data want; set two; by lnno cycno dt_tm; if first.dt_tm and last.dt_tm then output; proc print; title "unique";   data dups; set two; by lnno cycno dt_tm; if first.dt_tm and not last.dt_tm; proc print; title "dups"; run; ... View more

proc format; value age 0-14='0-14 ' 15-65='15-65' 65-120='gt 65'; data; input name $ age ; format age age.; cards; mary 12 joe 60 ; proc print; run proc format; value age 0-14='0-14 ' 15-65='15-65' 65-120='gt 65'; data; input name $ age ; format age age.; cards; mary 12 joe 60 ; proc print; run   proc format; value age 0-14='0-14 ' 15-65='15-65' 65-120='gt 65'; data; input name $ age ; format age age.; cards; mary 12 joe 60 ; proc print; run You can use proc format   like this;    proc format; value  age    0-14='0-14  '  15-65='15-65'   65-120='gt 65';      data;   input name $ age ;     format age age.;    cards;   mary 12   joe  60   ;     proc print;  run        Jim ... View more

Your report can be done in SAS no doubt. Some areas that are unusual in programming are:  The number_before_first_gap is a variable length field depending on the number of times a gap occurs.  Then the whole record is variable depending on the number of gaps per customer. Some code that does not address these areas would be somthing like this;   proc sort; by customer week;   data;   set;    by customer  week;    retain hold1 hold2 hold3  seq; gap=no_trans=.; If first.week then do;    hold1=number;  hold2=0; hold3=0;  seq=1;   end;   if gap and seq=1 then do;    during=hold1;   seq+1;    end;   if gap and seq gt 1  then do;    if seq=2 then hold2=number;    if seq=3 then hold3=number;     end;   if not gap and seq gt 1 then do;    before= (string of hold2 and hold3);  after=number;   end;     ... View more