hi all i have a name column where there are names of people who have opened a account in the respective bank.i would like to add a column where if people have added two names separated by comma or & to recognise them as joint account holders please guide me to do this in sas dataflux
... View more
Im having a query dataset test consists of a numeric variable X X ---------- 1 1 1 2 1 1 2 2 3 3 4 when ever sas reads the first value of X a new variable Y should contain the same value. Then again if the 2nd observation is same as first observation value of Y should increment accordingly If a value is not as not the previous one eg if X=2 is encountered then Y value should again start from 1 and increment by 1 accordingly. the process should go on till end of file. Output table should look like ----------------------------------- X Y ----------------------------------- 1 1 1 2 1 3 2 1 1 4 1 5 2 2 2 3 3 1 3 2 4 1 kindly help me to write a sas code in this
... View more
Im having a query dataset test consists of a numeric variable X X ---------- 1 1 1 2 1 1 2 2 3 3 4 when ever sas reads the first value of X a new variable Y should contain the same value. Then again if the 2nd observation is same as first observation value of Y should increment accordingly If a value is not as not the previous one eg if X=2 is encountered then Y value should again start from 1 and increment by 1 accordingly. the process should go on till end of file. Output table should look like ----------------------------------- X Y ----------------------------------- 1 1 1 2 1 3 2 1 1 4 1 5 2 2 2 3 3 1 3 2 4 1 kindly help me to write a sas code in this
... View more
Hi, Is there any pdf or sas book to reference for sas dataflux data management studio for a beginner as to how to create jobs,various options available in it etc. Thanks in advance Regards, Snehal Rao
... View more
