About larryn3

larryn3 · ‎01-18-2022

Works great! Now I'm going to try to modify code since my input file doesn't have headers. I was thinking of using the first row as a header and since that row obviously won't be legitimate variable names, i would possibly just pick the first 3 or 4 characters and append a character before each in case there is a numeric in the first row. Thank you again for your help. And I'm going to mark this as an accepted solution.

larryn3 · ‎01-12-2022

Thank you very much for all your help and the time you spent on this. I'm going to study your suggestion in the next couple of days. It is possible I may need to follow up.

larryn3 · ‎01-11-2022

File 1 RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8 1 N22OR44DLICHT, MxxAdK, b x26 OWNEdd RY) adLATINUM 81 01/2002 B Y N 161 304gg438g97 2 134PO5TEAT, PffAfU, AdsfO x26 CHIEF sf323+R ALfdL 335gr 81 06/2007 NA Y N 161 3f5g77r File 2 RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8 1 M11Af N43 GRsfsgANTfOR yy50 OWdaNERd- PLATsd(NsdaY) 81 03/2009 D Y 161 N x-xf3$x$5xxx 2 PLfsf33ATINUM CRdsfT yy50 GENE223RAL Pada2sARTNER - P 81 LATIsdaNU CRE23 09/2005 NA Y 161 N www

larryn3 · ‎01-11-2022

File 2 RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8 1 N22OR44DLICHT, MxxAdK, b x26 OWNEdd RY) adLATINUM RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8 81 01/2002 B Y N 161 304gg438g97 2 134PO5TEAT, PffAfU, AdsfO x26 CHIEF sf323+R ALfdL 335gr 81 06/2007 NA Y N 161 3f5g77r NOTE: 3 records were read from file 'c:\test\file1a.txt' The minimum record length was 0 The maximum record length was 172 NOTE: The data step took : real time : 0.001 cpu time : 0.000 File2 RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8 1 M11Af N43 GRsfsgANTfOR yy50 OWdaNERd- PLATsd(NsdaY) 81 03/2009 D Y 161 N x-xf3$x$5xxx 2 PLfsf33ATINUM CRdsfT yy50 GENE223RAL Pada2sARTNER - P 81 LATIsdaNU CRE23 09/2005 NA Y 161 N www

larryn3 · ‎01-11-2022

Attached is a word file which should show more clearly the way the columns are aligned.

larryn3 · ‎01-11-2022

Sorry, Unfortunately the columns didn't line up the way they appeared when i was typing them in. I tried try the "insert code" but that was not any better. I'll try to put the example in a file and attach it to the next post.

larryn3 · ‎01-11-2022

Actually I have about 1000 files each file has 8 columns but the columns are in different positions: File 1: C1 C2 C3 c4 c5 c6 c7 c8 aaaa z8z 23 bbbbbbbbbbbbb s;lfjslf;sjl;dkfjs y ls;dkfjl ;ds n abc xyz aafssb 122 bb111233bbb 54332fjs n l4645643dsj n abc xyz2342221 File 2 C1 C2 C3 c4 c5 c6 c7 c8 aaaa zzz zz bbbb s;lfjslf;sjl;dkfjs y ls;dkfjl ;ds n 223 xyz aafssfaa b zz zz b33bbb 54332fjs n l46456ds n a b qr4dsdfs

larryn3 · ‎01-11-2022

Maybe I'm missing something I don't know which position to read each the values from. Each of the files has can have a different column position for each of the eight variables I want to create. The only thing I do know is that there are 8 columns in each file and that the each of the columns begins at the same position. I hope I am being clear. If not I can provide a more detailed explanation.

larryn3 · ‎01-11-2022

Ah, this shows me the column locations where the variables should begin. Now how do I put the "column start"s into a substring function to pull out the 8 variables. How do I do that? really appreciate your help, I think we're on the right track.

larryn3 · ‎01-11-2022

Forgive my ignorance, but i don't see the popup.

larryn3 · ‎01-11-2022

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

Online Status	Offline
Date Last Visited	‎06-18-2025 08:36 AM

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns

Re: Proc Import -- Multiple Spaces Between Columns