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 maximum number of rows and cols can be handled in SAS?
Briefly explain input and put function?
What are symget and symput? : sas-macro
where to use sas business intelligence? : Sas-bi
Describe the function and untility of the most difficult SAS macro that you have written.
Explain what is SAS informats?
explain the function of substr in sas? : Sas-administrator
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
Do you need to rearrange the order of the data for the report?
Mention what is the difference between nodupkey and nodup options?
what is sas business intelligence? : Sas-bi
What are the automatic variables for macro? : sas-macro
what is the difference between floor and ceil functions in sas? : Sas-administrator
Explain the purpose of substr functions in sas programming.
what is the use of sas management console? : Sas-di