Hello Experts,   You know that in web, there is the request (the client's request -> server) and the response (server -> client's browser). The response from http://XXXXXX is a file stream type txt (generated with php).   So physical file doesn't exist, while clicking on  http://XXXXXX   I'm wondering if there is possible to import this kind of file ?    Thank you for helping ! ... View more

Hello Experts,   My data is:     I would like to replace "0" by space before and after the values:   Mt="0000000302972E" -> Mt_final= 302972E Mt="0000000141852A0000" ->Mt-final= 141852A   My code is :    data table_2; set table_1; if prxmatch("m/0/oi",mt)> 0 then mt_final=tranwrd(mt,"0",""); run; But some times with the "0" inside the value like Mt="0000000302972E" it doesn't work because I get Mt_final= 3 2972E, not Mt_final= 302972E.   I'm wondering if there is some option in prxmatch function.   Thank you for helping me !       ... View more

Hello Experts,   I have the file (herewith attached), I don't know the number of variables in it, so I can't procced with  infile\informat\format and input. I'm wondering if there is another way to import the txt. I know that proc import doesn't work with txt.    Thank you for your help ! ... View more