Do you see anything I might be missing? ... View more

Hi Ksharp I copy your code an refer Test table an prxparse atmbarcode: an did the the catx to include only the columns I want to select even though it'sbe 600 ...an it comes back when I use cards it works beautiful. ..when I try to refer table it fail. ..i really appreciate your help ... View more

Hi Ksharp it worked how do i refer a table the name of table is test... an the columns names is Bacode1 thru Bacode500. How do I make these columns appear in a single col X. So that I can do substr to bacode? Thank you ... View more

.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

Here is a example of my raw data I have over 500 columns that start with barcode1 thru barcode 500 ... not all columns have what I'm looking only the rows that have atmbarcode:FE235 that is just example there are other id numbers but they all start with atmbarcode: Barcode1. Barcode2. Barcode3 Atmbarcode:TU35. Row#% atmbarcode:WE45 Here is out put Barcode TU35 WE45 THANK YOU ... View more

Hi Ksharp I added the code you provided an it brought back zeros... I thought it would bring back at least 2 since thst is how many is in the cards........am I overlooking something? Thank you again ... View more

Thanks for assistance it's bringing in everything for example Atm1. Atm Atm3. Atm4..... atmbarcode:"FE235. Row Ash atmbarcode:"Yu23 what I want output Atm1. Atm4 atmbarcode:"FE235. atmbarcode:"Yu23 my script is Data test; Set test1; Length atm $20.; N+1 Atm=catx (' ',of atm1-atm100); Pid=prxparse ('/atmbarcode:\d+/i'); S=1; E=length (x); Call prxnext (pid,s,e,x,p,l); Do while (p>0); Atmbarcode =substr (x,p,l); End; Keep n x atm1-atm600; Run; I thought the pid=prxparse ('/atmbarcode :\d+/i'); I thought that would filter for only that atmbarcode an nothing else?...I know what n means what is x it comes in blank ...could I get shipid into what x is ... View more

Hi Ksharp Thank you for response I seem to have gotten to work with your code... but it's bringing every thing from the col down an not horizontal by row ... I have a table that has 100 col that start with Barcode barvode1 and Barcode3 .... in your code I was able to get data when I refer the col name Barcode3 for example ..an only that output ...how do I refer the other columns ? Here bit of information in the col from the data that I'm looking for they all start with atmbarcode. An not all 100 col have the data I need those start with bagbarcode... In a nut she'll I need to look at 100 col an were the col name is Barcode does it have and entry of atmbarcode in the beginning. ...thanks for your help much appreciated ... View more

Thanks for response. I have a question can I use scan to look only for a specific word like Barcode instead of "? ... The entries can vary per row Id. Bacode1 Was1 Bacode2 was2 Bacode3 was3 Qw. Bar Az011. ABC. BarAz345. Wer.BarAz056. Tr. BrAz078. Dfg. . Braz078. Tyr. Ee. Br Az089. Rty I would like to see Id Barcode1 Barcode2. Barcode3 Qw Az011. Az345. Az056. Tr. Az078. Az078. Ee. Az089. ... View more

Got it to work thanks again I learn something new today ... View more

Thank you ... View more

Sorry YOUR Right ..I Must Have Pasted Wrong Code ... View more