how to put delimiter??

deleted_user — Sat, 13 Sep 2008 23:10:50 GMT

I couldn't create this data set below my code, how do you put delimeter in the infile statement? Thanks

data WORK.xxxxxx;
infile &myfile
dlm='3' firstobs=2;
input Class $1-6 Age $9-14 Sex $17-23 Survived $25-28;
run;

Class Age Sex Survived
First Adult Male Yes
First Adult Male Yes
First Adult Male Yes

Re: how to put delimiter??

Patrick — Sun, 14 Sep 2008 07:16:25 GMT

You define delimiters the way you did it. You defined '3' as delimiter.
BUT:
Your data doesn't look as if the digit '3' is the separator between you raw data fields.
You are reading the data using fixed column style input. I.e. you read the data for class always from column 1-6. Using columns style you don't need to define a delimiter at all (look it up in the Online Doc under INPUT Statement).
To read the data as given in your example, try something like this:

%let myfile=datalines;
data WORK.want;
infile &myfile firstobs=2;
input Class:$6. Age:$6. Sex:$7. Survived:$4.;
put _all_;
datalines;
Class Age Sex Survived
First Adult Male Yes
First Adult Male Yes
First Adult Male Yes
;

HTH
Patrick

topic how to put delimiter?? in SAS Procedures

how to put delimiter??

Re: how to put delimiter??