Hi , I have a dataset which has rpflag , rp1,rp2,rp3,rp4 amounts in numeric format . I want to create rp5 column    case when rpflag = 'Y' then (TRIM(put(rp1,8.)))||'/'||(TRIM(put(rp2,8..))) when rpflag = 'N' then (TRIM(put(rp3,8.)))||'/'||(TRIM(put(rp4,8.))) else '' end as rp5   RPFlag  RP1 RP2 RP3 RP4 RP5 Y 20 35 0 0 20/35 N 0 0 20 30 20/30 N 0 0 0 0 0/0 Y 0 0 0 0 0/0 Y 56 33 0 0 56/33 ... View more

Hi ,   I have two datasets test1 and test2 . I am comparing SD022 variable by City in both datasets whether counts match and what is the percent difference . I want to highlight proc compare output when the percent difference is higher .   In below for city Ocala and SD022 P1  Base is having 32045 records and Compare have 2205 there is huge difference and percentage difference is -96.15 . I want to highlight this using sas . Like this I need to run for SD024 ,SD023 and MD052 variables and generate one report and highlight percentages which are higher .   Obs _TYPE_ _OBS_ City SD022 COUNT PERCENT 1 BASE 1 Ocala P1 32045 4.5048 2 COMPARE 1 Ocala P1 2205 4.8495 3 PERCENT 1 .. ...... -96.15 -96.1495 4 BASE 2 Ocala P2 16762 0.2128 5 COMPARE 2 Ocala P2 16621 0.2108 6 PERCENT 2 .. ...... -0.84 -0.9649 7 BASE 3 Ocala P3 790663 10.0385 8 COMPARE 3 Ocala P3 785776 9.964 9 PERCENT 3 .. ...... -0.62 -0.7421   Can anyone please help ? ... View more

Hi , I have a SAS Dataset  summary_details   which looks like below and I want that dataset to export to specific cells in Excel (c17 to d17 : c20 to d20) with a specific sheet name (Test60) how do it do that ?   SAS Dataset Summary_details _NAME_    COL1 IP_SUM     10 CV_SUM    20 RS_SUM    30 I want above SAS Dataset to be in C17 to d17 and c20 to d20  in excel  and sheet name should be Test 60 . How do I make above data to fall into specific cells in excel . Can anyone please help ?   IP_SUM     10 CV_SUM    20 RS_SUM    30                     ... View more