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
Answer Posted / 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 |
Post New Answer View All Answers
Which are the statements whose placement in the data step is critical?
Explain proc sort?
What would you change about your job?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
how to change the execute of macro
Differences between where and if statement?
what is slowly changing dimension? : Sas-di
How would you include common or reuse to be processed along with your statements?
What is program data vector (pdv)?
Are you involved in writing the inferential analysis plan? Tables specfications?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
How substr function works in sas?
do you need to know if there are any missing values? : Sas programming
why is sas considered self-documenting? : Sas programming
What are the parameters of scan function?