topic Re: data is not coming correctly in datalines in SAS Programming

data is not coming correctly in datalines

MG18 — Thu, 22 Mar 2018 12:35:30 GMT

LIBNAME samp2 BASE "E:\Sachin\FirstRpt\Library";

data samp2.sample;
infile datalines dlm=' ' dsd ;
input country_name$ diaseases$ death ;
datalines;
India Cancer 200
India TB 300
Pakistan Cancer 200
Pakistan TB 400
united state of america TB 300
united state of america Cancer 4000
;
run;

proc print data=samp2.sample;
run;

Output :-

country_
Obs name diaseases death

1 India Cancer 200
2 India TB 300
3 Pakistan Cancer 200
4 Pakistan TB 400
5 united state .
6 united state .

How to fix this issue as data for USA is not coming correctly.

Re: data is not coming correctly in datalines

andreas_lds — Thu, 22 Mar 2018 12:48:08 GMT

There is an example in the online docs:

http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.3&docsetId=lestmtsref&docsetTarget=n0lrz3gb7m9e4rn137op544ddg0v.htm&locale=de#n1dyx4r7yqsmuun1mk3cbw7ih06w

Re: data is not coming correctly in datalines

gamotte — Thu, 22 Mar 2018 12:48:22 GMT

Hello,

You use space as a the delimter. Strings can thus not contain any space

or they will be interpreted as columns separators.

Use another delimiter.

Re: data is not coming correctly in datalines

SuryaKiran — Thu, 22 Mar 2018 13:09:56 GMT

Hi @MG18,

If you have embedded blanks then use "&" modifier to read the data. Make sure that when you have embedded blanks in one variable then you have double blanks for the next variables to separate them.

For eg: On 1st record between India and Cancer there are two blanks.

data sample;
infile datalines dlm=' ' dsd ;
input country_name & $25. diaseases $ death ;
datalines;
India  Cancer 200
India  TB 300
Pakistan  Cancer 200
Pakistan  TB 400
united state of america  TB 300
united state of america  Cancer 4000
;
run;