:: 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 (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)
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?
 Question Submitted By :: SAS
I also faced this Question!!     Answer Posted By  
# 1
DATA step copies records from the input file to the output
file without creating any SAS variables:

data _null_;
infile file-specification-1;
file file-specification-2;
put _infile_;
Is This Answer Correct ?    6 Yes 1 No
Durga G
# 2
by writing Put _all_; is the easy option to produce an
external file.
Is This Answer Correct ?    1 Yes 1 No
# 3
DATA step copies records from the input file to the output
file without creating any SAS variables:

data _null_;
/*To read the external taw data file*/
infile 'file-specification-1';
input var1 var2 $ var3;
/*To write the external raw data file*/
file 'file-specification-2';
put var1 var2 var3;
Is This Answer Correct ?    0 Yes 0 No
Prakash Hullathi
# 4



SET MYDATA; --> is got from external input file
FILE OFILE<is having output file path>;

PUT _ALL_; --> is for writing values with variables

PUT (_ALL_) (+0); --> is for writing only values


Is This Answer Correct ?    0 Yes 1 No
Jothi Sankar

Other SAS Interview Questions
  Question Asked @ Answers
how to get second highest salary from a employee table and how get a 5th highest salary from a employee table? ABC 10
. Which date advances a date, time or date/time value by a given interval?   6
How do you put a giraffe into the refrigerator? Oracle 3
What are the efficacy variables in your study? Accenture 2
Hot to suppress characters from a given string? CTS 4
Briefly describe 5 ways to do a "table lookup" in sas.   4
What is difference between Global n Local Macro Variables..? TCS 6
how we can create optional or required parameters in SAS macro... TCS 5
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
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
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? Accenture 3
differnce between 8.2 and 9.1.3   1
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.   ::