Hello,   data want; set have; array no{*} AM1 AM2 AM3; array no_new{*} AM1_ AM2_ AM3_; do i=1 to dim(no); if no{i} ne 0 then do; do j=1 to dim(no); if j=i then no_new{j}=no{i}; else no_new{j}=0; end; output; end; end; drop AM1-Am3 i j; rename am1_=am1 am2_=am2 am3_=am3; run; ... View more

Hello,   Providing the substring (in your ex. col2) in the form of a variable means SAS adds the spaces which fill in the variable until thje length provided (in your example 20).   Adjusting the code to test = find(col1,trim(col2)); will do it . ... View more

Hello,   DSD is what you are looking for.   data have; infile datalines dsd missover; input (A B C D E F G H I) (:$8.); datalines; "A","B","C","D","","F","","H","" ; ... View more

Hello,   proc sql; create table want as select t1.ID_Short, t1.minimum as costs, min(t2.id) as id from ( ( select ID_Short,min(Costs) as minimum from a group by ID_Short ) as t1 left join ( select * from a ) as t2 on t1.ID_Short=t2.ID_Short and t1.minimum=t2.Costs ) group by t1.ID_Short, t1.minimum ; quit; ... View more

hello,   data have; infile datalines; input state $ provider $ measure $; datalines; FL AAA A FL AAA A FL AAA A FL AAA B FL AAA B FL AAA C FL AAA C FL AAA C FL AAA C FL BBB A FL BBB B FL BBB C FL BBB C FL BBB C ; run; proc sort data=have; by state provider measure; run; data have_int; set have; by state provider measure; retain val val_tot; if first.measure then val=1; else val=val+1; if first.provider then val_tot=1; else val_tot=val_tot+1; if last.measure then output; if last.provider then do;val=val_tot;measure='Total';output;end; run; proc transpose data=have_int out=want(drop=_name_); by state provider; var val; id measure; run; ... View more