Adding single quote to a data in sas

[devnand]

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;

id

'11111'

'12345'

'14524'

'45246'

Thanks in advance

PLease help.

[Reeza]

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;

[devnand]

Thanks much

[data_null__]

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;