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 the date 04oct1994 is stored in SAS,not only give the answer explain in brief?
Are you involved in writing the inferential analysis plan? Tables specifications?
How to specify variables to be processed by the freq procedure?
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
What can you learn from the SAS log when debugging?
What are the prime responsibilities of data integration administrator? : Sas-di
How to read the file names of a text files from a shared drive using SAS?
what is the difference between unique key and primary key? : Sas-di
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Explain proc sort?