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 (751)
 Cognos interview questions  Cognos Interview Questions (842)
 Informatica interview questions  Informatica Interview Questions (1623)
 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 (168)
 Data Stage interview questions  Data Stage Interview Questions (563)
 SAS interview questions  SAS Interview Questions (552)
 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 (215)
Question
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  
 
Answer
# 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;
input;
put _infile_;
run;
 
Is This Answer Correct ?    5 Yes 1 No
Durga G
 
Answer
# 2
by writing Put _all_; is the easy option to produce an
external file.
 
Is This Answer Correct ?    1 Yes 1 No
Ganesh
 
 
 
Answer
# 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;
run;
 
Is This Answer Correct ?    0 Yes 0 No
Prakash Hullathi
 
Answer
# 4

PUT _ALL_;

Eg:

DATA
_NULL_;
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

RUN;


 
Is This Answer Correct ?    0 Yes 1 No
Jothi Sankar
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
How would you combine 3 or more tables with different structures?   5
how do you derive descriptive statistics? Accenture 1
How do you put a giraffe into the refrigerator? Oracle 3
What is Transaction...? And what are Comment, Roll back n Save point..?   2
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?   1
How would you code a merge that will keep only the observations that have matches from both sets?   5
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?   7
sas macros   12
What is the order of evaluation of the comparison operators: + - * /** ()?   2
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 its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT. CTS 3
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question CitiGroup 8
what is SAS/Access and SAS/Connect?what are the uses?   3
 
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