Excuse me each friend altar, I execute the following code, will receive the results of manual exported as TXT, TXT named col numerical, and manually delete TXT in the first row of column variable names, TXT retain only variables, two of every time synchronization modify the code date column, cycle, low efficiency, do not know how to use the macro-program, automatically performs this loop, thank you!


Data A01;

Set new data (where=(F3=F3='04 aug2016' D));

run;

The data how A02.

The set A01;

Col=20160804;

run;

DATA A03;

FORMAT F1 $30. 8 F2. F9 $30. F8 to $30. COL 8. F6 $30);

SET how A02.

KEEP F1 F2 F9 F8 COL F6;

The RUN.