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