11-27-2016 03:23 PM
Does anyone know how to create analtical base table in SAS, which code shall i write in programmer ?
how can i put transforming data, combined and merge data into ABT ?
11-27-2016 05:10 PM
Never mind, this problem i have solved, but i have another one that is i tried to transform data by using LOG(X+1) to avoid any 0 value, but all of the cells are blanks, i do not know where is the problem, could you pls have a look ?
11-28-2016 10:52 AM
If you want to create a new varable based on NUM_credits you might want to use log(Num_credits +1) not X. I suspect you do not have a variable X before the transform. Your output shows X with missing values because you references a variable X, so SAS needed to create the variable with missing values. And since X was missing then the result was missing.