topic Re: Removing Quotations in SAS Procedures

Removing Quotations

TT12 — Mon, 21 Feb 2022 01:30:28 GMT

How can I remove the quotes from the name of each state?

ballardw — Mon, 21 Feb 2022 01:47:56 GMT

The COMPRESS function is one of the basic tools to remove single characters. In a data step

state= compress(state,'"');

You may have to look closely but the compress function has one double quote, the character to remove, between single quotes.

Or consider that how you read the data in the first place might have an issue.

TT12 — Mon, 21 Feb 2022 02:15:50 GMT

Thank you!!

BrahmanandaRao — Mon, 21 Feb 2022 08:03:30 GMT

data ds;
input state $ ;
datalines;
"Arizona"
"Albama"
;

run;

data d;
set ds;
 y=dequote(state); 
 run;