Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of proc sql?
- 5 Answers
- 17297 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 |
Do you need to rearrange the order of the data for the report?
What is the good sas programming practices for processing large data sets?
what is slowly changing dimension? : Sas-di
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
What is the basic syntax style in SAS?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
What is the difference between order and group variable in proc report?
/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;
what are scrubing procedures in SAS?
how to generate report for 0 observation dataset?
Teradata 
