ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> SAS
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (184)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (853)
 Informatica interview questions  Informatica Interview Questions (1626)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (172)
 Data Stage interview questions  Data Stage Interview Questions (565)
 SAS interview questions  SAS Interview Questions (561)
 Micro Strategy interview questions  Micro Strategy Interview Questions (37)
 ETL interview questions  ETL Interview Questions (196)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
Question
What is the difference between SAS Data step and SAS PROC SQL,
and which is better?
 Question Submitted By :: SAS
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
1)Syntax is different
2
3)benefit of PROC SQL is its ability to process unsorted
data and create tables in a sorted fashion
4)Performing an OUTER UNION is very similar to the DATA step
with a SET statement referencing two or more data sets
5)Establish a connection with a RDBMS a)LIBNAME in dataset
b)CONNECT DISCONNECT in proc SQL
 
Is This Answer Correct ?    0 Yes 2 No
Pallavi
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
what is the difference between DUPKEY and NODUPKEY???   3
What are the criticality that you have faced during your project in SAS?   2
describe about joins? briefly? CitiGroup 2
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15   4
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do? HCL 8
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar; HSBC 2
How would you determine how far down on a page you have printed in order to print out footnotes?   3
What statement do you code to write the record to the file?   5
How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student. Tcs 3
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS. Genzyme 4
What other SAS features do you use for error trapping and data validation?   2
Can you excute a macro within a macro? Describe.   3
 
For more SAS Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com