Answer Posted / 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 |
Post New Answer View All Answers
what is data governance? : Sas-di
what type of graphs we will create(for 2+years candidates)?
why a stop statement is needed for the point= option on a set statement?
Which are the statements whose placement in the data step is critical?
Why and when do you use proc sql?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
What do the SAS log messages "numeric values have been converted to character" mean?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
Describe a time when you were really stuck on a problem and how you solved it?
what is intially documentation in sas?
State the difference between INFORMAT and FORMAT ?
: and & modifiers.
How does the internal authentication work in sas? : sas-grid-administration
What is run-group processing?
What is the use of %include statement?