topic Re: Read datalines with comma delimiter in SAS Programming

Read datalines with comma delimiter

DmytroYermak — Mon, 17 Sep 2018 09:44:14 GMT

Hi all,

Please advise how to read the data from the datalines. Simple case but I did not do it for one year and can not recollect (

data test;
  infile datalines dsd;
  input severity;
datalines;                      
0,0,0,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,3,3,3,3,4,4,5,5,5,5,6,7,9,10,11
;
run;

Re: Read datalines with comma delimiter

RW9 — Mon, 17 Sep 2018 09:46:33 GMT

Just add:

data test;
  infile datalines dlm="," dsd;
  input severity;
datalines;                      
0,0,0,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,3,3,3,3,4,4,5,5,5,5,6,7,9,10,11
;
run;

Do note you will only read one item though as only one variable given. Do you want to read each one into a variable or observation?

Re: Read datalines with comma delimiter

DmytroYermak — Mon, 17 Sep 2018 10:11:53 GMT

Yes, I want to read each item into an observation. Your variant doesn't do it (

Re: Read datalines with comma delimiter

data_null__ — Mon, 17 Sep 2018 10:39:39 GMT

input severity @@;

Re: Read datalines with comma delimiter

DmytroYermak — Mon, 17 Sep 2018 11:07:35 GMT

Thank you!