Follow-up/related question to :
https://communities.sas.com/t5/SAS-Programming/Proc-Import-Multiple-Spaces-Between-Columns/m-p/789575#M252668
Hi,
This works great for text followed by numerics.
I have sort of a related question.
I need to process many text files so that they can be imported into SAS one by one (I'll do a macro loop and then an append each).
They are all formatted "tables", i.e. with the same number of columns (8) which are all aligned and separated by spaces but the number of spaces can vary and each line is ended with [CRLF].
Here is an example of two of them:
FILE 1
N22OR44DLICHT, MxxAdK, b x26 OWNEdd RY) adLATINUM 01/2002 B Y N 304gg438g97
134PO5TEAT, PffAfU, AdsfO x26 CHIEF sf323+R ALfdL 335gr 06/2007 NA Y N 3f5g77r M11Af N43 GRsfsgANTfOR yy50 OWdaNERd- PLATsd(NsdaY) 03/2009 D Y N x-xf3$x$5xxx
File 2
M11Af N43 GRsfsgANTfOR y50 OWdaNERd- PLATsd(NsdaY) 03/2009 D Y N x-xf3$x$5xxx PLfsf33ATINUM CRdsfT yy50 GENE223RAL Pada2sARTNER - 09/2005 NA Y N 226
The output should be a dataset with 8 variables: C1....C8. The variables should each be text variables.
Any ideas?
Thank you for your help.
Larry
... View more