cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
eduong58
‎01-18-2022
  • 7 Posts
  • 10 Likes Given
  • 0 Solutions
  • 2 Likes Received

Re: Coloring Report Columns using Proc Tabulate

by Fluorite | Level 6 in SAS Programming
‎12-21-2021 09:21 PM
2 Likes
‎12-21-2021 09:21 PM
2 Likes
@Ksharp , I got the same output with you since  I don't want to apply RED to other ALL columns.  So I added the separate style for Grand Total itself and it works.    proc tabulate data=test ; class name Sport ; class Status / style=<parent>; classlev Sport / s=[background=$COLOR.]; classlev Status /style=<parent>; var cnt / style=<parent>; keyword sum / style=<parent>; keylabel sum=' '; *keyword all/style={background=lightred}; table name=' ' ALL={Label='Grand Total' style={BACKGROUND=lightred}} * {STYLE={BACKGROUND=lightred}} , Sport = ' '*Status=' '*cnt=' '* {style=<parent> {foreground=black}} ALL=' ' * Status='Total' * {STYLE={BACKGROUND=lightgrey}} * cnt=' ' ALL='Each Person Total' * {STYLE={BACKGROUND=lightyellow}}* cnt=' ' /style_precedence=row; ; run;       ... View more

Re: Coloring Report Columns using Proc Tabulate

by Fluorite | Level 6 in SAS Programming
‎12-16-2021 07:30 PM
‎12-16-2021 07:30 PM
Thank you so much for you two help @Ksharp @Cynthia_sas !!! It works perfectly 🙂 Also, I want to add the Grand Total row at the end of the report, and want to apply the background RED color across the table. I'm not sure if its possible to overwrite the color we assigned for Sport or not.   here is the new piece that I added to the code but does not work: PROC FORMAT; VALUE $COLOR 'running'='lightorange' 'soccer'='lightgreen' 'swimming'='yellow'; RUN; proc tabulate data=test ; class name Sport Status / style=<parent>; classlev Sport / s=[background=$COLOR.]; classlev Status /style=<parent>; var cnt / style=<parent>; keyword sum / style=<parent>; keylabel sum=' '; table name=' ' ALL='Grand Total' * {STYLE={BACKGROUND=lightred}} , Sport = ' '*Status=' '*cnt=' '* {style=<parent> {foreground=black}} ALL=' ' * Status='Total' * {STYLE={BACKGROUND=lightgrey}} * cnt=' ' ALL='Each Person Total' * {STYLE={BACKGROUND=lightyellow}}* cnt=' ' ;run; ... View more

Re: Coloring Report Columns using Proc Tabulate

by Fluorite | Level 6 in SAS Programming
‎12-13-2021 09:20 AM
‎12-13-2021 09:20 AM
hi @Ksharp . Thank you for your reply. I want to print this report in email. I'm not sure if I can use "proc report" instead of "proc tabulate" since I want to add 2 extra Total columns at the report. Can you please advise if your way create these 2 Total columns? Here is the view of my report: Code I used: (exactly like the one i posted in question with 2 extra lines at the end) proc tabulate data=test ; class name Sport Status ; classlev Sport / s=[background=$COLOR.]; classlev Status /style=<parent>; var cnt / style=<parent>; keyword sum / style=<parent>; keylabel sum=' '; table name=' ',Sport = ' '*Status=' '*cnt=' '* {style=<parent> {foreground=black}} ALL=' ' * Status='Total' * {STYLE={BACKGROUND=lightgrey}} * cnt=' ' ALL='Each Person Total' * {STYLE={BACKGROUND=lightyellow}}* cnt=' ' ;run; ... View more

Coloring Report Columns using Proc Tabulate

