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
explain the function of substr in sas? : Sas-administrator
How long can a macro variable be? A token? : sas-macro
how do you want missing values handled? : Sas programming
Which command is used to save logs in the external file?
What is a pdv and what are its functions?
Explain proc sort?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
What is the difference between input and infile statement?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How would you define the end of a macro?
Explain how merging helps to combine data sets.
what is factor analysis? : Sas-administrator
what is operational data and operational system? : Sas-di
What system options would you use to help debug a macro? : sas-macro
what is business intelligence? : Sas-bi