my table date as date in format 10JUN2018:10:08:40.216 expecting 06-10-2018.   Thank you ... View more

Can anyome help me with the code to extract a ticket number from  variable name ' Request item' , data is as below.   number Request_item 1            This request is part of UAT Ticket# RITM0157177 2            Commit result for UAT RITM0180513     Expected results   number    request_item                                                                                     ticket 1            This request is part of UAT Ticket# RITM0157177                            RITM0157177 2            Commit result for UAT RITM0180513                                                RITM0180513   Thank you.     ... View more

i am expecting if any yes in a row display yes, if  'No' and blank  in row display No and if all blank display No.   data val.compare_results(drop= i);     set val.compare_results;     length Impacted_Patch $4; array val (*) &varlist.; do i=1 to dim(Val);         if Val{i} in ('Yes') then Impacted_Patch='Yes';         else if Val{i} = (' ') then Impacted_Patch=' ';         else if Val{i} in ('No') and Val{i} in (' ') then Impacted_Patch='No';     end; keep ID  Val_required_Nov Val_required_Dec Val_required_Jan Val_required_Feb Val_required_March Val_required_April Impacted_Patch; run;   my results:   ID Val_required_Nov Val_required_Dec Val_required_Jan Val_required_Feb Val_required_March Val_required_April Impacted_Patch 5Z4PT7 Yes Yes Yes Yes Yes Yes Yes 5Z4PTD Yes   No Yes Yes Yes Yes 5Z4PTE No     Yes Yes Yes Yes 5Z4PTP No   No No No     5Z4PTR Yes Yes Yes Yes Yes No Yes 5Z4PTX Yes   Yes Yes Yes Yes Yes 5Z4PU2 Yes   Yes Yes Yes Deferred Yes 5Z4PU3 No   No Yes Yes Yes Yes 5Z4PU5 Yes Yes No Yes No Yes Yes 5Z4PU8 Deferred Yes No Yes Yes Yes Yes 5Z4PUA               5Z4PUM Yes Yes Yes Yes Yes Yes Yes 5Z4PUZ No     Yes No No Yes 5Z4PV3               5Z4PVC               5Z4PVP No Yes Yes Yes Yes     5Z4PVX Yes Yes No Yes No     5Z4PVY Yes Yes No Yes No Yes Yes 5Z4PVZ           Yes Yes   expected results:   ID Val_required_Nov Val_required_Dec Val_required_Jan Val_required_Feb Val_required_March Val_required_April Impacted_Patch expected  5Z4PT7 Yes Yes Yes Yes Yes Yes Yes yes 5Z4PTD Yes   No Yes Yes Yes Yes yes 5Z4PTE No     Yes Yes Yes Yes yes 5Z4PTP No   No No No     No 5Z4PTR Yes Yes Yes Yes Yes No Yes yes 5Z4PTX Yes   Yes Yes Yes Yes Yes yes 5Z4PU2 Yes   Yes Yes Yes Deferred Yes yes 5Z4PU3 No   No Yes Yes Yes Yes yes 5Z4PU5 Yes Yes No Yes No Yes Yes yes 5Z4PU8 Deferred Yes No Yes Yes Yes Yes yes 5Z4PUA                 5Z4PUM Yes Yes Yes Yes Yes Yes Yes yes 5Z4PUZ No     Yes No No Yes yes 5Z4PV3                 5Z4PVC                 5Z4PVP No Yes Yes Yes Yes     yes 5Z4PVX Yes Yes No Yes No     yes 5Z4PVY Yes Yes No Yes No Yes Yes yes 5Z4PVZ           Yes Yes yes 5Z4PW8 No   No No No     No 5Z4PWB No No Deferred Yes No     yes ... View more

i can create a chart with clustered but how to create a 3D clustered chart as below   ... View more