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?
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 to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
List down the reasons for choosing sas over other data analytics tools.
When merging 2 datasets with a common variable (not merge key), how to keep both?
what is sas business intelligence? : Sas-bi
is there any difference between proc summary and proc means?
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?
how to know the attributes of first five datasets in a library
How many ways to overcome a missing values???
what is the difference between proc report and proc format?
Name statements that function at both compile and execution time.
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
what is option year cuttoff in sas