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 ?
Can you explain in more detail? I'm not familiar with the terminology you're using.
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 ?
Sorry, I'm not familiar with SAS Studio tasks. Perhaps examining the code may help.
Good Luck.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.