by Fluorite | Level 6 in SAS Programming
‎12-12-2021 11:45 PM
‎12-12-2021 11:45 PM
Hi. I'm trying to create this report view using Proc Tabulate, but I cannot apply color on the first row to the bottom of the table. Can you please advise what's wrong with my code? Thank you so much in advance! Sample Data data test; input name$ Sport$ Status$ cnt; datalines; Berlin running win 10 Berlin running lose 10 Berlin running tied 10 Mainz running win 20 Mainz running lose 20 Berlin soccer win 5 Berlin soccer lose 6 Berlin soccer tied 7 Mainz soccer win 8 Mainz soccer tied 9 Berlin swimming win 10 Berlin swimming lose 8 Berlin swimming tied 9 Mainz swimming win 11 Mainz swimming lose 15 Mainz swimming tied 2 ;run;   Goal: apply different color on each sport block what I have now: the color only apply on sport cell. I think I might put the style=<parent> in the wrong place. here is my code: PROC FORMAT; VALUE $COLOR 'running'='lightorange' 'soccer'='lightgreen' 'swimming'='yellow'; RUN; proc tabulate data=test ; class name Sport Status ; classlev Sport / s=[background=$COLOR.]; classlev Status /style=<parent>; var cnt / style=<parent>; keyword sum / style=<parent>; keylabel sum=' '; table name=' ',Sport = ' '*Status=' '*cnt=' '* {style=<parent> {foreground=black}} ;run;     ... View more

SAS Add-in Scheduler using an Input Schedule File

by Fluorite | Level 6 in SAS Programming
‎07-27-2021 04:23 PM
‎07-27-2021 04:23 PM
Hi. I'm looking a way to create a scheduler in SAS Add-in using my own schedule file to refresh the Excel file without opening it. The schedule file should look like following table:  (Note: always run at 5am) CURRENT MONTH  CURRENT YEAR DATERUN January  2021 1/1/2021 February  2021 2/1/2021 March 2021 3/2/2021 April 2021 4/3/2021 May 2021 5/3/2021 June 2021 6/6/2021 I think I need to update VBS Script file in order to import and read the schedule file but I don't know how. Attached is the VBS Script file. The schedule create it when I use the  schedule that SAS Add-in has.    Thank you in advance! ... View more

Re: How to find strings that contain values from other variables?

by Fluorite | Level 6 in SAS Programming
‎03-24-2021 12:35 PM
‎03-24-2021 12:35 PM
Thank you so much for all of your help! I found out the issue is case insensitive. I changed that to all uppercase like @FreelanceReinhard and it works perfect! ... View more

How to find strings that contain values from other variables?

by Fluorite | Level 6 in SAS Programming
‎03-24-2021 11:12 AM
‎03-24-2021 11:12 AM
Hi, I'm a newbie to SAS I have 2 datasets, and I want to accomplish as below.    data one; input Description $80.; cards; Orange Test - Orange, All Ages - Capital Test Apple ABC - <20, Male - Capital Test Pear ABC - <20, Male - Capital Test Apple - 21+ Years, Female - Capital Pear Eligible Test - Pear Eligible, All Ages - Region Pear Test - Pear Eligible, All Ages - Region Other SBH - Other, All Ages - South Central ;   data two; input key1 $ key2 $; cards; CAPITAL APPLE CAPITAL PEAR CAPITAL OTHER CAPITAL ORANGE REGION SSI REGION PEAR SOUTH OTHER ;   Output should look like this. List out all descriptions that contain  both key1 and key2 values :  key1 key2 Descr CAPITAL APPLE Test Apple ABC - <20, Male - Capital CAPITAL APPLE Test Apple - 21+ Years, Female - Capital CAPITAL PEAR Test Pear ABC - <20, Male - Capital CAPITAL OTHER not found  CAPITAL ORANGE Orange Test - Orange, All Ages - Capital REGION SSI not found  REGION PEAR Pear Eligible Test - Pear Eligible, All Ages - Region REGION PEAR Pear Test - Pear Eligible, All Ages - Region SOUTH OTHER Other SBH - Other, All Ages - South Central    I have tried findw  "if findw(one.Description,two.key1)>0 and findw(one.Description,two.key2)>0 then Descr=one.Description else Descr= 'not found' ", but it does not work.   I really appreciate your help. Thank you in advance! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-18-2022 03:30 PM
Likes given to
Likes from
View All
Quick links