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: 
kenwill
‎12-03-2018
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: PROC TABULATE with percentage calculations

by Calcite | Level 5 in New SAS User
‎12-01-2018 04:48 PM
‎12-01-2018 04:48 PM
Thank you. I will try your approach to see if it will work for my case.   ... View more

Re: PROC TABULATE with percentage calculations

by Calcite | Level 5 in New SAS User
‎11-30-2018 04:04 PM
‎11-30-2018 04:04 PM
Hi,   Thanks for the advice!   I have attached the dataset in Excel format (Book1.xlsx). Would that help?   Regarding the row percentage calculations. How can I calculate them with respect to the subtotal (ie., per each month) instead of the whole row (pls see Table2.xlsx)? I am not familiar with nesting, any tips are most welcome.   Thanks!   Ken ... View more

PROC TABULATE with percentage calculations

by Calcite | Level 5 in New SAS User
‎11-30-2018 02:31 PM
‎11-30-2018 02:31 PM
Hi,   This is a follow up to a question I posted earlier. This time, I tried to do percentage calculations but not quite successful.   Please see attachments: Data set: table.sas7bdat 2 tables I tried to create: Table2.xlsx   Below are my SAS codes. I can calculate the column percentages correctly, but not the row percentages. Besides, I want to show the N and % side by side instead of two separate tables (one for N, another for %) like what I did here. How can I do that?   /* Column percentages */ proc tabulate data=test.table; where temperature ~= 'warm' and month ~= 'december'; class month time; class temperature / mlf; table time=' ' all='Total', month=' '*(temperature=' ' all)*n=' ' month=' '*(temperature=' ' all)*colpctn=' ' ; run;   /* Row percentages */ proc tabulate data=test.table; where temperature ~= 'warm' and month ~= 'december'; class month time; class temperature / mlf; table time=' ' all='Total', month=' '*(temperature=' ' all)*n=' ' month=' '*(temperature=' ' all)*rowpctn=' ' ; run;   Thank you for any advice!   Ken   ... View more

Re: Create table of multiple variables

by Calcite | Level 5 in New SAS User
‎11-28-2018 07:35 PM
‎11-28-2018 07:35 PM
It works! I will apply the same approach in future. Thanks very much!! ... View more

Re: Create table of multiple variables

by Calcite | Level 5 in New SAS User
‎11-28-2018 04:53 PM
‎11-28-2018 04:53 PM
  Hi,   Thanks so much! This is very helpful.    I have added a 'where' statement to filter out the 'warm' category.    proc tabulate data=test.table; where temperature ~= 'warm'; class month time temperature; table time=' ' all='Total', month=' '*temperature=' '*n=' ' ; run;   However, I want just 2 columns for each month: first column for the combined frequency of cool, cold, and freeze (and name the variable as 'not warm'), and the second column for just the freeze frequency. Any advice on how should I approach it? Appreciate.   Thank you.   Regards,    Ken ... View more

Create table of multiple variables

by Calcite | Level 5 in New SAS User
‎11-28-2018 01:43 PM
‎11-28-2018 01:43 PM
Hi,   I am new to SAS and would need some expert advice.   I try to create a table of 3 variables. The hypothetical data is saved as table.sas7bdat as attached.   Also attached is the report table format I need (see Table.xlsx).   I used the follow proc freq codes to create the table I want but it gives me 3 separate tables instead. Also, I couldn't produce the column formats I need.    proc freq data = test.table (where=(temperature not in ('warm'))); table month*time*temperature / out = class norow nocol nopercent ; run ;   Please advise me what's the correct codes to produce the table.    Also, is it possible to use PROC TABULATE or some other approach to create the same table?   Thank you!   Regards,    Ken ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-03-2018 04:10 PM
Quick links