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.
data test; input id fname $4. lname $5. age; cards; 123 abc1 def1 24 124 abc2 def2 25 125 abc3 def3 26 ; run;
data test2; input id state $7. county $9. ; cards; 123 state1 county1 124 state2 county2 125 state3 county3 ; run;
options orientation=landscape; ods pdf file="location\name.pdf"; Title1 "Test"; ods proclabel='';
proc report data=test contents='' headline nowindows ;by id ; columns id fname lname age; run;
proc report data=test2 contents='' headline nowindows ;by id ; columns id state county; run;
ods pdf close;
Iam looking only one table of contnets for both tables on left side ? is there any i can do and get the ouput ?
... 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
Hello, I am analyzing data for a project. Unfortunately, the data was provided in tables in PDF documents. We imported the PDF tables into Excel and some of the data split into multiple rows. We then read the data into SAS for analysis. Is there a way in SAS to combine data in different rows without a linking ID (the linking ID itself is split). I've attached a sample of fake data below that has the same structural issues I am looking to resolve. Each row should start with "Initiating Action:" - any data in a row that does not have this needs to be combined with the row above it. Any recommendations for how I should proceed with cleaning this are much appreciated.
What I have:
Event Type
ID
Case Type
Initiating Action: Pet
X-000-CV-2024-
Admin
0123
Initiating Action:
X-000-CV-2024-
Contract &
Complaint
4432
Debts
Initiating Action: Pet
X-000-CV-2022-
Admin
0681
Initiating Action:
X-000-CV-2023
Miscellaneous
Complaint
0873
Issue
What it needs to look like:
Event Type
ID
Case Type
Initiating Action: Pet
X-000-CV-2024-0123
Admin
Initiating Action: Complaint
X-000-CV-2024-4432
Contract & Debts
Initiating Action: Pet
X-000-CV-2022-0681
Admin
Initiating Action: Complaint
X-000-CV-2023-0873
Miscellaneous issue
... View more
I am using proc template to generate this kind of graph. What is the option available to auto move the text inside the bars so that it wont collide with error bar graph line. Thank you.
... View more
Hi all, I have a test data with missing values and I want to fill the table by taking previous month's value. Test data ID response date 1 CR 02Jan2020 2 PR . 3 NE 04Jan2020 4 SD . 5 PR 05Jan2020 6 CR . data I want to have ID response date 1 CR 02Jan2020 2 PR 02Jan2020 3 NE 04Jan2020 4 SD 02Jan2020 5 PR 05Jan2020 6 CR 05Jan2020 So, if the response NE, then I don't want to retain the NE date but the date before NE. But if the response is not NE, then I wanna retain the previous date. I tried multiple ways, but couldn't figure it out. Please help.
... View more