data have; input Phone $15.; datalines;   0000000000 0 1111111111 2222222222 8391134456 ; run; I have a dataset that presents phone numbers as a character variable which is common.  If the phone number is a blank, a 0 or some other incomplete phone number I want to flag it.  So in the above example the last transaction is an actual phone number that can be called.  The others are not.  In this example I using just a few examples however the phone field could show any combination of incomplete phone numbers.  Should this be done through something like proc format or is there another way ... View more

data have; length ctr $25.; input ctr cnt cnt2; return; datalines;   4544 2 1 4544 3 1 4465 10 1 4465 5 1 4475 1 0 4475 2 0 4475 3 1 4476 5 2 4476 6 1 ; run; proc report data = have nowd style(summary)=Header; column ctr cnt cnt2 /*rtot*/; define ctr /order order=data style (column)=Header "Center"; define cnt /sum f=comma6. "Total Opened"; define cnt2 /sum f=comma6. "No Activity";   /*define RTot /computed f=comma16. "Row Totals";*/ /*compute RTot; /*RTot=sum(cnt.sum,cnt2.sum);/*row_tot*/ endcomp; compute before;   sum=cnt.sum; sum=cnt2.sum; endcomp; compute after; ctr='Grand Total'; endcomp; rbreak after /summarize; run;   It produces this output (copy also enclosed) Have     Center Total Opened No Activity 4544 2 1   3 1 4465 10 1   5 1 4475 1 0   2 0   3 1 4476 5 2   6 1 Grand Total   37 8 I want to produce the following with totals and percentages by Center and then Grand totals(info highlighted in yellow) Want       Center Total Opened No Activity %Inactive 4544 2 1     3 1   Total-4544 5 2 40 4465 10 1     5 1   Total-4465 15 2 13.33333 4475 1 0     2 0     3 1   Total-4475 5 1 20 4476 5 2     6 1   Total-4476 11 3 27.27273 Grand Total 37 8     ... View more

  data have; input ln_no ; datalines;   21555555 5544000 6654444 ; run; data want; set have; if ln_no lt 17 THEN LN_No = (input(ln_no, best4.),z17.);   /*if ln_no lt 17 THEN LN_No = substr(left(LN_Nbr_R),1,10.);*/ /*if ln_no lt 17 THEN LN_No = substr(left(LN_Nbr_R),1,10.);*/ /*if ln_no lt 17 THEN LN_No = put(ln_no, z10.);/*Ln_no = put(Account, z10.);*/ run;   ln_no started out as a numeric. Desired output is to have a 17 digit number with leading zeros.  The format should retain its numeric status Something like this 0000000021555555   As you can see I have tried different pieces of code here. ... View more

data test2; set steps; by ln_no; if ls_step_cd = '543' then _543=ls_actual_compl_dt ; if ls_step_cd = '843' then _843=ls_actual_compl_dt; if ls_step_cd = 'K04' then _K04=ls_actual_compl_dt; if ln_no = '111111111'; if ls_actual_compl_dt ne .;   drop ls_step_cd ls_actual_compl_dt REC_CHNG_CD;  format _543 _843 _K04 mmddyy10.; run; Produces this output LN_NO _543 _843 _K04                   111111111 09/26/2017                       111111111 03/30/2018                       111111111 09/18/2018                       111111111 09/21/2018                       111111111 03/25/2019                       111111111   10/03/2017                     111111111   04/17/2018                     111111111   09/26/2018                     111111111   03/27/2019                     111111111     10/03/2017                   111111111     04/17/2018                   111111111     09/26/2018                   111111111     03/27/2019                   111111111     10/08/2019                                                                       Desired Output                                                 LN_NO _543 _843 _K04                   111111111 09/26/2017 10/03/2017 10/03/2017                   111111111 03/30/2018 04/17/2018 04/17/2018                   111111111 09/18/2018 09/26/2018 09/26/2018                   111111111 09/21/2018 03/27/2019 03/27/2019                   111111111 03/25/2019   10/08/2019                                             Essentially I want to rollup the first instance of each on the same line horizontally and subsequent rows almost like a waterfall display Is there a way to accomplish this?                                                                           ... View more

data test; input ln $ step $ date1 date9.; format date1 date9.; datalines;   0122 B 01jun2019 0122 B 07jun2019 0122 C 06jun2019 ; run; data test2; set test; if step='B' then b_step=date1; if step='C' then c_step=date1; format b_step c_step mmddyy10.; run; ln step date1 b_step c_step 0122 B 01Jun2019 06/01/2019   0122 B 07Jun2019 06/07/2019   0122 C 06Jun2019   06/06/2019 The above query produces this output.  The issue is I need to evaluate both the date in b_step and c_step however as you can they are on different rows because there was no C step on the other dates.  Since there is not way to evaluate rows unless they are on the same row, is there a way to program the code to get the c_step date on the same row as the b_step.  So 6/6/2019 in c_step would move to the top row.  If not then is there a way to evaluate b_step and c_step in its current condition (ie if b_step and c_step >0 then F= 'Yes' ;else F='No'; ... View more

data test; input ln $ step $ date1 date9.; format date1 date9.; datalines;   0122 B 01jun2019 0122 B 07jun2019 0122 C 06jun2019 0133 C 07jun2019 0133 B 01jun2019 0133 B 01jun2019 ; run;   The desired output is to get distinct row numbers based on the change in ln,step and date.  Then reset with a new step or ln. Something like this; ln step date1 row_num 0122 B 01Jun2019 1 0122 B 07Jun2019 2 0122 C 06Jun2019 1 0133 C 07Jun2019 2 0133 B 01Jun2019 1 0133 B 01Jun2019 1     ... View more

  data have; infile datalines ; input ln $ Date1 Date9. code $ ; format date1 date9.; datalines ;   0013 26Jul2019 K11 0013 29Jul2019 K11 0013 29Jul2019 K12 0013 30Jul2019 K12 0033 30Jul2019 A13 0033 31Aug2019 A13 0034 1Aug2019 B9 0034 2Aug2019 B10 ;run; proc sort data=have nodupkey;by ln date1;run; proc transpose data=have out=have2 (drop= _NAME_ _LABEL_) prefix=_ let ; id code; by ln ; var date1; run;   Notice that  0013 29Jul2019 K11 shows up but not 0013 26Jul2019 K11.  I know we are transposing based on code, ln and date1 however is there a way to show all instances side by side?   ... View more