How to read excel data to sas by using

[tlnarayana26]

plo_no	nplo_no	comm
573620	MAC23689	569803
1259678	NJ12536	910236
12587 & 12586	45869	53623
1258793	A1253	7589
12587636,12586 & 1253	B12589	4583

help me

    This data in excel file .

To accese data from excel by using DDEel

filename ds dde "Excel|C:\Users\Administrator\Desktop\CVM Metrics\[DEC 2014 Report.xlsx]July 2014!R4C2:R17C6 ";

data pro ;

infile ds;

input plo_no$ nplo_no$ per cam$27. comm ;

informat per dollar11. comm dollar11.;

run;

I have problem all the  values  not policyno.

like this

pol_no	nplo_no	comm
573620	MAC23689	569803
1259678	NJ12536	910236
12587	&  (HERE THE PROBLEM)	12586
1258793	A1253	7589
12587636	.	.

[ballardw]

As a minimum a character variable without an explicit length with default to 8 characters. So expect pol_no nplo_no and cam to be short if they are ever longer than 8. by default list input such as your input statement accepts spaces as delimters be twee values. I don't use DDE for reading but I would not be surprised that the & is being read for NPLO_NO. Since the output you show doesn't quite match your INPUT statement there may be other things going on.