how to put delimiter??

[deleted_user]

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

[Patrick]

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