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?
- 7 Answers
- 22498 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sumit
data _null_;
infile 'path';
input;
file 'destination path';
put _infile_;
run;
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / jim
filename indata 'c:\test_input.txt';
data _null_;
infile indata;
file 'c:\test_output.txt';
input;
put _infile_;
run;
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / sunymuny
A PUT Statement using a Variable _all_ can be used to
achieve this task. where we wont have to mention all the
variable names for output using put statement.
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / prakhar sadafal
Use the _infile_ option in the put statement
view sourceprint?
filename some 'c:cool.dat';
filename cool1 'c:cool1.dat';
data _null_;
infile some;
input some;
file cool1;
put _infile_;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / selvi
_all_ - Write all var present in Dataset including computed
variables also.
_input_- write only those variables read from input file
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / nandu
data test ;
infile "Path";
input var1 var2 var3 ;
file print 'path';
put @1 var1 @10 var2 ;
run;
| Is This Answer Correct ? | 0 Yes | 5 No |
In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
What are the ways in which macro variables can be created in sas programming?
How would you code the criteria to restrict the output to be produced?
Given an unsorted data set, how to read the last observation to a new data set?
what is snowflake schema? : Sas-di
what is data governance? : Sas-di
How do you connect the desktop application to metadata server? : sas-grid-administration
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?
What are the prime responsibilities of data integration administrator? : Sas-di
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?
Teradata 
