Customizing a Workflow in SAS Solution for IFRS 17
Recent Library Articles
Recently in the SAS Community Library: SAS' @sunilbhardwaj details steps to add a customized Excel based workflow template to the SAS solution for IFRS 17. These steps enable you to try out and test several customized workflows based on your requirements.
Hi guys,
suppose to have the following:
data DB;
input ID :$20. Admission :date09. Discharge :date09. Index Morbidity1 Morbidity2 Morbidity3 Morbidity4;
cards;
0001 13JAN2017 25JAN2017 1 1 0 1 0
0001 13JAN2017 25JAN2017 1 1 0 1 0
0001 22FEB2017 03MAR2017 0 0 1 0 0
0001 30JAN2019 04MAR2019 0 1 0 0 0
0002 01DEC2018 14DEC2018 0 1 0 1 0
0002 25DEC2018 02JAN2019 1 0 0 1 0
0002 25NOV2020 03DEC2020 0 1 1 1 1
0003 09JAN2016 25JAN2016 1 0 0 1 0
0003 29JAN2018 12FEB2018 0 0 0 1 1
...;
Is there a way to get the following?
data DB1;
input ID :$20. Admission :date09. Discharge :date09. Index Morbidity1 Morbidity2 Morbidity3 Morbidity4;
cards;
0001 13JAN2017 25JAN2017 1 1 0 1 0
0001 13JAN2017 25JAN2017 1 1 0 1 0
0001 22FEB2017 03MAR2017 0 0 0 0 0
0001 30JAN2019 04MAR2019 0 0 0 0 0
0002 01DEC2018 14DEC2018 0 1 0 1 0
0002 25DEC2018 02JAN2019 1 0 0 1 0
0002 25NOV2020 03DEC2020 0 0 0 0 0
0003 09JAN2016 25JAN2016 1 0 0 1 0
0003 29JAN2018 12FEB2018 0 0 0 0 0
...;
In other words if morbidity* occurs before or at Index = 1 then nothing happens, otherwise if Morbidity* happens after Index = 1 (meaning after the date where Index = 1) all values in Morbidity* columns should be set = 0. So, all "1s" will become 0.
Note that each patient has only one chance that Index = 1. In the reported example, pts 0001 has 2 records where Index = 1 but the date is the same. This could happen. Replicated rows are present because there are other variables not shown here. Finally, Morbidities* are 20 variables with specific name. Here Morbidity is reported for simplicity. I can customize column names in my data.
Thank you very much for your help.
... View more
https://communities.sas.com/t5/SAS-Programming/Overlapping-drugs/m-p/930264#M365992
My query is in continuation of the above question which I posted few weeks back, I was unable to continue the same topic as it was closed. How can I know the difference between 'SGA_START' and 'start'? I am trying to merge the dataset 'want' with 'SGA2', how ever I cannot identifying the difference/no. of days between SGA_START and start dates. Can someone please help me with the code.
Thank you
... View more
Hi, I have question about SAS Stored Process.
1. Going to SAS Stored Process link "https://<myserver>/SASStoredProcess/do", we normally see the Welcome page for the SAS® Stored Process Web Application.
2. Then, Clicking on “List Available Stored Processes and Reports” , normally It should displays the following screen in which we can navigate through metadata folders to find any Stored Processes and Reports we have access to.
3. But, In our case(for all SAS user on our environment), Clicking on “List Available Stored Processes and Reports” metadata folders is coming very weird as attached below screenshot. All the list are merged each other. Note: We have noticed now, I guess it was like this during installation time itself.
4. We found one workaround to fix it, going though inspect as attached below screenshot. But when we refresh the page, it gets again again merged and we have to go through inspect.
5. Could you please suggest , the permanent fix on this, any configuration changes, may be some html/css file on server but I am not sure.
... View more
Is there a place that documents when (year or release) a function or routine was added to SAS, and when it may have been bug fixed, altered, extended or deprecated?
... View more
Hi,
I am using proc sql left join to merge my two excels on based on two mutual columns they have.
here is the code I use:
proc sql; CREATE TABLE FINALV3 AS SELECT * FROM WNPOP LEFT JOIN pop2012 ON WNPOP.State_Name_All=pop2012.State_Name_All AND WNPOP.County_Name_All=pop2012.County_Name_All; QUIT;
while the proc happened and I can see the columns joined and the number of obs are correct, I do not have values in the joined columns. (THERE IS NO ERROR in the LOG ).
any ideas of what is going wrong?
... View more