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
What is the maximum length of the macro variable?
Describe the ways in which you can create a macro variable?
what is data integration? : Sas-di
Enlist the syntax rules followed in sas statements.
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
Do you need to rearrange the order of the data for the report?
how to read the variables in sas? : Sas-administrator
describe about metadata object? : Sas-di
Which statement does not perform automatic conversions in comparisons?
In ARRAY processing, what does the DIM function do?
how sas deals with business intelligence? : Sas-bi
Do you know the features of sas?
what are sas bi dashboard components? : Sas-bi
Mention how to limit decimal places for the variable using proc means?
how do you want missing values handled? : Sas programming