what is OLAP?
Answers were Sorted based on User's Feedback
Answer / raju
stands for online analytical programming which is used to
summarize the data.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / sas
OLAP- stands for online analysis processing by this we can create the cube and which can be viewed and can be make change .By this we can handle huge data and can make MDX queries and in OLAP there are performance Tuning.we can view the data multi dimensionally.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vikas
OLAP stands for online analytical processingc which is used
to summarise the data.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / padmasri
In order to analyze the past and current data which can be
used for decision making we use OLAP ( Online Analytical
Programming).
Is This Answer Correct ? | 0 Yes | 0 No |
Enlist the functions performed by sas.
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
What is the basic syntax of a sas program?
Name statements that are recognized at compile time only?
How would you determine the number of missing or nonmissing values in computations?
. Which date advances a date, time or date/time value by a given interval?
When you will use nowd option in report???
How would you delete observations with duplicate keys?
Mention few ways with which a “table lookup’ is done in sas programming.
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
What are the functions done while Compilation...?
what is star schema? : Sas-di