Answer Posted / venkatesh.layam
proc sql is sql in sas.
with proc sql,we can do many more tasks.
-retrive the data from tables,from data bases
-merge the datasets or tables.
-by using different joins we can combine the data as per
our convinience
-we can create the data ,modify the data
-we can have the discriptive statistics also
-we can sort the data with out using proc sort,just use
order by .
these many tasks can do with in single programme
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Differentiate between sas functions and sas procedures.
why is sas considered self-documenting? : Sas programming
What are the prime responsibilities of data integration administrator? : Sas-di
how does sas handle missing values in assignment statements? : Sas programming
What are the difference between the sas data step and sas procs?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what can you learn from the sas log when debugging? : Sas programming
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
what is hierarchy flattening? : Sas-di
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Explain proc sort?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Give some examples where proc report’s defaults are same as proc print’s defaults?
