DATA Step, Macro, Functions and more

Writing a txt files with double quote inside

Accepted Solution Solved
Reply
Contributor
Posts: 58
Accepted Solution

Writing a txt files with double quote inside

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


Accepted Solutions
Solution
‎05-24-2013 10:19 AM
Super User
Super User
Posts: 6,500

Re: Writing a txt files with double quote inside

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)) ;




View solution in original post


All Replies
Solution
‎05-24-2013 10:19 AM
Super User
Super User
Posts: 6,500

Re: Writing a txt files with double quote inside

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)) ;




Contributor
Posts: 58

Re: Writing a txt files with double quote inside

Thank Tom, it worked

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 172 views
  • 0 likes
  • 2 in conversation