Help using Base SAS procedures

how to put delimiter??

Reply
N/A
Posts: 0

how to put delimiter??

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
Respected Advisor
Posts: 4,173

Re: how to put delimiter??

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 110 views
  • 0 likes
  • 2 in conversation