I would like to extract just the number 27.59 from the following Positive (27.59). Irrespective of the text before the parenthesis.   thank you ... View more

I have SQL date time field that downloaded as text field. 03/01/2021 11:35 used the following code to read.. input(trans_Date,anydtdtm.) as Date_Transfered format=dtdate9., but when I try to query the data : where Date_Transfered >= '01MAR2021'd; where clause is not working and it's pulling all the observations.   What did I miss?  Thank you ... View more

I' m using the following colors but they are too bright. Are there any other mild shades for red, green and yellow to show on the report? if diff_pct gt .9 then call define(_row_,'style','style=[background=lightgreen]'); if .6 le diff_pct le .9 then call define(_row_,'style','style=[background=yellow]'); else if diff_pct lt .6 then call define(_row_,'style','style=[background=lightred]');   ... View more

Have.. State BiWeekly_target wk Reached_status AK 15 2021-02-14 To 2021-02-20 12 AL 11     AR 8     AZ 12 2021-02-07 To 2021-02-13 8 CO 10 2021-02-14 To 2021-02-20 9 CT 11 2021-02-14 To 2021-02-20 11 DC 16 2021-02-07 To 2021-02-13 12 DE 9 2021-02-14 To 2021-02-20 9 Want     week       2021-02-07 To 2021-02-13 2021-02-14 To 2021-02-20 Reached_status     state BiWeekly_target   Diff %Diff AK 15 - 12 12 3   AZ 18 8 - 8 10   CO 10 - 9 9 1   CT 11 - 11 11 0   DC 16 12 - 12 4   DE 9 - 9 9 0   So far tried the following.. ODS excel options(sheet_name=' Counts ' autofilter='all' embedded_titles='yes' embedded_footnotes='yes' absolute_column_width='10,45,15,25,25,15' flow = "header, data"); proc report data=target_stat nowd SPLIT='*' ;*completerows; column state BiWeekly_target Category, Reached_status ('Total' Reached_status =tot);; define state / group width= 45 " Submitter"; define BiWeekly_target / group width= 45 " BiWeekly * Target"; define Category/ across width= 30 order= Internal "week "; define Reached_status / sum width= 30 " "; define tot / sum ' '; run; Need to achieve.. 1) Show all states irrespective of reached_status For ex: AL & AR- completerows is not working as desired 2) Add new column in report to show the difference BiWeekly_target- Reached_status 3) Add another column to show the percent difference. 4) Color, if difference is zero then target reached so it should be green, If diff greater than 75% then it should be yellow otherwise red. 5) Is it possible to wrap the second row in the report( dates row)?   thank you ... View more

Have this.. PID Col1 Col2 p1 p2 3527 21       3527     99   3527         3528         3528     25.32   3400     26   3400         3400         3200     12   3200 33       3200       30.2 3201       27 3201         3922   19     3922         3923 23       3922         3923       99 3922       35 3923         Want this.. PID Col1 Col2 p1 p2 3527 21   99   3528     25.32   3400     26   3200 33 12   30.2 3201       27 3923 23     99 3922   19   35 ... View more