Hey everyone. I'm having an issue with the sum() function in SAS. I'd like to know why the following two codes result in different output: PROC SQL NOPRINT;   CREATE TABLE cap1 AS     SELECT var1                                                ,            var2                                            ,            var3                                             ,            sum(var4) as sum_var4 ,            sum(var5)  as sum_var5,            sum(var6)    as sum_var6     FROM   work.table1     WHERE  var7 > 0   GROUP BY var1, var2, var3; QUIT; DATA cap;   SET work.table1(KEEP=var1 var2 var3 var4 var5 var6 var7);   BY  var1 var2 var3;   WHERE var7 > 0;   sum_var4 = sum(var4);   sum_var5 = sum(var5);   sum_var6 = sum(var6); RUN; Not only would I like to know why it's different, but also which changes need to be made to the DATA step in order to duplicate the SQL output. Many thanks! ... View more

Hey guys, Ya'll have been so helpful! Here's another question I have. I have a data set with seven columns (variables). However, two of these columns represent the same variable, but they have different values. For instance: Var1 Var2 Var3 Var4a Var4b Var5 Var6 1 a y 1515 2323 orange $500 2 b n 2626 3434 blue $600 3 c y 3737 4545 green $700 4 d n 4848 5656 red $800 Var4a and Var4b are the columns in question. All column attributes above correspond to the values in Var4a (ie, the values of 1, a, y, orange, and $500 correspond to 1515 in Var4a). But I guess that's not too terribly important. What I'd like to do is take Var4a and stack it on top of Var4b, and get something like this: Var1 Var2 Var3 Var4 Var5 Var6 1 a y 1515 orange $500 2 b n 2626 blue $600 3 c y 3737 green $700 4 d n 4848 red $800 . . . 2323 . . . . . 3434 . . . . . 4545 . . . . . 5656 . . Is there any simple way to do this, or is it some long convoluted mess of transposes and left joins and sorcery? Thanks! ... View more

Hey guys. I'm looking to replace missing values in a table with zero. I have written the attached code. What confuses me is that the first part of the program works, where it replaces missing msd11 values. After that, however, nothing is replaced. For the life of me I can't figure out why. I've used different indexes (j, k, l, etc). I've tried splitting them all up into different data steps. Nothing works for me. The last thing I checked was to indeed make sure that these are the variable names, and they are. As listed, the variables I'm trying to change are: msd1101 through msd1112 (this is the one that works) qsd111 through qsd114 ssd20111 through ssd20112 a_msd1101 through a_msd1112 a_qsd111 through a_qsd114 a_ssd20111 through a_ssd20112 Edit: I have written a simpler code which replaces all missing values with zero (per SAS documentation), but I just want to know why this one isn't working. ... View more

Hey guys, Thanks for your help on my last question. My next question is this: I have a string of numbers (length = 200). Every 10 numbers is a value for a certain variable. What I'd like to do is create 20 separate variables of length 10 -- like var1, var2, ... , var20. These aren't the only variables being made. I have several others already specified, and the variables represent raw data from a flat file. How would I do this? ... View more