topic Re: Adding single quote to a data in sas in SAS Programming

Adding single quote to a data in sas

devnand — Mon, 01 Dec 2014 22:09:57 GMT

data test;

input id 5.;

datalines;

11111

12345

14524

45246

;

run;

The quote function adds double quotes to the data, but I wanted to add the single quote.. %BQUOTE And %STR seems not working.

data test2;

set test;

id_new=quote(id);

run;

******

desired output;

'11111'

'12345'

'14524'

'45246'

Thanks in advance

PLease help.

Re: Adding single quote to a data in sas

Reeza — Mon, 01 Dec 2014 22:18:50 GMT

Can concatenate in single quotes.
The single quotes are quoted by double quotes in the following example:

data want;

set test;

id_quote=catt("'", id, "'");

run;

Re: Adding single quote to a data in sas

devnand — Mon, 01 Dec 2014 22:24:23 GMT

Thanks much

Re: Adding single quote to a data in sas

data_null__ — Mon, 01 Dec 2014 22:24:31 GMT

You can use one of these functions. One method is not documented.

data test;
input id $5.; 
datalines; 
11111
12345
14524
45246
; 
run; 
 
data test2;
   set test;
   id_new=quote(id,"'");
   id_new2=catq('1A',id);
   run; 
proc print; 
   run;