ALLInterview.com :: Home Page KalAajKal.com
 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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  SAS
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
·  What are some good SAS programming practices for 
processing very large data sets?
 Question Submitted By :: Akshara
I also faced this Question!!     Rank Answer Posted By  
 
  Re: · What are some good SAS programming practices for processing very large data sets?
Answer
# 1
Using Arrays .
 
Is This Answer Correct ?    0 Yes 0 No
Koduri
 
  Re: · What are some good SAS programming practices for processing very large data sets?
Answer
# 2
1.we can compress the dataset

2.if we wana do merge a bigdate set with another dataset 
having few variables for instance a fact with dimension 
having key variable and description column
in this case sorting n merging this bigdateset(fact) with 
dimension apply formats.so dat u can avoid sort n merge.
 
Is This Answer Correct ?    0 Yes 0 No
Vicky
 
 
 
  Re: · What are some good SAS programming practices for processing very large data sets?
Answer
# 3
Use
1.WHERE Condition
2.DROP KEEP in Set Statement
3.ARRAY
4.Mutually Exclusive Conditions like DO ,DO UNTIL,DO WHILE
 
Is This Answer Correct ?    3 Yes 0 No
Sibin
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it? Oracle1
How would you delete duplicate observations? Accenture8
what is the difference between %put and symbolgen?  5
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?  2
Approximately what date is represented by SAS date value of 730  5
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?  5
what is SAS/Access and SAS/Connect?what are the uses?  2
if x=round(26.3,10)-1 then x= how much and how explain? BoA2
How could you generate test data with no input data?  9
· What are some good SAS programming practices for processing very large data sets?  3
is there any difference between proc summary and proc means?  2
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.  2
what is the difference between proc report and proc format? CTS2
How would you combine 3 or more tables with different structures?  1
how we can create optional or required parameters in SAS macro... TCS2
what is SAS/Graph? CitiGroup1
How would you code the criteria to restrict the output to be produced? Accenture5
How do you put an elephant in the refrigerator? Oracle4
How do you add a number to a macro variable?  1
What does a PROC TRANSPOSE do? Accenture2
 
For more SAS Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com