Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of proc sql?
- 5 Answers
- 17242 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 |
how can u import .csv file in to SAS?tell Syntax?
7 Answers CitiGroup, Franklin Templeton,
What other SAS features do you use for error trapping and data validation?
How do you add a number to a macro variable? : sas-macro
What is the maximum and minimum length of macro variable
how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.
tell me about intnx, intcx functions?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
what is the diff b/w verification validation in sas
why is the use of Retrive statement and give me with example?
what is the difference between floor and ceil functions in sas? : Sas-administrator
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
Teradata 
