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.
I am creating a bar plot but would like to have the data labels inside the bars at the bottom. Here is my code so far. Thanks! PS. Also - when I insert the sas code here, how do I make it look like the original sas code (colors)? 🙂 data test;
input id group var;
cards;
1 1 2.236
2 1 4.569
3 2 3.694
4 2 1.256
;
proc sgplot data=test;
vbar group / response=var stat=mean datalabel group=group fillattrs=(color=royalblue) DATALABELATTRS=(size=14);
xaxis display=(noline noticks) labelattrs=(size=16) valueattrs=(size=16) ;
yaxis display=(noline) labelattrs=(size=16) valueattrs=(size=16);
keylegend / noborder location=outside position=bottom valueattrs=(size=12);
format var 6.2;
title height=16pt 'var by group';
run;
quit;
... View more
I am trying to create a variable that will indicate if both LDOS and FDOS are :
after span_end_2
and before after_cutoff_2
and before span_end_3.
The issue I have is that in most cases, span_end_3 is blank/. in which case the current code I have below will treat LDOS and FDOS as > span_end_3. I need to fix my code so sas will treat LDOS and FDOS as < span_end_3 when span_end_3 is blank. Is there a way to do this?
data have;
input
ID$ LDOS :DATE9. FDOS :DATE9. Span_Begin_1 :DATE9. Span_End_1 :DATE9. Span_Begin_2 :DATE9.
Span_End_2 :DATE9. Span_Begin_3 :DATE9. Span_End_3 :DATE9. after_cutoff_2 :DATE9. ;
format FDOS MMDDYY10. LDOS MMDDYY10. Span_Begin_1 MMDDYY10. Span_End_1 MMDDYY10. Span_Begin_2 MMDDYY10.
Span_End_2 MMDDYY10. Span_Begin_3 MMDDYY10. after_cutoff_2 MMDDYY10.;
datalines;
5 20Apr2023 20Apr2023 1Jul2022 29Jul2022 21Nov2022 4Apr2023 . . 3Apr2024
5 24Apr2023 24Apr2023 1Jul2022 29Jul2022 21Nov2022 4Apr2023 . . 3Apr2024
5 25Apr2023 25Apr2023 1Jul2022 29Jul2022 21Nov2022 4Apr2023 . . 3Apr2024
5 1May2023 1May2023 1Jul2022 29Jul2022 21Nov2022 4Apr2023 . . 3Apr2024
;;;
run;
data want;
set have;
if LDOS gt Span_end_2
and FDOS gt Span_end_2
and LDOS lt after_cutoff_2
and FDOS lt after_cutoff_2
and LDOS lt Span_end_3
and FDOS lt Span_end_3
then After_Span2=1;
else After_Span2=0;
run;
... View more
It takes all kinds of minds on a team – people with diverse backgrounds and skill levels – to do amazing things. If you are looking to join a team, let’s find you a group. Or maybe your team needs more hackers. If so, please follow these steps:
STEP 1. Reply to this post with your search criteria. Include the follow details:
“I’m looking for a team.” or “I’m looking for a team member.”
Track name
Skills
Your LinkedIn and/or GitHub profile (if applicable)
Here’s an example:
Interest: I’m looking for a team
Track: Energy
Skills: SAS Viya
Social: https://www.linkedin.com/in/christine-brown-47425316/
STEP 2. Create your replies following this order to maintain consistency in the thread.
STEP 3. Contact a potential new teammate using the SAS Support Communities' private messaging feature to discuss if a team or member is a good fit.
STEP 4. You need to be a member of a team in order to Register.
STEP 5: If you have any edits to your team after you Register, send an email to sashackathon@sas.com. The Event Team needs to know about any changes to your team and members. Also, don’t forget to update your team profile on the SAS Hacker's Hub.
Happy hacking!
... View more
%let YTD_START = %sysfunc(intnx(year.11, &LASTFRI, 0),yymmdd10.);
this above gives me YTD_START='2023-11-01' beginning of fiscal year but when i am trying to get the date 6 months prior to fiscal year (below)
%let back_6months= %sysfunc(intnx(month,&YTD_START,-6),yymmdd10.);
i am getting back_6months=1965-01-01. What do i have wrong here?
... 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