Home

FrederikV · ‎01-12-2022

In this article I'd like to introduce a new solution introduced by SAS, for SAS cloud deployments: SAS Workload Management.

fwu811

Hi, I would like to apply two floors to the existing dataset below (Col1 values are sorted): 1) For any values in Col1 ❤️ replace their values in Col2 with that for Col1 =3; 1) For any values in Col1 >4 replace their values in Col2 with that for Col1 =4; Many thanks in advance. data have; input Col1 Col2; datalines; 1 1 2 2 3 3 4 4 5 3 6 2 7 1 ; data want; Col1 Col2; 1 3 2 3 3 3 4 4 5 4 6 4 7 4

fwu811 · ‎01-10-2024

Hi, I would like to do some simple averaging of the existing dataset by certain grouping and bucketing, but I also need to ensure that the value of each bucket increases as buckets always increase. For example, data have; input Col1 Col2; datalines; 1 2 2 2 3 1 4 1 5 3 6 3 ; Data I want are; <=2 2 <=4 2 <=6 3 Note that for the bucket with Col1 values between 2 and 4, the actual average is 1, which is less than the value (2) of the bucket for Col1 less than 2, so the final value for the 2nd bucket should be replaced with 2. Many thanks in advance.

_Manhattan

Hello, I am struggling with controlling page breaks in proc report/ods PDF. I already did a post a few months ago (https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-suppress-table-splitting-in-ODS-PDF/m-p/907292#M26446), but I have not found a solution yet. First, I thought I will just use ods rtf with the keepn option, but that brings more problems than it solves. Now, I have just found a paper that kind of describes the problem from Stetz et al. "Controlling Page Breaks when using Proc Report" (https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://support.sas.com/resources/papers/proceedings-archive/SUGI95/Sugi-95-70%2520Stetz.pdf&ved=2ahUKEwjHib_10PuFAxUi_rsIHa0GA9oQFnoECBAQAw&usg=AOvVaw0Z1J0znhm8-SeB_Oxq4tBr). Unfortunately, the paper is quite short and I do not understand how the data in the example code is structured. My question is: Does anyone have further knowledge on using "line counting" to control page breaks with proc report? Or does anyone know other papers that talk about this issue? @Cynthia_sas did you write the paper? And if so, have you got any tips for the page break control? If anyone needs code examples I can provide code and data, but for now I thought it would be more useful if I try different approaches before just posting my code where I did not achieve much yet. I am grateful for any help. Kind regards

bhca60

I have an admit date variable (admitdt) that needs to be brought in to define a few month and week variables but these have to be done in a separate step. Is there a way to create a macro in one data step that can be used in several? Do I just do a LET statement The admitdt format is mmddyy10.