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 tried: ... sas.exe myfile.sas7bdat without success. I.e., I like to open a .sas7bdat file from the command line similar to how Windows opens SAS when double-clicking on a .sas7dbat file in Windows Explorer. Thank you.
... View more
Hello, I use an multiple imputation and I realize two tests, so I adjusted the pvalue with the bonferonni method. But, how can I have the adjusted p-value with PROC MIANALYZE ? Here my code : proc mixed data=v1_v2_im method=reml; class PRDT (ref="Placebo") TV_VISIT_TMP(ref="V1") SUBJID; model changeVn_V0 = PRDT TV_VISIT_TMP PRDT*TV_VISIT_TMP / s ddfm=kenwardroger; repeated TV_VISIT_TMP / subject=SUBJID type=CS; lsmeans PRDT*TV_VISIT_TMP / slice=TV_VISIT_TMP cl diff adjust=bon; slice PRDT*TV_VISIT_TMP / sliceby(TV_VISIT_TMP="V1") cl pdiff=control("Placebo" "V1"); slice PRDT*TV_VISIT_TMP / sliceby(TV_VISIT_TMP="V2") cl pdiff=control("Placebo" "V2"); by _Imputation_; ods output SolutionF=mixparms; ods output SliceDiffs=slice; ods output Slices=slice2; ods output Diffs=difs; run; It's in the table "Difs" that there are pvalues adjusted. But, I don't know how to use PROC MIANALYZE to pooling adjusted pvalues ? Thanks for your answer. Clémence
... View more
Hi folks, Not sure if that's the right place to ask for this, but I just identified a weird behavior of the proc sql. Let's review this piece of code: proc format;
value yn
0='No'
1='Yes'
;
run;
data ds1;
attrib pt format=$2.;
attrib question format=yn.;
pt='01'; question=0; output;
pt='02'; question=1; output;
run;
proc sql noprint;
create table test as
select pt 'Patient',
question label='Yes/no'
from ds1
;
quit; The output dataset test is as expected, in particular the variable question has format yn. and label "Yes/no" Now, let's update the code to add an union: proc format;
value yn
0='No'
1='Yes'
;
run;
data ds1;
attrib pt format=$2.;
attrib question format=yn.;
pt='01'; question=0; output;
pt='02'; question=1; output;
run;
data ds2;
attrib pt format=$2.;
attrib question format=yn.;
pt='02'; question=0; output;
pt='03'; question=1; output;
run;
proc sql noprint;
create table test as
select pt 'Patient',
question label='Yes/no' /* la label fait sauter le format */
from ds1
union corr
select pt,
question
from ds2
;
quit;
The output dataset test is NOT as expected, in particular the variable question has no format anymore, but the expected "Yes/no" label. If we remove the label modifier, the format is kept Is this behavior expected?
... View more
I've never really made friends with the import of txt files. And luckily I can handle 99% of my data intake through a DB connector with Oracle, so normally I can forget about my shortcomings.
The problem of wrongly interpreted special characters is already present in the txt file.
But it gets worse as the lines with special characters do not get assigned the correct column. It gets displaced after encountering a special character like 'ó' and the text is broken at this position.
the string which cause such behavior is:
Comunicación 1 año Comunicación 1 año
FILENAME REFFILE FILESRVC FOLDERPATH='/Projects/crm reporting/Encuestas' FILENAME='DV_Resultado_Campaña_ac.txt' encoding='wlatin1';
data as.DV_RES_CAMP;
%let _EFIERR_ = 0;
infile REFFILE delimiter='09'x dsd MISSOVER lrecl=32767 firstobs=2;
informat JourneyName $80.;
informat EmailName $100.;
informat Mes_Envio best32.;
informat num_envio best32.;
informat num_open best32.;
informat num_click best32.;
informat num_Unsubscribe best32.;
informat num_caso_renovar best32.;
informat num_caso_refinanciar best32.;
informat num_caso_pagaralvencimiento best32.;
informat num_caso_devolver best32.;
informat Num_Caso_masinfo best32.;
informat Num_Caso_QuedarseloFF best32.;
informat num_caso_Ampliar best32.;
informat num_Harbounce best32.;
informat num_Softbounce best32.;
informat click_renovar best32.;
informat click_devolver best32.;
informat click_me_lo_quedo best32.;
informat Click_Refinanciar best32.;
informat Click_PagarAlVencimiento best32.;
informat click_info best32.;
informat click_portal best32.;
informat click_baja best32.;
informat click_ampliar best32.;
informat Click_QuedarseloFF best32.;
informat click_encuesta best32.;
informat click_oferta best32.;
informat Click_ViewM best32.;
informat Marca $10.;
format JourneyName $80.;
format EmailName $100.;
format Mes_Envio best12.;
format num_envio best12.;
format num_open best12.;
format num_click best12.;
format num_Unsubscribe best12.;
format num_caso_renovar best12.;
format num_caso_refinanciar best12.;
format num_caso_pagaralvencimiento best12.;
format num_caso_devolver best12.;
format Num_Caso_masinfo best12.;
format Num_Caso_QuedarseloFF best12.;
format num_caso_Ampliar best12.;
format num_Harbounce best12.;
format num_Softbounce best12.;
format click_renovar best12.;
format click_devolver best12.;
format click_me_lo_quedo best12.;
format Click_Refinanciar best32.;
format Click_PagarAlVencimiento best32.;
format click_info best12.;
format click_portal best12.;
format click_baja best12.;
format click_ampliar best12.;
format Click_QuedarseloFF best12.;
format click_encuesta best32.;
format click_oferta best12.;
format Click_ViewM best12.;
format Marca $10.;
input
JourneyName $
EmailName $
Mes_Envio
num_envio
num_open
num_click
num_Unsubscribe
num_caso_renovar
num_caso_refinanciar
num_caso_pagaralvencimiento
num_caso_devolver
Num_Caso_masinfo
Num_Caso_QuedarseloFF
num_caso_Ampliar
num_Harbounce
num_Softbounce
click_renovar
click_devolver
click_me_lo_quedo
Click_Refinanciar
Click_PagarAlVencimiento
click_info
click_portal
click_baja
click_ampliar
Click_QuedarseloFF
click_encuesta
click_oferta
Click_ViewM
Marca $
;
if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
run;
... View more
Hi, I try to configure mail service in sas viya 4 , to be able to send mails from platform, without the code. If I want to send an email by code from a sas program the mail is sent, I used this part of code: options emailhost= ( "smtp.host.com" STARTTLS auth=LOGIN id=" mail@xxxx.xxx" pw="xxxxx" port=587 ); filename mymail email "mail@xxxx.xxx" subject="My SAS Configuration File"; data _null_; file mymail; put 'Jim,'; put 'This is my SAS configuration file.'; put 'I think you might like the'; put 'new options I added.'; run; I tried to add the same options in sas.mail, but I think the problem is that I don't know where to add the STARTTLS or auth=LOGIN . Can you help me with this problem. Thank you, George
... View more