topic Re: Format data in sas dataset in SAS Procedures

Format data in sas dataset

Hima — Mon, 16 Apr 2012 18:04:12 GMT

Below is my input
data have;
input col1 $4.;
cards;
abcd
efgh
ijkl
mnop
qrst
;
run;

Need output as follows
'abcd',
'efgh',
'ijkl',
'mnop',
'qrst'

Is this a possibility in SAS?

Re: Format data in sas dataset

Reeza — Mon, 16 Apr 2012 19:04:52 GMT

Is it the quoted part or each result on a separate line that you'd like?

And yes it's possible...

data _null_;

set sashelp.class;

file "C:\temp\test.csv" dlm=',' dsd;

put

name $~

sex $~

height $~

weight $~

age $~

;

run;

Re: Format data in sas dataset

Hima — Mon, 16 Apr 2012 19:10:30 GMT

I need it for every observation. I only have one variable in the data set and it has to be in the ' ', format.

Re: Format data in sas dataset

Linlin — Mon, 16 Apr 2012 19:33:11 GMT

how about this one?

data have;

input col1 $4.;

cards;

abcd

efgh

ijkl

mnop

qrst

;

run;

data want;

set have;

length n $8;

n='*'||col1||'*';

nn=translate(n,"'","*");

run;

proc print;run;

Obs col1 n nn

1 abcd *abcd* 'abcd'

2 efgh *efgh* 'efgh'

3 ijkl *ijkl* 'ijkl'

4 mnop *mnop* 'mnop'

5 qrst *qrst* 'qrst'

Linlin

Re: Format data in sas dataset

Hima — Mon, 16 Apr 2012 19:37:57 GMT

Thanks Linlin. It worked but I have to add , to the code.

data have;

input col1 $4.;

cards;

abcd

efgh

ijkl

mnop

qrst

;

run;

data want;

set have;

length n $8;

n='*'||col1||'*'||',';

nn=translate(n,"'","*");

run;

proc print;run;

Re: Format data in sas dataset

FriedEgg — Mon, 16 Apr 2012 19:42:24 GMT

data foo;

input col1 $;

cards;

abcd

efgh

ijkl

mnop

qrst

;

run;

proc transpose data=foo out=bar(drop=_:); var col1; run;

filename tmp temp;

data _null_;

set bar;

file tmp dlm=',' dsd;

put (col:) ($~);

run;

"abcd","efgh","ijkl","mnop","qrst"

*or;

data bar;

set foo;

col1=quote(strip(col1));

run;

*or;

data foo;

format col1 $quote.;

input col1 $;

cards;

abcd

efgh

ijkl

mnop

qrst

;

run;

proc print data=foo; run;

Re: Format data in sas dataset

MikeZdeb — Mon, 16 Apr 2012 19:56:38 GMT

hi ,,, another idea ...

data want;

length col2 col3 $6;

set have;

col2 = catq('2a',col1);

col3 = catq('1a',col1);

run;

or, no LENGTH statement needed ...

data want;

set have;

col2 = put(col1,quote.);

col3 = translate(col2,"'",'"');

run;

Re: Format data in sas dataset

Linlin — Mon, 16 Apr 2012 20:01:20 GMT

I thought the OP asked for single quote.