How to read excel data to sas by using

tlnarayana26 — Mon, 09 Feb 2015 11:05:59 GMT

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	.	.

Re: How to read excel data to sas by using

ballardw — Mon, 09 Feb 2015 16:36:53 GMT

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.

topic How to read excel data to sas by using in SAS Programming

How to read excel data to sas by using

Re: How to read excel data to sas by using