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 For reference it doesn't look like there is a false statement in the iif statements so I am expecting that false in this case would report as missing, but I could be wrong. Converts to proc sql; create table ??? as select ID, (sum(Case when dataset1.var1 = 0 then 0 when dataset1.var2 = 0 then 1 else . end), (case when dataset1.var1=. then 0 when dataset1.var2 = . then 0 else . end), (case when (abs(dataset1.var1/dataset1.var2)) >=1 then 1  else (abs(dataset1.var1/dataset1.var2)) end)) format=(whatever the "Fixed" format is) as score from dataset1 group by ID; quit; The question though that I would need answered before figuring anything else out would be should var1 and var2 be evaluated separately, ie should you be asking if var1 = 1 then 1 else if var1 = 0 then 0 else if var1 = . then 0 or do you want to include both in each of the statements? The easiest way to rewrite this is to say what each of the conditions are (as I understand them) if dataset1.var1 = 0 then 0 if dataset1.var2 = 0 then 1 if dataset1.var1 = . then 0 if dataset1.var2 = . then 0 if abs(dataset1.var1/dataset1.var2) >= 1 then 1 if abs(dataset1.var1/dataset1.var2) < 1 then abs(dataset1.var1/dataset1.var2) write a case statement for each of these (similar to what I wrote earlier including the else (value) end statements), put a sum statement outside of all of the case statements, and group by the unique ID. This should give you the same report values as long as you specify the variables in the same way. ... View more

First, is there a spcific reason to involve SAS in this process? Second, there is SFTP access method for the FILENAME statement, don't know it will support your requirements, or if it's easier debug. But then you don't need to call external scripts from within SAS. ... View more

Thanks Snoopy for your reply. I just realized that i do not have winscp installed in my system. So, I think i can't  download the file from the ftp server. I think this could be the blocker. The other thing is like you said i am trying to login to the sftp server from CMD in the following way. sftp username@ipaddress it prompted me to enter the password and i entered the password But it says Permission denied<publickey, keyboard-interactive> along with a popup mesaage which says "SSH error occured, please contact administrator". Snoopy, since you checked my code in %sysexec, do you think the sytax is correct. The purpose is i am trying to download a file from the ftp server into my dest path. is the get command correct? if yest then i will try to install winscp and then i will try to run it and see how it goes. The other important thing is the username and password that i am using are not mine, my team member provided his details for me to complete this task. I don't know how this affects. In my code, in the ftp.txt, do i have to add the port(22) also to the server at the end.? If you provide some clarification on my questions, it would really make me understand the whole process. Thanks again. Eshan ... View more

Hi Reeza, In the second and third workbook will have graphs. ... View more

Well it did not work for me. After some long conversations with tech support it was determined that sasauth does not have a session hook, and can only use modules that are in the auth or account portions of PAM. There ARE some auth modules that make directories, but they are add-ins. the default ones do not. In the end I made some shell code and put it in sasenv which accomplished the same thing more or less. ... View more