- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 12-01-2014 05:09 PM
(1482 views)
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.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks much
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
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;