Hi there I am trying to move a process that runs in Access database and creates a couple of reports and now i am trying to change that process into SAS. I've read all the tables from Access Database that these reports use into SAS and also extracted the underlying queries from Access into SAS and making changes to the code to SAS compatible. I've around 6 to 7 SQL queries and in those, i've come across the following statments and I am not sure about how to convert into SAS so really need some help out here. The reports are monthly and weekly and they are trying to create some scores based on two variables for each id within the time period. 1. Format(Sum(Val(IIf([dataset1].[Var1]=0,0,IIf([dataset1].[var2]=0,1,IIf([dataset1].[var1] Is Null Or [dataset1].[var2] Is Null,0,IIf(Abs([dataset1].[var1]/[dataset1].[var2])>=1,1, IIf(Abs([dataset1].[var1]/[dataset1].[var2])<1,Abs([dataset1].[var1]/[dataset1].[var2])))))))),"Fixed") AS SCORE 2. Sum(Val(IIf([dataset1].[var1]=0,0,IIf([dataset1].[var2]=0,1,IIf([dataset1].[var1] Is Null Or [dataset1].[var2] Is Null,0, IIf(Abs([dataset1].[var1]/[dataset1].[var2])>=1,1,IIf(Abs([dataset1].[var1]/[dataset1].[var2])<1,0))))))) AS COUNT 3. Format(Sum(CDbl([dataset2].score)),"Fixed") AS SCORE Thanks Eshan
... View more