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 |
How to specify variables to be processed by the freq procedure?
How do you download a flat file from Mainframe to your local PC using SAS?
How does the internal authentication work in sas? : sas-grid-administration
Give some examples where proc report’s defaults are different than proc print’s defaults?
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
Why is a STOP statement needed for the point=option on a SET statement?
What is the difference between input and infile statement?
How to get the repeated values by using sql in sas ?
In SAS explain which statement does not perform automatic conversions in comparisons?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
How to display duplicate observations in data?
Differentiate between ceil and floor functions.