I am using SAS Ondemand to practice some SAS Programs. When I am trying to login i am getting the following error:   Unable to connect to the current workspace server. Select a different workspace server.   The application could not connect to any server in the cluster "(odaws02-apse1.​oda.​sas.​com:​8591,​odaws01-apse1.​oda.​sas.​com:​8591)".​   Please help me to resolve this issue. ... View more

I have a dataset with the list of givers and takers present in one column and the amount that is given (the negative values) Or taken (the positive value) by them in another column. The amount deviation is such that its total sum is equals to 0. I want to create a dataset consisting of from, amount, to as variables. The selection of the members should be in sequence for from and to. Input dataset : Member Deviation Aus -2000 Br 3000 Nz -10000 In 4000 No 5000 Br  -3000.36 Nz 2000.36 In -4000.53 No 5000.53 Output dataset: From   Amount   To Aus     2000       Br Nz      1000        Br Nz      4000        In Nz      5000        No Br       2000.36   Nz Br       1000        No In        4000.53  No   Can anyone help solving it using retain and loops?   ... View more

I have a dataset with the list of givers and takers present in one column and the amount that is given (the negative values) Or taken (the positive value) by them in another column. The amount deviation is such that its total sum is equals to 0. I want to create a dataset consisting of from, amount, to as variables. The selection of the members should be in sequence for from and to. Input dataset : Member Deviation Aus -2000 Br 3000 Nz -10000 In 4000 No 5000 Output dataset: From Amount To Aus 2000 Br Nz 1000 Br Nz 4000 In Nz 5000 No ... View more