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 best practices to process the large data sets in sas programming? : Sas-administrator
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
Explain how merging helps to combine data sets.
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What is the difference between where and if statement?
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?
what is sas database server? : Sas-di
Intern stastical programmer written test
What makes sas stand out to be the best over other data analytics tools?
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.