Hi everyone,   I'm facing a problem that I can't resolve in one step. So I would like to output the sum of volume for each year with using by statement. However I can't do that because the variable year doesn't exist in the input set. I know I can do it in 2 step but I don't want to because with the real database I'm using it will be too heavy.      Data have; format date ddmmyy8.; Date="01mar2015"d; duration=24; Volume=10; run; Data want; set have; by year; retain Volume_cumul 0; Volume_cumul=Volume; do i=0 to Duration; Year=year(intnx('month',date,i,'s')); Month=month(intnx('month',date,i,'s')); Volume_cumul=Volume_cumul+1; if last.year=1 then output; end; run; Thx for your help       ... View more

Hi, I'd like to simplify my function by using only 1 array name so I can avoid to use an 'if then' statement at the end:   /*Get Tarif Paramaters*/ proc fcmp outlib=mydata.functions.func; function Get_Parameter(Product $, Sex,Smoker,Type_Tariff); /* Sex = 1 or 2, Smoker =1 or 2 , Type_Tariff= 1 or 2 */ if Product="A" then do; array f[2,2,2] (4 3, 2 1, 8 7, 6 5); end; else if Product="B" then do; array q[2,2,2] (-4 -3, -2 -1, -8 -7, -6 -5); end; if Product="A" then return ( f[Sex,Smoker,Type_Tariff]); else if Product="B" then return ( q[Sex,Smoker,Type_Tariff]); endsub; Data paramater; do product= "A" ,"B"; do Sex=1 to 2; do Smoker=1 to 2; do Type_Tariff=1 to 2; a=Get_Parameter(product,Sex,Smoker,Type_Tariff); output; end; end; end; end; run; This is what I want but it doesn't work because I can't have the same array name for 2 different vectors.   /*Get Tarif Paramaters*/ proc fcmp outlib=mydata.functions.func; function Get_Parameter(Product $, Sex,Smoker,Type_Tariff); /* Sex = 1 or 2, Smoker =1 or 2 , Type_Tariff= 1 or 2 */ if Product="A" then do; array f[2,2,2] (4 3, 2 1, 8 7, 6 5); end; else if Product="B" then do; array f[2,2,2] (-4 -3, -2 -1, -8 -7, -6 -5); end; return ( f[Sex,Smoker,Type_Tariff]); endsub; Data paramater; do product= "A" ,"B"; do Sex=1 to 2; do Smoker=1 to 2; do Type_Tariff=1 to 2; a=Get_Parameter(product,Sex,Smoker,Type_Tariff); output; end; end; end; end; run; thank u for ur help ... View more

Hi everyone,   I'd like to create a function where I assign a value depending on the parameters of the function as such: proc fcmp outlib=mydata.functions.func; function Lx(Age,Sex); Lx(1,1)=100; Lx(2,1)=99; Lx(3,1)=97; /* . . . */ Lx(1,2)=99; Lx(2,2)=95; Lx(3,2)=82; /* . . . */ return(Lx); endsub;  Unfortunately it doesn't work at all 😁. I can use "If then Statement " to achieve what I want like shown below, but I would like to learn a different way to get it.   proc fcmp outlib=mydata.functions.func; function Lx(Age,Sex); if sex=1 then do; if age = 1 then Lx=100; else if age=2 then Lx=99; else if age=3 then Lx=97; /* . . . */ end; else if sex=2 then do; if age = 1 then Lx=99; else if age=2 then Lx=95; else if age=3 then Lx=82; /* . . . */ end; return(Lx); endsub; If someone has any clue on how to achieve this , it'd be awesome to share the solution.   Thank u all     ... View more