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 (183)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (851)
 Informatica interview questions  Informatica Interview Questions (1624)
 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 (564)
 SAS interview questions  SAS Interview Questions (556)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 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
 
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?   6
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT D&B 8
What are the functions done while Compilation...? TCS 1
what are the differences between proc report and proc tabulate?   3
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ? HP 7
how can you get the single data set from the library(which has the number of data sets)? Accenture 2
How do you read in the variables that you need?   5
Code a PROC MEANS that shows both summed and averaged output of the data.   5
What is the order of evaluation of the comparison && logical && relational operators:? CitiGroup 2
IS SAS COMPILER OR INTERPRETER? EXPLAIN? HSBC 3
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.   2
What is difference between (a-z) and (a--z) Accenture 6
 
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