data is not coming correctly in datalines

[MG18]

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.

[andreas_lds]

There is an example in the online docs:

http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.3&docsetId=lestmtsref&docsetTarget=n0...

[gamotte]

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.

[SuryaKiran · Accepted solution]

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;