topic Re: Reading part of a (varying) filename into SAS dataset field, seperated by &quot;_&quot; in SAS Programming https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131619#M260662 <HTML><HEAD></HEAD><BODY><P>Thank you Richard, this works perfectly.</P></BODY></HTML> Wed, 21 Nov 2012 15:02:29 GMT Lakes74 2012-11-21T15:02:29Z Reading part of a (varying) filename into SAS dataset field, seperated by "_" https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131615#M260658 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have a large number of files where part of the information i require is held within the filename rather than contents of that file.</P><P>Eg: X1234567_AAA1_21112012.txt. I require the part at the first part (X1234567) ending before the underscore, which is straight forward to obtain.</P><P>The problem lies in the varying length of info, some are 8 cahrs long, others are 10 chars and longer.</P><P>I need to extract this information up to the point of the first underscore is displayed. This applies to all of the files.</P><P>Was thinking of using the Scan option but can't work out how to incorporate ine info before the underscore.</P><P>Thanks in advance.</P><P></P><P>Steve</P><P></P><P><BR /> </P></BODY></HTML> Wed, 21 Nov 2012 13:39:45 GMT https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131615#M260658 Lakes74 2012-11-21T13:39:45Z Re: Reading part of a (varying) filename into SAS dataset field, seperated by "_" https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131616#M260659 <HTML><HEAD></HEAD><BODY><P>Scan () is the function to use.&nbsp; Scan(name, 1, '_') ; shou dgive the required info.&nbsp; Third parameter specifies the delimiter.</P><P></P><P>Richard in Oz</P></BODY></HTML> Wed, 21 Nov 2012 13:52:35 GMT https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131616#M260659 RichardinOz 2012-11-21T13:52:35Z Re: Reading part of a (varying) filename into SAS dataset field, seperated by "_" https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131617#M260660 <HTML><HEAD></HEAD><BODY><P>Did Richard's response provide the answer you needed?&nbsp; If not, post your code.</P></BODY></HTML> Wed, 21 Nov 2012 14:58:49 GMT https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131617#M260660 art297 2012-11-21T14:58:49Z Re: Reading part of a (varying) filename into SAS dataset field, seperated by "_" https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131618#M260661 <HTML><HEAD></HEAD><BODY><P>Yes it did Arthur. Thanks.</P></BODY></HTML> Wed, 21 Nov 2012 15:01:55 GMT https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131618#M260661 Lakes74 2012-11-21T15:01:55Z Re: Reading part of a (varying) filename into SAS dataset field, seperated by "_" https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131619#M260662 <HTML><HEAD></HEAD><BODY><P>Thank you Richard, this works perfectly.</P></BODY></HTML> Wed, 21 Nov 2012 15:02:29 GMT https://communities.sas.com/t5/SAS-Programming/Reading-part-of-a-varying-filename-into-SAS-dataset-field/m-p/131619#M260662 Lakes74 2012-11-21T15:02:29Z