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.
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;
There is an example in the online docs:
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.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.