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
Give an example where SAS fails to convert character value to numeric value automatically?
Mention common programming errors committed in sas ?
what are _numeric_ and _character_ and what do they do? : Sas programming
what is snowflake schema? : Sas-di
explain the difference between proc means and proc summary?
: and & modifiers.
What is the basic syntax style in SAS?
What are all the problems you faced while validating tables and reports?
In proc transpose and data step with arrays which one you pick?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What are the difference between ceil and floor functions in sas?
List out some key concept of SAS
describe about physical data integration? : Sas-di
What are the data types in sas?
what is sas olap server? : Sas-di