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 / learning sas
FILENAME EXTERNAL1 'PATH';
FILENAME EXTERNAL2 'PATH';
Proc import DATAFILE=EXTERNAL1
OUT=XYZ REPLACE;
GETNAMES=YES;
RUN;
DATA _NULL_;
FILE EXTERNAL2;
SET XYZ;
PUT _ALL_;
RUN;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sas developer
DATA _NULL_;
INFILE 'C:FILESINPUT.TXT' MISSOVER TRUNCOVER;
INPUT BLOCK $100.; /* This is length of the record. Change to suit your file*/
FILE 'C:FILESOUTPUT.TXT';
PUT BLOCK;
RUN;
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the differences between proc means and proc summary?
Under what circumstances would you code a SELECT construct instead of IF statements?
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
What are the different types of sas functions?
What is _n_?
What is the difference between verification and validation?
Name statements that function at both compile and execution time?
what is the difference between unique key and primary key? : Sas-di
for whom is sas data integration studio designed? : Sas-di
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
wat is sas? is a package or programming language?