what is the use of proc sql?
Answers were Sorted based on User's Feedback
Answer / nishant
PROC SQL is a powerful tool in sas which combines the
functionality of data and proc steps. PROC SQL can sort,
summarize, subset, join (merge), and concatenate datasets,
create new variables, and print the results
or create a new dataset all in one step!
PROC SQL uses less resources when compared to that of data
and proc steps.
To join files in PROC SQL it does not require to sort the
data prior to merging which is must is data merge
Is This Answer Correct ? | 22 Yes | 1 No |
Answer / ganesh
proc sql is also useful for doing the mulitiple operations
like the sas and it is to do sum, merge, mulitiple join
operations like what we do in sas.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / 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 |
Answer / kamal shalya
PRO*C is a prograning lanuage of sql statment.with the help
of Pro*c we can do multiple task in sort of time.
such as -Updation
automation
Is This Answer Correct ? | 5 Yes | 1 No |
How to Rename Library?
what is transformation in sas data integration? : Sas-di
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
in which companies SAS openings are there? List of companies using SAS technology.
What is program data vector (pdv) and what are its functions?
What does the trace option do?
how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
What is the use of divide function?
Differentiate input and infile.
What is difference between rename and lable in sas?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration