How to Create Analytical Base Table in SAS Studio

[Macy]

Hi,

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 ? 

[Reeza]

Can you explain in more detail? I'm not familiar with the terminology you're using. 

[Macy]

Hi, 

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 ? 

[Reeza]

Sorry, I'm not familiar with SAS Studio tasks. Perhaps examining the code may help. 

Good Luck.

[ballardw]

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.