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
- 24571 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 |
Name validation tools used in SAS
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
How do dates work in SAS data?
how to handle in stream data containing semicolon in it?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
In PROC PRINT, can you print only variables that begin with the letter “A”?
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
How are numeric and character missing values represented internally?
Difference b/n proc means and proc summary procedures?
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
What does P-value signify about the statistical data?
For what purpose(s) would use the RETURN statement?
Teradata 
