Hi all, At https://developer.sas.com/apis/rest/v3.5/#filters there is supposed to be a link that explains filter expressions: > For a complete description of filter expres...
https://communities.sas.com/t5/SAS-Viya/Looking-for-SAS-Viya-API-doc-on-filters/m-p/927132#M2356
USING THE CODE ALREADY POSTED IN SUNFLOWER EXAMPLE. I HAVE A PROBLEM THE ESTIMATE STATEMENT OR LINE IS NOT WORKING AS IT GIVES AN ERROR "ERROR 180-322: Statement is not valid or it is used o...
Hello, I have a dataset that I need to calculate the rolling average and sum. The file is attached. What I intend to do here is to calculate rolling average/sum of variables from -380 ...
https://communities.sas.com/t5/SAS-Programming/PROC-EXPAND-wierd-output/m-p/927124#M364880
I want to Apply Tests for Special Causes in the p-chart, but the sample size for each group is different. So, I don’t have a fixed UCL and LCL, and I will get the following warning with below c...
Greetings dear members, I have a dataset of 630 patients, with just 8 events, so when I run a Cox regression with Firth correction, I have that none of the variables taken under consideration,are...
Hi, I have a SAS dataset wherein date format is incorrect and the same is to be corrected. Please help in the matter. data A; input Employee_Id $ Date Date9. ; cards; 70202028 - 04JAN2023...
https://communities.sas.com/t5/New-SAS-User/Date-Formatting-Issue/m-p/927102#M41605
WOULD U HELP ME TO CALCULATE 48 SETS OF RETURNS (2*3*2*2*2) 2 BREAKOUTS PORTFOLIO (MAX VS MIN) 3 sizes (Small vs Mid vs Big)< I HAVE DONE THE COLUMN ATTACHE...
with the following code, the chart displays a label " p-chart for yes_answer1" at the top, under the main chart title. I have two questions about that: How to remove that, i.e "p-chart for...
https://communities.sas.com/t5/Statistical-Procedures/customizing-the-P-chart/m-p/927091#M46096
I need to add a horizontal reference line at 90% to represent my target in the p-chart. When I put href=0.9 in my code I got the following warning "WARNING: Numeric href= values are incompati...
Dear Community, I am a new SAS Studio user (9.4) and am struggling with the following task. I need to merge two files. One is located in SAS WRDS Cloud (let's name it File 1), and another one...
https://communities.sas.com/t5/SAS-Programming/Merging-files-in-SAS-WRDS-Cloud/m-p/927089#M364872
Hi guys, suppose to have the following: data DB1; input ID Discharge; format Discharge date9.; cards; 0001 19JUN2017 0001 07SEP2020 0002 17MAR2016 0003 05MAY2016 0003 08...
https://communities.sas.com/t5/New-SAS-User/Identify-and-flag-the-latest-day/m-p/927084#M41602
Hi all, This one is quite frustrating. I want to return the Nth word of a string which matches (NOT case-sensitive) my 'search term'. Illustrated with example code using sashelp dataset. My cod...
Hey there, I recently learned Clinical SAS, so I want to have some online projects with the guidance of experts so that I can manifest my skills which will be helpful for my future, I would b...
https://communities.sas.com/t5/New-SAS-User/Clinical-SAS-online-projects/m-p/927037#M41592
Hi guys, how can I calculate person-years from two dates for ex: 16FEB2019 and 08JAN2020? I have two variables with around 20.000 rows in my table. Thank you in advance. Best
How may I CALCULATE THE EQUAL-WEIGHTED (EW) AND VALUE-WEIGHTED (VW) COMPOUND DAILY RETURN FOR THE SUBSEQUENT WEEK AND MONTH BEGINNING THE DAY AFTER A FIRM IS ASSIGNED TO THE MAX, MIN, OR COMPARI...
Hi guys, suppose to have the following: data DB1; input ID Index_date Code Admission Discharge Status Date; format Admission Discharge date9.; cards; 0001 1 49121 11...
Hi, I have a dataset where the year goes from where I have these countries: Spain, France, Denmark and European Union and let's say two colomns; company='A' and 'B' and value='dollar' �...
thx! How to create a column which is market value of last month DM'LOG; CLEAR; OUT; CLEAR; ODSRESULTS; CLEAR;'; %LET FOLDER=%STR(C:USERSALAINONEDRIVE桌面HIGH); LIBNAME HIGH "&FOLDER...
Hi I'm trying to calculate outliners within a datset trying: proc sql; SELECT CASE WHEN a.row_num <= ceil(0.25 * b.total_rows) THEN 1 WHEN a.row_num <= ceil(0.5 * b.total_rows) THEN 2 WHE...
How to make the firm(PERMNO) not classified into Minhttps://drive.google.com/file/d/1grx_6p-yVMVzrzvVjdtfwyFUjRpq10W6/view?usp=sharing again within one month? Thx! data MK (drop=_:); se...