Hi! I need your help to output the Top 2 scores, including ties, from this dataset.    /*Have*/ data have; input name $ gender $ score; cards; Ann F 100 May F 100 Jean F 90 Leah F 89 Felix M 100 Chris M 95 Greg M 90 ; run;   /*Output Top 2 for Each Gender, Including Ties*/ data want; input name $ gender $ score; cards; Ann F 100 May F 100 Jean F 90 Felix M 100 Chris M 95 ; run;   Thank you! ... View more

Hi, I generated a report using PROC REPORT, and I'd like to merge the cells in the upper top left portion. These are merged when proc tabulate is used.   proc report data=sashelp.cars; column make invoice type ,drivetrain ; define make /group; define type/ across ; define drivetrain/ ' ' across ; run; ... View more

*Hi, I have this dataset that I want to group by name and color, and count by this combination.   data have; input name $ color $; cards; ann green ann blue ann yellow ann blue ; run;   *In the event that there are ties in count by 2 (or more) groups, I'd like to place the list of these groups in the same column.   data want; input name $ color :$20. count; cards; ann green,yellow 1 ann blue 2 ; run;   *Thank you! ... View more

Hi, I need help on how to get the duration between two timeslots:   In my HAVE dataset below, a mobile's log-in time is recorded. With that, I'd like to get the duration a mobile spent in "home" and in "work", whose values in my WANT dataset.    data have; input mobile time :datetime21. scenario location $4.; datalines; 600000001 13FEB2019:00:01:00 0 home 600000001 13FEB2019:00:03:00 0 home 600000001 13FEB2019:00:04:00 0 home 600000001 13FEB2019:00:05:00 1 work 600000001 13FEB2019:00:11:00 1 work 600000001  13FEB2019:00:13:00 0 home ; run;     Resulting dataset:   data want; input mobile duration :time. location $; datalines; 600000001 03:00:00 home 600000001 09:00:00 work ; run;   data want; set want; hours=duration/60/60; run;   Thank you! ... View more

 Hi, I want to get the grand totals and subtotals of my HAVE dataset depending on the levels of my fields. But let's say my HAVE dataset have null values for the other sublevels. After I execute the PROC REPORT, the level with incomplete sublevels disappear.    In the dataset below, the first row disappears after running PROC REPORT. I'd like to know how can I retain this level (Level_1 = Grandfather) with missing sublevels. Thank you!      /*Disappearing Row*/ data have; input Group_Name :$20. Level_1 :$20. Level_2 :$20. Level_3 :$20. num; datalines; Group_a Grandfather . . 10 Group_a Grandmother Mother Daughter 90 Group_a Grandmother Father Daughter 80 ; run; /*Get Subtotals For Each Report Level and Grand Total*/ ods select none; proc report data=have out=dontwant nowd; column group_name level_1 level_2   level_3 num; define group_name /group; define level_1/group; define level_2/group; compute before group_name;  Member=group_name; endcomp; compute before level_1;  Member= level_1; endcomp; compute before level_2;  Member= level_2; endcomp; break before level_1/summarize; rbreak before/summarize; run; ods select all; ... View more

Hi, I'd like to request assistance again in getting the subtotals and totals from this dataset, also transposing the variable "class" from long to wide. Let's say I would not have any idea how many distinct values of "class" will there be.   My preferred result would be a SAS dataset, in "WANT2".   Thank you!   data have2; input Group_Name :$20. Member :$20. class $4. num; datalines; Group_a Member_a_1 num1 6 Group_a Member_a_2 num1 4 Group_b Member_b_1 num1 6 Group_b Member_b_2 num1 3 Group_a Member_a_1 num2 0 Group_a Member_a_2 num2 1 Group_b Member_b_2 num2 1 ; run;     data want2; input final_text :$20. num1 num2; datalines; Grand_Total 19 5 Group_a 10 1 Member_a_1 6 0 Member_a_2 4 1 Group_b 9 4 Member_b_1 9 3 Member_b_2 0 1 ; run; ... View more