Hi for one of my problem, I would need to have total sum of the account for example, I have a dataset like this: ID      Bill 1        25 1         35 1        25 2      11 2        23 4        2 4        1 4         3 Can we have BIll_sum, a third variable totalling by ID like this: ID      Bill      Bill_sum 1        25         85 1         35         85 1        25          85 2      11             34 2        23           34 4        2             6 4        1             6 4         3           6 Thanks  a lot ... View more

Hi All If we have two set of data let's say A and B. Both of them contains the list of ID. I would like to select list of accounts in A which are in B To do so, I can write sql query like this: Proc sql; Create Table temp as    Select acct from      A      where acct in ( Select acc from B); quit; The problem is now, I do have an existing sas script which I need to modify  where large number of nested conditions are specified in datasteps. How can I apply this condition in same Datastep. 1 possibility is to have all the list of accounts in B as in macro variable and can apply where acct in (&acc_list) but this will not suffice in my case since the number of accounts are in millions and macro variable value has some limitations. Any suggestions. ... View more

Hi All I work on banking data of customers and need to create a datamart for different purposes. we read data from different sources and it might not be properly cleaned and inserted with accuracy. I derive variables as well from existing one. My question is related to reading data in a way that makes it most accurate. For example using upcase function while reading variables with possibility of upcase or lowcase input for deriving variables. what would be your recommendations? ... View more