Answer / kishorebabu

Fact Table
The centralized table in a star schema is called as FACT
table. A fact table typically has two types of columns:
those that contain facts and those that are foreign keys to
dimension tables. The primary key of a fact table is
usually a composite key that is made up of all of its
foreign keys.



In the real world, it is possible to have a fact table that
contains no measures or facts. These tables are called as
Factless Fact tables.

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

16 Answers  

---

If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?

6 Answers  

---

name the scheduler for scheduling job and explain the scheduler? : Sas-di

0 Answers  

---

How do you add a number to a macro variable?

3 Answers  

---

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

1 Answers   Accenture,

---

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

0 Answers  

---

What do you know about sas data set?

0 Answers  

---

what is difference in window SAS & Unix SAS.....how do define working environment in both???

1 Answers   JPMorgan Chase,

---

how to assign a macro value to a variable?

8 Answers   CitiGroup,

---

How do you read in the variables that you need?

9 Answers   Accenture,

---

Difference between nodup and nodupkey options?

0 Answers  

---

What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

3 Answers   TCS,

---