Hi,   i would like to ask if i have two users login to system and each running programs, they can't see each dataset supposely, how about if they login with same account ?       Thanks ... View more

Hi Gurus,   In oracle and sqlserver environment, after extract tables with where (FACT Table filter out unwant data) as SAS7DAT in Work folder    then If i have a 8 SAS7dat,  A B C D E F G H , A = E ( Fact Table , same columns and data type , only different is data)                                                               B = F (Ref table, same columns and data type , only different is data)                                                               C = G (Ref table, same columns and data type , only different is data)                                                               D = H (Ref table, same columns and data type , only different is data)   Would you rather    (i)                               A join B join C join D                                 E join F join G join H   first,                               then union join both dataset                       or (ii)                             A Union E,  B Union F , C union G, D union H then                             AE Join BF join CG join DH   when considering performance issue         ... View more