what is the use of proc sql?
- 5 Answers
- 15306 Views
- CitiGroup, I also Faced
- E-Mail Answers
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 |
What are _numeric_ and _character_ and what do they do?
Write a SAS macro to calculate number of numbers in an email address
if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually
What is Linear Regression?
If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
how do you debug and test your sas programs? : Sas programming
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help
what are the considerations when picking a SAS/STAT procedure?
0 Answers Accenture, Quintiles,
how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
Teradata 
