topic Re: How to resove or remove bouble quotes from string macro in SAS Programming

How to resove or remove bouble quotes from string macro

santhosh — Mon, 01 Apr 2013 09:38:23 GMT

I am generating a macro with double quotes in if

%let TEXT=Total outstanding balance for "Rise company" is 25;

Proc print data=sashelp.cars;

title "for period the &text";

run;

i will get error

how to replace or remove this double quotes form text macro

is there any way

Re: How to resove or remove bouble quotes from string macro

data_null__ — Mon, 01 Apr 2013 10:07:49 GMT

title %sysfunc(quote(for period the &text));

Re: How to resove or remove bouble quotes from string macro

santhosh — Mon, 01 Apr 2013 11:39:37 GMT

i have one problem

i am connecting to oracle and executing procedure and i am getting error

%put &syserrortext;

ORACE execute error: ORA-06550: line 1, column 7:PLS-00201: identifier 'PROC_CPR033_VALIDATE11' must be

declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredORA-06512: at "DEVELOPER.CPR_RETURNS_BACK_DATE", line

67ORA-06512: at line 1

now i want to display this syserrortext in table or in macro or export as txt

if i use this in title i am getting following error

ERROR: The function QUOTE referenced by the %SYSFUNC or %QSYSFUNC macro function has too many arguments.

is there any way

Re: How to resove or remove bouble quotes from string macro

data_null__ — Mon, 01 Apr 2013 11:43:29 GMT

The commas in syserrortext are the problem. Try this

%sysfunc(quote(%superq(syserrortext)))

notice there is NO & used with %superq.

Re: How to resove or remove bouble quotes from string macro

santhosh — Tue, 02 Apr 2013 04:56:49 GMT

%put &syserrortext;

ORACE execute error: ORA-06550: line 1, column 7:PLS-00201: identifier 'PROC_CPR033_VALIDATE11' must be

declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredORA-06512: at "DEVELOPER.CPR_RETURNS_BACK_DATE", line

67ORA-06512: at line 1

this double quotes is creating a problem

is there any way to remove double or single quotes from macro syserrortext

Re: How to resove or remove bouble quotes from string macro

Tom — Tue, 02 Apr 2013 05:36:50 GMT

Did you try what data _null_ suggested?

Why do you want to remove the quotes if your intent is to use the value?

To use as a value in a DATA step then use SYMGET and you do not need to worry about the commas or quotes.

data want;

length syserrortext $400;

syserrortext=symget('syserrortext');

run;

To use the value in a TITLE statement then use the QUOTE() function.

title %sysfunc(quote(%superq(syserrortext));

Re: How to resove or remove bouble quotes from string macro

santhosh — Tue, 02 Apr 2013 09:19:40 GMT

Thanks tom its correct

Re: How to resove or remove bouble quotes from string macro

santhosh — Thu, 18 Apr 2013 10:32:53 GMT

data want;

length syserrortext $400;

syserrortext=symget('syserrortext');

run;

using this code i am able to handle error in want table

if there is no error i am getting blank data but when i am taking count of syserrortext then i am getting count as 1

how to get 0 if no data is available