Hi Experts,      I have a variable that has different strings seperated by a pipe sign, Say as : VAR1 = STRING1|STRING2|STRING3 and so - on. Where only one string will contain a KEYWORD --> "EXTRACT_ME". And I would like to extract only the string that has EXTRACT_ME keyword. (an example is shown below)   I can defenitely achieve it with the help of a DO loop and serach for the KEYWORD in each string one by one and extract it. But I'm looking for something more effieicnt that really need to put it in a do loop. Maybe Perl Expression? Experts: Any advise? Appreciate your help.     INPUT_VAR OUTPUT_VAR FIRST STRING|EXTRACT_ME[ABC]|SECOND STRING EXTRACT_ME[ABC] STRING ONE|EXTRACT_ME[ABCDEFG]|STRING THREE|STRING FOUR EXTRACT_ME[ABCDEFG] ... View more

Experts, I was trying to mask single quotation mark in a SAS macro variable & was using %bquote to do that. But using %bquote I was getting reolving issues especially when I use multiple '&' as in the example below. I was thinking that %bquote wouldn't mask '&' unlike %nrbquote.  Say, in the below example: %let MACVAR1=10; %let a1=MACVAR1; %let j=&a1; %let k=%bquote(&a1); %let m=%nrbquote(&a1); %put "double_j = &&&j"; %put "double_k = &&&k"; %put "double_m = &&&m"; NOTE: Remote submit to SERVER commencing. "double_j = 10" "double_k = &MACVAR1" "double_m = &MACVAR1" NOTE: Remote submit to SERVER complete. Reading through the SAS documentation I was expecting that double_k should also be resolved as 10 not "&MACVAR1" as we are using %bquote. Experts, please correct me if I am wrong here. Please advise. Regards,    Geo ... View more

Experts, I am trying to read in the below data using hhmmss informat. While using hhmmss informat, when there are less that 6 digits in the input, as per SAS user guide, it appends zeros to the end to make it 6 digits and reads it in. But when 0010 as read in using hhmmss in SAS, it is read as 10 hours instead of 10 minutes (as I would expect.) Is it a SAS bug? Anyone knows a work around to it. Thanks a lot for the help... Test Program: data _null_;   x=input('0010',hhmmss.);   y=input('123045',hhmmss.);   put x=time8. y=time8.; run; SAS Log FIle: 1        !               2          data _null_; 3            x=input('0010',hhmmss.); 4            y=input('123045',hhmmss.); 5            put x=time8. y=time8.; 6          run; x=10:00:00 y=12:30:45 ... View more

Hi SAS Experts,    I have a tricky situation. I am trying to read an external file (file has no delimiters) to SAS, and I only want to extract  few strings from that external file to SAS dataset.  Is it possible to programtically do in SAS? I am copying the file I have below (it is a really small part of the actual file I have). Actual file that I have is really huge & each lines can be really long. (FYI - it is a FDF file, also attached "blankcrf.fdf") What I want to achieve is write a SAS code so I can extract the text between 'Rect[' and ']' for each occurance then store this text under a variable as different records. Say in this case, it will be VAR1 257.777 308.923 272.177 320.923 114.308 424.398 128.708 436.398 118.974 511.878 133.374 523.878 EXTERNAL FILE I HAVE IS AS BELOW ãÏÓ 2 0 obj<</Rect[257.777 308.923 272.177 320.923]/CreationDate(D:20130715034903-04'00')/NM(30024a65-f161-4e17-a6ce-5348dee5cf05)/Subtype/FreeText/BS 3 0 R/F 4/M(D:20130715034909-04'00')/IT/FreeTextTypewriter/T(BINZME1)/DA(16.25 TL /Cour 12 Tf)/DS(font: Courier 12.0pt; text-align:left; color:#000000 )/Subj(Typewritten Text)/Type/Annot/Page 0>> endobj 3 0 obj<</W 0.0>> endobj 4 0 obj<</Rect[114.308 424.398 128.708 436.398]/CreationDate(D:20130715035056-04'00')/NM(e13c51fe-b2b0-474d-9a8f-7e45e7b6d32d)/Subtype/FreeText/BS 5 0 R/F 4/M(D:20130715035104-04'00')/IT/FreeTextTypewriter/T(BINZME1)/DA(16.25 TL /Cour 12 Tf)/DS(font: Courier 12.0pt; text-align:left; color:#000000 )/Subj(Typewritten Text)/Type/Annot/Page 0>> endobj 5 0 obj<</W 0.0>> endobj 6 0 obj<</Rect[118.974 511.878 133.374 523.878]/CreationDate(D:20130715035226-04'00')/NM(af556422-5caa-472e-bc23-c5865db207a8)/Subtype/FreeText/BS 7 0 R/F 4/M(D:20130715035312-04'00')/IT/FreeTextTypewriter/T(BINZME1)/DA(16.25 TL /Cour 12 Tf)/DS(font: Courier 12.0pt; text-align:left; color:#000000 )/Subj(Typewritten Text)/Type/Annot/Page 0>> endobj Initially I was trying to read full file to SAS datasets and then extract the text I want. But as the file is so huge, it was taking a lot of time for me to convert it to a SAS dataset and then do the extraction. Also this file is not favourably formatted and has no delimiters with long single lines adding to the difficulty. Experts  - any tricks to do it? Appreciate your help. - George ... View more