I have imported a series of account numbers (not the real ones showing below) but imported as text.  I have some account numbers that have a leading 0 and some account numbers are different lengths .. Below are some examples.  I need to keep this account number field as numeric with the leading 0 where it should be and with the different length as required. Example Acct_no 12345678 01234567 123456 0123456789 So they currently import as text, but I want  them to be the way they are, however converted as numeric. Thanks ... View more

Hi,  I have a whole bunch of accounts and I'm trying to find out when the first accident indicator happened from a series of clumns.  I can show better below what I mean. I have 100K accounts and each account has flag_1 .. flag_2... up to flag_13.  And there is a 0 or a 1 depending when the accident happened.  So if the first accident happened in month 1 from the observation period then flag_1 = 1, else 0.. if the accident happened from 3 months form the observation period then flag_3 = 1, else 0.  It is possible that one accont has more then 1 flag = 1, depending if they had more than 1 accident.. in total it iss possible to have13 one's.  I'm trying to count how many first 1's did it happen for flag_1, and how many first one's for flag_2, and so on to flag_13.   Thanks. ... View more

Hi.  I'm trying to link 1 field from one table to many fields form another table.  Here's what I mean.  See below the data first. Table 1 Product_code   Variable_1 V3B_A                    34 V3B_B                    67 V5T_A                    12 V5T_B                    11 Table 2 Product_code   Variable_1 V3B_1                    24 V3B_2                    87 V3B_3                    19 V5T_1                    08 V5T_2                    03 V5T_3                    24 The final result Table 3, I would like to link/merge each Product_code in Table_1 to each of the Product_codes in Table_2 if the first 3 digits are the same. Here's how the final table would look: Table 3 Product_code_1    Product_code_2     Variable_1_1    Variable_1_2 V3B_A                         V3B_1                         34                    24 V3B_A                         V3B_2                         34                    87 V3B_A                         V3B_3                         34                    19 V3B_B                         V3B_1                         67                    24 V3B_B                         V3B_2                         67                    87 V3B_B                         V3B_3                         67                    19 V5T_A                         V5T_1                         12                     08 V5T_A                         V5T_2                         12                     03 V5T_A                         V5T_3                         12                     24 V5T_B                         V5T_1                         11                     08 V5T_B                         V5T_2                         11                    03 V5T_B                         V5T_3                         11                    24 But this is just a short sample.  I actually have many product codes and many more variables.. I don't assume it should matter.  Or is it as simple as just stripping the first 3 digits from both tables and merge? Thanks. ... View more

Hi, I'm trying to verify the significance of some variables (about 25 of them) against a DV (continuous)  using proc glm.  So I have classed the vars, and included them in the model step.  I want ot see if each individually is significant against the DV.  I though the Type III error in proc glm provided that, but if I was to do them each separately, I get different p-vals than if I do them as explained above wiht a type III.  Could someonoe suggest a way to check each individually (I suppose using a macro) or an expalantion of Type III error ?  Much appreciated.  Thanks ... View more