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  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
 Categories  >>  Software  >>  Data Warehouse  >>  SAS       
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
How would you code a merge that will keep only the observations that have matches from both sets. Accenture  5  1592
How would you delete observations with duplicate keys? Accenture  11  3838
How would you delete duplicate observations? Accenture   8  5685
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables. Accenture  5  1645
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable? Accenture  9  1521
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc? Accenture  2  967
How would you include common or reuse code to be processed along with your statements? Accenture  3  954
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself. Accenture  2  990
What is the one statement to set the criteria of data that can be coded in any step? Accenture   3  776
If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set? Accenture  4  1150
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? Accenture  3  984
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file? Accenture  1  1134
Under what circumstances would you code a SELECT construct instead of IF statements? Accenture  5  1261
What is the purpose of the trailing @? The @@? How would you use them? Accenture  8  1963
How would you code the criteria to restrict the output to be produced? Accenture  5  1170
E-Mail New Answers        Answer Selected Questions        Post New SAS Question
 
Prev    1   ... 3   ... 5   ... 7   ... 9    10   [11]    12  ... 13   ... 15   ... 17   ... 19   ... 21    Next
 
 
 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
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
What would you change about your job? 163 Oracle
what r the job openings SAS for fresher graduates ! 195 TetraSoft
What was the last computer book you purchased? Why? 179 Oracle
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is?? 192 Oracle
Tell e how how dealt with.. 105  
Are you involved in writing the inferential analysis plan? Tables specfications? 159  
Give e an example of.. 87  
What is a macro routine? 303  
Tell e how how dealt with.. 100 Wipro
Give e an example of.. 92  
Describe a time when you were really stuck on a problem and how you solved it? 128  
If money were no object, what would you like to do? 176 Oracle
Are you involved in writing the inferential analysis plan? Tables specfications? 227 Wipro
Are you involved in writing the inferential analysis plan? Tables specifications? 213 Oracle
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also. 221  
what is PhaseIII, ODS, TLG, Macro and Proc in SAS 45  
Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX. 180  
What is the pound sign used for in the data_null_ ? 271  
Describe a time when you were really stuck on a problem and how you solved it? 121 DELL
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE? 287 HCL
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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