How to read excel data to sas by using

Reply
Contributor
Posts: 42

How to read excel data to sas by using

plo_no
nplo_no
comm
573620MAC23689569803
1259678NJ12536910236
12587 & 125864586953623
1258793A12537589
12587636,12586 & 1253B125894583

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
573620MAC23689569803
1259678NJ12536910236
12587&  (HERE THE PROBLEM)12586
1258793A12537589
12587636..
Super User
Posts: 11,343

Re: How to read excel data to sas by using

Posted in reply to tlnarayana26

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.

Ask a Question
Discussion stats
  • 1 reply
  • 138 views
  • 0 likes
  • 2 in conversation