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 will you generate test data with no input data?
where to use sas business intelligence? : Sas-bi
what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.
How to specify variables to be processed by the freq procedure?
how to assign a macro value to a variable?
How to select the observations randomly from a SAS dataset
How do dates work in sas?
In SAS explain which statement does not perform automatic conversions in comparisons?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
How to convert a numeric variable to a character variable?
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?