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-sp...
DATA ALT; SET RCA.CLOSING_STATUS_TEST; ARRAY COLS _CHARACTER_; ARRAY COLS_ _CHARACTER_; DO I = 1 TO DIM(COLS); IF MOD(I, 2) =�...
Hi When dealing with SAS alerts, I make a description in notes before closing the alert. I always use the same sentence in the end like "Nothing suspicious found" Is there a way to make a sho...
https://communities.sas.com/t5/New-SAS-User/Create-standard-text-to-use-in-Notes/m-p/927291#M41631
I have a data set with multiple variables (columns). I'm trying to get the top 10 values of each variable. However, I would like the output to be in a new dataset with a new variable called: ...
In proc reg command, When we use 'selection=' option to select the best regression model based on various criteria (e.g. aic, cp, bic, rsquare and etc..) How does SAS come up wi...
How to create a tabulated report based on data: Column CATEGORY in H means a horizontal report. TITLE_LEVELS indicate how many levels of title there are. TITLE_LEVEL1 is the main header, TITLE_...
https://communities.sas.com/t5/SAS-Enterprise-Guide/Proc-Tabulate/m-p/927280#M44740
Hi, can anyone guide me regarding the steps related to email settings at the SAS level, i.e. how to send emails using the SAS enterprise guide and e-mail SMTP Setup with Microsoft Office 365?...
Hi I have a file uploaded to a big data platform showing correct d.p but somehow when our clients see the same file via ODBC, the decimal place change from 4 to 2, how did that happen? Do I need ...
https://communities.sas.com/t5/SAS-Programming/odbc/m-p/927266#M364933
Hello, I am running an interaction but need to reorder the x axis variables from how it is displayed below to PRISm, GOLD 0 - GOLD 4. Additionally, I need to change the legend diabetes_P1 t...
https://communities.sas.com/t5/New-SAS-User/Renaming-and-reording-X-axis-variables/m-p/927265#M41626
Hi, I'm currently merging multiple datasets and consistently using the following SQL code to verify there are no duplicate IDs at each stage of the process: proc sql; select count(distin...
https://communities.sas.com/t5/New-SAS-User/Select-distinct-count-not-working/m-p/927237#M41616
The SAS 9 team is looking at ways to improve the deployment and migration experience when moving to a newer version of SAS 9. One of the projects we are looking at is the usage of Deployment T...
I trying to create a stacked bar chart comparing MA and TM groups on 8 different binary variables (I've only shown 2 here for simplicity) and 1 discrete (0-8) continuous variable. I've created ...
Hi, I have a fiction dataset that I've created like this data countries; length country $20 country_1 $50; input country $ country_1 $; datalines; AE U...
https://communities.sas.com/t5/SAS-Programming/hierarchical-data/m-p/927203#M364911
Hello everyone, I have survey data of approximately 5000 participants and I am currently looking to model the outcome of a dichotomized response variable to a predictor. Our question is if...
https://communities.sas.com/t5/Statistical-Procedures/PROC-LOGISTIC-question/m-p/927197#M46121
The function split_part(col_name,delimiter, index) worked well with select statement in the HUE editor when connected to impala. The same function throws an error when running in SAS EG. ...
data vs ; input patient cpevent$ vstest$ vsren vsorresu$; cards ; 100 base pr 78 min 100 scrn hr 72 /min 100 week1 sbp 70 mmhg 100 week7 dbp 110 mm 100 week21 weight 75 kg 100 fwp height 1...
https://communities.sas.com/t5/SAS-Programming/flag/m-p/927188#M364901
I need to define column width to standardize the look of the report. However, when I set the column width it automatically expands the row height for each cell. I tried setting the cellheight...
Hello Wondering if anybody has configured oracle Wallet on SAS Viya 4 on AWS using instant client basic ? If yes can you please share your experience?
https://communities.sas.com/t5/SAS-Viya/Oracle-Wallet-on-SAS-Viya-4-POC-on-AWS/m-p/927179#M2364
data two; input name $ qtr amount; datalines; adam 1 10 adam 2 20 adam 3 30 adam 4 40 ; run; Need a code to produce below output using array and not proc transpose output must be : ...
https://communities.sas.com/t5/SAS-Programming/Transpose-using-Arrays/m-p/927175#M364894
Hello community, I wanted to ask you if there is a way to read the rows from a csv file if starts with a specific string. For example in this csv I want just the rows that starts wi...