Hello,   As explicit as my problem may sound haha, it's been really annoying as I'm new to SAS. Basically I have a dataset with different types of observations (call them "main" and "sub"), then I have the amount it costs, the transaction id and sub-id. So for example, we've got: type           cost         id            sub-id main          10           123              1 sub             5            123               2   What I want is this   type           cost         id            sub-id      sub-cost main          10           123              1             5   Note that there can be more than one pair of main/sub for one id... and sometimes mains are alone but subs are always with a main... Thnkassss ... View more

Hello,   I have a dataset with observations that need to be merged so that obs1 and obs2 are together, obs3 and obs4 together etc etc. Each observation has a two numbers, the "family" id and the sub id. For example:   have data: family     sub     val1     val2 123        1          15        0 123        2           0         12   wanted data: family    sub    val1     val2 123        1          15        12   Basically observations need to be brought back to the first. They always come in pairs, so my idea was checking sub % 2 if you get what I mean, but I don"t know how to proceed.  Note that each family can have more than two lines, it can go up to 4 and they don't always have a 2nd observation alongside it. The only indicator that says that they need to be combined is that val2 is different than 0. Here's the SAS code for the have and want data: data have; input num_fam num_sub val1 val2; cards; 123 1 75 0 123 2 0 12 124 1 14 0 124 2 0 5 125 1 10 0 125 2 0 10 125 3 16 0 125 4 0 10 126 1 14 0 ; run; data want; input num_fam num_sub val1 val2; cards; 123 1 75 12 124 1 14 5 125 1 10 10 125 3 16 10 126 1 14 0 ; run; ... View more

Hello, I'm facing a problem with a percentage. Basically, I'm doing a PROC tabulate with multiple variable for which I need the individual percentage (colpctsum). Only problem: one of the columns has all the values to 0 which means I have all the values of the percentage column set to '.' I need to add this value to another one later on which just isn't possible when it's set to '.' Any solution, like a force format or something?   Thanks in advance! ... View more