topic Re: how to search for a string in double quotes in New SAS User

how to search for a string in double quotes

learn_SAS_23 — Wed, 17 Aug 2022 10:22:09 GMT

Hello Team ,

we are having below text in the end of XML file

%macro GetFileByServerRelativeUrl (out_param=);
		%global &out_param. test1;
		%let &out_param.=;
		data _null_;
		length text $32767;
        infile "/out_countryrisk_fi.txt" DSD DLM="09"x ;
	 	input;
		test1=index( _infile_,'next');
		put 'this is to test value ' test1 ;
		call symputx("&out_param.", text);
      	run;
%put  macro variable &out_param. created with value &&&out_param. ;
		
%mend;

 %GetFileByServerRelativeUrl ( out_param=ServerUrl_new);

1. am try to search for word 'next' in the XML using

test1=index( _infile_,'next'); where am getting '0' as output

2. how to read the text only in double quotes after the word next in above string

Re: how to search for a string in double quotes

Quentin — Wed, 17 Aug 2022 11:05:25 GMT

Hi,

Your use of INDEX() looks fine to me, e.g. below works:

data _null_ ;
  string="<link rel=""next"" href=""http://spappfarm.opintra.fi/iapps/testsite_uat/_api/Web/Lists/getByTitle('test%20test%20test%20test'..."" /></feed>);" ;
  test1=index(string,'next');
  put string= test1=;
run ;

Note that your XML file likely has multiple lines, and this will be checking every line to see if it has the string "next" on in it.

To debug, I suggest you change your PUT statement to:

put 'this is to test value ' test1= _infile_ ;

That should let you check that the _infile_ variable has the value you intend.

Re: how to search for a string in double quotes

learn_SAS_23 — Wed, 17 Aug 2022 11:31:43 GMT

thanks for quick reply,
is there any way to double quote whole text in a file , as i observe you enclosed the double quoted string in double quote like this ""next""

Re: how to search for a string in double quotes

Astounding — Wed, 17 Aug 2022 11:42:32 GMT

Here's a theory as to the cause ... it should be easy for you to test.

When your INPUT statement ends, it releases the current line of raw data. That updates the value of _INFILE_. So make a small change to your program to hold on to the current line of raw data just a little bit longer: Where you have:

input;

change it to:

input @;

Re: how to search for a string in double quotes

Quentin — Wed, 17 Aug 2022 11:50:11 GMT

Hi, you don't need to double quote the values you read from the text file. I had to do it because I was using the string on an assignment statement, so I used double quote marks to define the string, and then inside the string used double double quotes. Put if you run my code, you will see the PUT statement shows that the value of STRING does not have double double quotes in it. Because the assignment statement translates ""next"" to "next".

Re: how to search for a string in double quotes

Quentin — Wed, 17 Aug 2022 12:04:13 GMT

Your original code works for me. Here is an example where I write a file, and then read in the file using your original code. I added a PUT statement to show the value of _infile_.

*generate an input file;
data _null_ ;
  file "Q:\junk\foo.txt" ;
  put "<link rel=""next"" href=""http://spappfarm.opintra.fi/iapps/testsite_uat/_api/Web/Lists/getByTitle('test%20test%20test%20test'..."" /></feed>);" ;
  put "hello world" ;
run ; 


*Read in the file ;
data _null_;
  infile "Q:\junk\foo.txt" DSD DLM="09"x ;
  input;
  test1=index( _infile_,'next');
  put "the value of _infile_ is:"  _infile_  ;
  put 'this is to test value ' test1;
run;

Log is:

10   *Read in the file ;
11   data _null_;
12     infile "Q:\junk\foo.txt" DSD DLM="09"x ;
13     input;
14     test1=index( _infile_,'next');
15     put "the value of _infile_ is:"  _infile_  ;
16     put 'this is to test value ' test1;
17   run;

NOTE: The infile "Q:\junk\foo.txt" is:
      Filename=Q:\junk\foo.txt,
      RECFM=V,LRECL=32767,File Size (bytes)=154,
      Last Modified=17Aug2022:08:03:28,
      Create Time=17Aug2022:07:54:47

the value of _infile_ is:
<link rel="next" href="http://spappfarm.opintra.fi/iapps/testsite_uat/_api/Web/Lists/getByTitle('test%
20test%20test%20test'..." /></feed>);
this is to test value 12
the value of _infile_ is:hello world
this is to test value 0
NOTE: 2 records were read from the infile "Q:\junk\foo.txt".
      The minimum record length was 11.
      The maximum record length was 139.

Re: how to search for a string in double quotes

Tom — Wed, 17 Aug 2022 14:20:25 GMT

Are you just looking for the HREF= values that appear after the NEXT string?

data want ;
  infile "/out_countryrisk_fi.txt" DSD DLM='<= >' ;
  input @'"next"' @ '"href"=' text :$32767. @@ ;
run;

Re: how to search for a string in double quotes

learn_SAS_23 — Thu, 18 Aug 2022 07:38:05 GMT

Thanks every one for all your inputs ,

from this i could able to analyse that the input file am reading is more than 32767 , so the lines having the text (next) are truncated .

Here is solution , where am reading the input file morethan 32767 untill end of the file and searching for the string 'next' using find and finally extracting the text in href which are enclosed in doublequotes.

data Test_dataset;
infile " /out_test.txt" lrecl=32767 recfm=f truncover;
input @1 myline $CHAR32767.;
put "the value of _infile_ is:" _infile_ ;
test1=find( _infile_,'next');
text=scan(substr(_infile_, find( _infile_,'next')+11),1,"""");
put 'this is to test value ' text;
run;