:: 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                      
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)
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  
# 1
1)Syntax is different
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
Is This Answer Correct ?    0 Yes 2 No

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
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  All Rights Reserved.   ::