topic Re: How to Create Analytical Base Table in SAS Studio in SAS Studio

How to Create Analytical Base Table in SAS Studio

Macy — Sun, 27 Nov 2016 20:23:49 GMT

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 ?

Re: How to Create Analytical Base Table in SAS Studio

Reeza — Sun, 27 Nov 2016 22:01:42 GMT

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

Re: How to Create Analytical Base Table in SAS Studio

Macy — Sun, 27 Nov 2016 22:10:14 GMT

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 ?

Re: How to Create Analytical Base Table in SAS Studio

Reeza — Mon, 28 Nov 2016 00:17:46 GMT

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

Good Luck.

Re: How to Create Analytical Base Table in SAS Studio

ballardw — Mon, 28 Nov 2016 15:52:15 GMT

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.