Thank you -Jan ... View more

Thanks Reeza that worked ... View more

Hi Chris if I'm getting an Infile how do I make refer to all X's. For it to work ? ... View more

I thought I was providing you with all the pertaint information. .. since the atmbarcode works I fig it be easier to do it in steps since I have a code that brings 6 of the characters I thought you could show me how to tweak the code to bring the rest here is what I'm looking at right after I run the first part X. Bacode. N. Newvar ZT2487 Blah,blah,blah, Atmbarcode :"TY272822. 2 Blah, blah,blah,blah, 1ZT2487A1221111111,blah,blah, Sorry for the misunderstanding I thought I was helping by providing code an not example hopes that helps my thought process ... View more

It didn't work I can do it in steps first pulling atmbarcode which works than pulling for tracking number which is in column X example 1ZT28 an one more letter an 10 more digits all together 17 characters long .hi have this code Data have; Set have; Newvar=('s/.+([A-Z](2)) *(\d+).*/$1$2/o',-1,'x'n); Run; My output Is only 6 characters ZT2487 how can I tweak it to bring in all 18 characters? Thank you ... View more

Hi Ksharp I was able to get the code to work bit now I need find atmbarcode and tracking number that starts with 1zts how can I incorporate in the code to look for both items in the code you help me with ? ... View more

Hi I will examples  bacode is the name of column I create .. I'm looking for everything that starts with atmbarcode:  I now need to add the tracking number that is in another column and if starts with 1zt2.    ...so the first part of code works it brings in everything I need I need to add and statement to bring 1zt2 tracking number ..the location of the tracking numBer can vary from col 5 thru coL 300 .....I was hoping peral could assist    ... View more

Thank you ksharp for everything ....using your code I fig it out ... View more

Here is my log Numeric values have been converted to character values at the places given by (line) column). 20658:10 20659:22 20661:15. 20663:22 Note there were 136 observation read from data set work.test. the data set want has 0 observation and 3 variables ....hope this helps as well ... View more

There is 255 rows of the same data. ... View more

The sas system The contents procedure Data set name work.test. observation 136 Member name Data. Variables. 255 engine. V9. Indexes. 0 Created.06/22/16. 22:45:5 Observations length 5456 last modified 06/22/16 22:45:5. Deleted observation 0 Protection. Compress No Data set type. Sorted no Label. Data representation win_32 Encoding latinwestern engine /host dependant information Data set page size. 262144 Number of data set pages 3 First data page 1 Max obs per page 48 Obs in first data page 42 Number of data set repair 0 Extendobs counter. Yes Filename test.sas7dat Release 9.0401m3 Host created w32_7pro Alphabetical list of variables an attributes # variable. Type. Len. Format informat label 3. Atm1. Char. 22. $22. $22. Atm1 4. Atm2. Char. 25. $25. $25. ATM2 5. Atm3. Char. 24. $24. , $24. Atm3 6. Atm4. Char. 19. . $19. $19. Atm4 ... View more