SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
devnand
Obsidian | Level 7

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
Reeza
Super User

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
Obsidian | Level 7

Thanks much

data_null__
Jade | Level 19

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;


12-1-2014 4-23-19 PM.png

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1483 views
  • 4 likes
  • 3 in conversation