Answer / venkatesh.layam

the first and foremost thing is sas is user friendly
in other datawarehouse there have two tools seperatly
like ETL and reporting tools
>bt in sas both are integrated sas it selt etl and any how
we are producing the reports by using different statements
in ETL is we are impoting the or extracting the data from
desperate sources thst is called extarction
transformation:we are assigning the formats and derriving
the varible from one form to another form
loading:after completed this work u are going to load the
data in libraries
so sas it self is a etl tool
when we come to reporting by using sas
by using many functions and procedures we can generate the
different types of reports

for sas there is no need to create REPOSITORY for saving.
it takes very less time to do the reports

compare to other datawarehouse languages it is occupied
less space.

Answer / n katepalli

Accuracy and error spotting i.e sas point outs the error
location which makes easy

what is sas metadata repository? : Sas-bi

0 Answers  

---

data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.

1 Answers  

---

how to do user inputs and command line arguments in sas?

0 Answers   D&B, TCS,

---

How would you invoke a macro? : sas-macro

0 Answers  

---

how many data types in sas? : Sas-administrator

1 Answers  

---

if we dont want to print output what we have to do..???give syntax..???

8 Answers   Accenture, GSK GlaxoSmithKline,

---

what is _error_?

2 Answers   Axis Bank, Cognizant, JPMorgan Chase,

---

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,

---

Describe the function and untility of the most difficult SAS macro that you have written.

0 Answers  

---

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 Answers  

---

Identify statements whose placement in the DATA step is critical.

6 Answers   Accenture, Labasol,

---

Name statements that function at both compile and execution time?

1 Answers  

---