/**rawdata set looks like below*/
data rawdata ;
text="essay, an analytic, interpretative, or critical literary composition usually much shorter and less systematic and
formal than a dissertation or thesis
and usually dealing with its subject from a limited and often personal point of view";
run;
i have one rawdata like above one . with in a string we have multiple empty lines,tab spaces, unwanted spaces . How to remove all type of spaces except single embbded space.
I tried with few programs but I couldn't . coming like few words going to mix for example see bold letters 'and' 'formal' these words coming like "andformal".
My request is
The record should be like below if export this dataset: "essay, an analytic, interpretative, or critical literary composition usually much shorter and less systematic and formal than a dissertation or thesis and usually dealing with its subject from a limited and often personal point of view"
... View more