Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 24186 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 |
How is character variable converted into numeric variable and vice versa?
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 it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
how does sas handle missing values in functions? : Sas programming
how does sas handle missing values in formats? : Sas programming
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
what is data access? : Sas-di
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
What is the command used to find missing values?
Approximately what date is represented by SAS date value of 730
what is star schema? : Sas-di
What is Transaction...? And what are Comment, Roll back n Save point..?
How do you add a number to a macro variable?
Teradata 
