Write and run SAS programs in your web browser

How to Create Analytical Base Table in SAS Studio

Reply
Contributor
Posts: 24

How to Create Analytical Base Table in SAS Studio

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 ? 

Grand Advisor
Posts: 16,416

Re: How to Create Analytical Base Table in SAS Studio

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

Contributor
Posts: 24

Re: How to Create Analytical Base Table in SAS Studio

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 ? 

Attachment
Grand Advisor
Posts: 16,416

Re: How to Create Analytical Base Table in SAS Studio

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

 

Good Luck.

Grand Advisor
Posts: 9,748

Re: How to Create Analytical Base Table in SAS Studio

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.

Post a Question
Discussion Stats
  • 4 replies
  • 119 views
  • 0 likes
  • 3 in conversation