topic Delimiter in SAS Procedures

Delimiter

R_Win — Fri, 05 Dec 2008 06:31:28 GMT

i have dataset with delimiter in beetween the observations i want all the delimiters should be replaced with comma.

data c;
input id$ sal$;
if id ='%' then id=',';
cards;
kool-% ra/,'l
nani(^/ mo-'
run;
proc print;
run;

output should be like this
kool,, ra,,,,
nani,,, mo,,

Re: Delimiter

sbb — Fri, 05 Dec 2008 07:41:52 GMT

SAS PROC IMPORT and EXPORT may be suitable for your requirements.

As well, you may find that the DATA step approach will work, as you have described in your forum post. For a DATA step approach, you can use the DLM= option on both the INFILE (also include the DSD parameter) and the FILE statements, along with the INPUT and PUT statements to read in and out your file.

The SAS support website http://support.sas.com/ contains product documentation and supplemental technical user community (SUGI / SGF) papers with examples on this topic. I used the site's SEARCH facility and found one technote referenced below for the inputting perspective. Have a look at the SAS Base Language Reference: Dictionary for using the FILE statement for the output perspective.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/techsup/technote/ts673.html

Re: Delimiter

R_Win — Thu, 11 Dec 2008 08:26:08 GMT

can any one help me inthis

Re: Delimiter

Patrick — Thu, 11 Dec 2008 09:17:17 GMT

Use the function 'translate()' for your ID variable.
If you don't know all possible special characters then a more generic solution would be possible using Regular Expressions - but it's also more difficult to code...
HTH
Patrick