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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.