what is the use of proc sql?

Answers were Sorted based on User's Feedback



what is the use of proc sql?..

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

what is the use of proc sql?..

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

what is the use of proc sql?..

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

what is the use of proc sql?..

Answer / name is no need

good answers from nishant and ganesh

Is This Answer Correct ?    7 Yes 1 No

what is the use of proc sql?..

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

Post New Answer

More SAS Interview Questions

How to Rename Library?

3 Answers  


what is transformation in sas data integration? : Sas-di

0 Answers  


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?

10 Answers   Accenture,


in which companies SAS openings are there? List of companies using SAS technology.

14 Answers   MIR-IFCR, TCS,


What is program data vector (pdv) and what are its functions?

0 Answers  






What does the trace option do?

0 Answers  


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?

8 Answers   Wipro, Xansa,


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  


What is the use of divide function?

0 Answers  


Differentiate input and infile.

0 Answers  


What is difference between rename and lable in sas?

10 Answers   Satyam,


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

0 Answers  


Categories