topic Re: Writing a txt files with double quote inside in SAS Programming

Writing a txt files with double quote inside

garag — Fri, 24 May 2013 13:25:41 GMT

Hi,

I'm trying to write a txt file with sas. The file will contain a value of a macro variable and that mcro variable could contain double quote. Example

%let myvar=ORACLE execute error: ORA-01400: cannot insert NULL into ("blabla"."blabla"."blabla");

%let bodyfile=/mydir/mytxt.txt;

data _null_;

file "&bodyfile.";

put &myvar.;

run;

It does not work. What is wrong?

Any help will be appreciate.

Thanks

Tom — Fri, 24 May 2013 14:19:21 GMT

The combination of these two lines:

%let myvar=ORACLE execute error: ORA-01400: cannot insert NULL into ("blabla"."blabla"."blabla");

put &myvar.;

Will be:

put ORACLE execute error: ORA-01400: cannot insert NULL into ("blabla"."blabla"."blabla");

Which is clearly not what you want as it will look for variables named ORACE, EXECUTE, CANNOT etc.

The proper syntax you want is:

put "ORACLE execute error: ORA-01400: cannot insert NULL into (""blabla"".""blabla"".""blabla"")";

To get that use the QUOTE() function.

put %sysfunc(quote(&myvar)) ;

garag — Fri, 24 May 2013 14:33:49 GMT

Thank Tom, it worked