Thank you your reply. But, can you explain this statement? *import data - you will need to replace this with a data step to read the data. PROC IMPORT guesses at the data types;
proc import datafile=out out=want dbms=csv replace;run; Also, I am getting errors: 82493 informat otherengineinfo $61. ; 82494 informat batterya_to $1. ; 82495 informat batteryv_to $1. ; 82491 informat chargerlevel $1. ;82492 informat chargerpowerkw $1. ; 82496 informat batterykwh_to $1. ; 82497 informat turbo $1. ; 82498 informat baseprice $1. ; 82499 informat batterymodules $1. ; 82500 informat batterypacks $1. ; 82501 informat topspeedmph $1. ; 82502 informat suggestedvin $1. ; 82503 informat errorcode best32. ; 82504 informat possiblevalues $1. ; 82505 informat axleconfiguration $1. ; 82506 informat enginemanufacturer $1. ; 82507 informat buslength $1. ; 82508 informat busfloorconfigtype $14. ; 82509 informat bustype $14. ; 82510 informat otherbusinfo $1. ; 82511 informat custommotorcycletype $1. ; 82512 informat motorcyclesuspensiontype $1. ; 82513 informat motorcyclechassistype $1. ; 82514 informat othermotorcycleinfo $40. ; 82515 informat othertrailerinfo $1. ; 82516 informat additionalerrortext $1. ; 82517 informat cashforclunkers $1. ; 82518 informat trackwidth $1. ; 82519 informat tpms $1. ; 82520 informat activesafetysysnote $1. ; 82521 informat dynamicbrakesupport $14. ; 82522 informat pedestrianautomaticemergencybrak $14. ; 82523 informat autoreversesystem $14. ; 82524 informat automaticpedestrianalertingsound $14. ; 82525 informat can_aacn $14. ; 82526 informat edr $14. ; 82527 informat keylessignition $1. ; 82528 informat daytimerunninglight $14. ; 82529 informat lowerbeamheadlamplightsource $14. ; 82530 informat semiautomaticheadlampbeamswitchi $14. ; 82531 informat adaptivedrivingbeam $14. ; 82532 informat saeautomationlevel $1. ; 82533 informat saeautomationlevel_to $1. ; 82534 informat rearcrosstrafficalert $14. ; 82535 informat gcwr $1. ; 82536 informat gcwr_to $1. ; 82537 informat ncsanote $1. ; 82538 informat ncsamappingexception $1. ; 82539 informat ncsamapexcapprovedon $1. ; 82540 informat ncsamapexcapprovedby $1. ; 82541 informat gvwr_to $1. ; 82542 informat errortext $60. ; 82543 informat rearautomaticemergencybraking $1. ; 82544 informat blindspotintervention $1. ; 82545 informat lanecenteringassistance $1. ; 82546 informat nonlanduse $1. ; 82547 informat vehicledescriptor $11. ; 82548 format makeid best12. ; 82549 format modelid best12. ; 82550 format manufacturerid best12. ; 82551 format vin $17. ; 82552 format batteryinfo $1. ; 82553 format batterytype $1. ; 82554 format bedtype $14. ; 82555 format bodycabtype $14. ; 82556 format bodyclass $36. ; 82557 format enginecylinders best12. ; 82558 format destinationmarket $1. ; 82559 format displacementcc best12. ; 82560 format displacementci best12. ; 82561 format displacementl best12. ; 82562 format doors $1. ; 82563 format drivetype $1. ; 82564 format driverassist $1. ; 82565 format enginecycles best12. ; 82566 format enginemodel $1. ; 82567 format enginekw best12. ; 82568 format entertainmentsystem $1. ; 82569 format fueltypeprimary $8. ; 82570 format gvwr $47. ; 82571 format make $15. ; 82572 format manufacturer $29. ; 82573 format model $30. ; 82574 format modelyear best12. ; 82575 format plantcity $4. ; 82576 format seats $1. ; 82577 format series $1. ; 82578 format steeringlocation $1. ; 82579 format transmissionstyle $1. ; 82580 format trim $1. ; 82581 format vehicletype $10. ; 82582 format windows $1. ; 82583 format axles $1. ; 82584 format brakesystemtype $1. ; 82585 format batterycells $1. ; 82586 format bedlengthin $1. ; 82587 format brakesystemdesc $1. ; 82588 format curbweightlb $1. ; 82589 format airbagloccurtain $1. ; 82590 format airbaglocseatcushion $1. ; 82591 format batterya $1. ; 82592 format batteryv $1. ; 82593 format batterykwh $1. ; 82594 format wheelbasetype $1. ; 82595 format seatrows $1. ; 82596 format valvetraindesign $1. ; 82597 format transmissionspeeds $1. ; 82598 format engineconfiguration $8. ; 82599 format airbaglocfront $1. ; 82600 format fueltypesecondary $1. ; 82601 format fuelinjectiontype $1. ; 82602 format airbaglocknee $1. ; 82603 format enginehp best12. ; 82604 format evdriveunit $1. ; 82605 format plantcountry $19. ; 82606 format plantcompanyname $1. ; 82607 format plantstate $12. ; 82608 format pretensioner $1. ; 82609 format seatbeltsall $1. ; 82610 format adaptivecruisecontrol $14. ; 82611 format adaptiveheadlights $1. ; 82612 format abs $1. ; 82613 format cib $14. ; 82614 format blindspotmon $14. ; 82615 format ncsabodytype $1. ; 82616 format ncsamake $1. ; 82617 format ncsamodel $1. ; 82618 format esc $1. ; 82619 format tractioncontrol $1. ; 82620 format forwardcollisionwarning $14. ; 82621 format lanedeparturewarning $14. ; 82622 format lanekeepsystem $14. ; 82623 format rearvisibilitysystem $14. ; 82624 format parkassist $14. ; 82625 format airbaglocside $1. ; 82626 format trim2 $1. ; 82627 format series2 $1. ; 82628 format wheelbaseshort $1. ; 82629 format wheelbaselong $1. ; 82630 format note $25. ; 82631 format wheels $1. ; 82632 format trailertype $14. ; 82633 format trailerbodytype $14. ; 82634 format trailerlength $1. ; 82635 format wheelsizefront $1. ; 82636 format wheelsizerear $1. ; 82637 format otherrestraintsysteminfo $1. ; 82638 format coolingtype $1. ; 82639 format enginehp_to $1. ; 82640 format electrificationlevel $1. ; 82641 format chargerlevel $1. ; 82642 format chargerpowerkw $1. ; 82643 format otherengineinfo $61. ; 82644 format batterya_to $1. ; 82645 format batteryv_to $1. ; 82646 format batterykwh_to $1. ; 82647 format turbo $1. ; 82648 format baseprice $1. ; 82649 format batterymodules $1. ; 82650 format batterypacks $1. ; 82651 format topspeedmph $1. ; 82652 format suggestedvin $1. ; 82653 format errorcode best12. ; 82654 format possiblevalues $1. ; 82655 format axleconfiguration $1. ; 82656 format enginemanufacturer $1. ; 82657 format buslength $1. ; 82658 format busfloorconfigtype $14. ; 82659 format bustype $14. ; 82660 format otherbusinfo $1. ; 82661 format custommotorcycletype $1. ; 82662 format motorcyclesuspensiontype $1. ; 82663 format motorcyclechassistype $1. ; 82664 format othermotorcycleinfo $40. ; 82665 format othertrailerinfo $1. ; 82666 format additionalerrortext $1. ; 82667 format cashforclunkers $1. ; 82668 format trackwidth $1. ; 82669 format tpms $1. ; 82670 format activesafetysysnote $1. ; 82671 format dynamicbrakesupport $14. ; 82672 format pedestrianautomaticemergencybrak $14. ; 82673 format autoreversesystem $14. ; 82674 format automaticpedestrianalertingsound $14. ; 82675 format can_aacn $14. ; 82676 format edr $14. ; 82677 format keylessignition $1. ; 82678 format daytimerunninglight $14. ; 82679 format lowerbeamheadlamplightsource $14. ; 82680 format semiautomaticheadlampbeamswitchi $14. ; 82681 format adaptivedrivingbeam $14. ; 82682 format saeautomationlevel $1. ; 82683 format saeautomationlevel_to $1. ; 82684 format rearcrosstrafficalert $14. ; 82685 format gcwr $1. ; 82686 format gcwr_to $1. ; 82687 format ncsanote $1. ; 82688 format ncsamappingexception $1. ; 82689 format ncsamapexcapprovedon $1. ; 82690 format ncsamapexcapprovedby $1. ; 82691 format gvwr_to $1. ; 82692 format errortext $60. ; 82693 format rearautomaticemergencybraking $1. ; 82694 format blindspotintervention $1. ; 82695 format lanecenteringassistance $1. ; 82696 format nonlanduse $1. ; 82697 format vehicledescriptor $11. ; 82698 input 82699 makeid 82700 modelid 82701 manufacturerid 82702 vin $ 82703 batteryinfo $ 82704 batterytype $ 82705 bedtype $ 82706 bodycabtype $ 82707 bodyclass $ 82708 enginecylinders 82709 destinationmarket $ 82710 displacementcc 82711 displacementci 82712 displacementl 82713 doors $ 82714 drivetype $ 82715 driverassist $ 82716 enginecycles 82717 enginemodel $ 82718 enginekw 82719 entertainmentsystem $ 82720 fueltypeprimary $ 82721 gvwr $ 82722 make $ 82723 manufacturer $ 82724 model $ 82725 modelyear 82726 plantcity $ 82727 seats $ 82728 series $ 82729 steeringlocation $ 82730 transmissionstyle $ 82731 trim $ 82732 vehicletype $ 82733 windows $ 82734 axles $ 82735 brakesystemtype $ 82736 batterycells $ 82737 bedlengthin $ 82738 brakesystemdesc $ 82739 curbweightlb $ 82740 airbagloccurtain $ 82741 airbaglocseatcushion $ 82742 batterya $ 82743 batteryv $ 82744 batterykwh $ 82745 wheelbasetype $ 82746 seatrows $ 82747 valvetraindesign $ 82748 transmissionspeeds $ 82749 engineconfiguration $ 82750 airbaglocfront $ 82751 fueltypesecondary $ 82752 fuelinjectiontype $ 82753 airbaglocknee $ 82754 enginehp 82755 evdriveunit $ 82756 plantcountry $ 82757 plantcompanyname $ 82758 plantstate $ 82759 pretensioner $ 82760 seatbeltsall $ 82761 adaptivecruisecontrol $ 82762 adaptiveheadlights $ 82763 abs $ 82764 cib $ 82765 blindspotmon $ 82766 ncsabodytype $ 82767 ncsamake $ 82768 ncsamodel $ 82769 esc $ 82770 tractioncontrol $ 82771 forwardcollisionwarning $ 82772 lanedeparturewarning $ 82773 lanekeepsystem $ 82774 rearvisibilitysystem $ 82775 parkassist $ 82776 airbaglocside $ 82777 trim2 $ 82778 series2 $ 82779 wheelbaseshort $ 82780 wheelbaselong $ 82781 note $ 82782 wheels $ 82783 trailertype $ 82784 trailerbodytype $ 82785 trailerlength $ 82786 wheelsizefront $ 82787 wheelsizerear $ 82788 otherrestraintsysteminfo $ 82789 coolingtype $ 82790 enginehp_to $ 82791 electrificationlevel $ 82792 chargerlevel $ 82793 chargerpowerkw $ 82794 otherengineinfo $ 82795 batterya_to $ 82796 batteryv_to $ 82797 batterykwh_to $ 82798 turbo $ 82799 baseprice $ 82800 batterymodules $ 82801 batterypacks $ 82802 topspeedmph $ 82803 suggestedvin $ 82804 errorcode 82805 possiblevalues $ 82806 axleconfiguration $ 82807 enginemanufacturer $ 82808 buslength $ 82809 busfloorconfigtype $ 82810 bustype $ 82811 otherbusinfo $ 82812 custommotorcycletype $ 82813 motorcyclesuspensiontype $ 82814 motorcyclechassistype $ 82815 othermotorcycleinfo $ 82816 othertrailerinfo $ 82817 additionalerrortext $ 82818 cashforclunkers $ 82819 trackwidth $ 82820 tpms $ 82821 activesafetysysnote $ 82822 dynamicbrakesupport $ 82823 pedestrianautomaticemergencybrak $ 82824 autoreversesystem $ 82825 automaticpedestrianalertingsound $ 82826 can_aacn $ 82827 edr $ 82828 keylessignition $ 82829 daytimerunninglight $ 82830 lowerbeamheadlamplightsource $ 82831 semiautomaticheadlampbeamswitchi $ 82832 adaptivedrivingbeam $ 82833 saeautomationlevel $ 82834 saeautomationlevel_to $ 82835 rearcrosstrafficalert $ 82836 gcwr $ 82837 gcwr_to $ 82838 ncsanote $ 82839 ncsamappingexception $ 82840 ncsamapexcapprovedon $ 82841 ncsamapexcapprovedby $ 82842 gvwr_to $ 82843 errortext $ 82844 rearautomaticemergencybraking $ 82845 blindspotintervention $ 82846 lanecenteringassistance $ 82847 nonlanduse $ 82848 vehicledescriptor $ 82849 ; 82850 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 82851 run; NOTE: The infile OUT is: Filename=C:\Users\kbhagat\AppData\Local\Temp\SAS Temporary Files\_TD2644_STAPA-700675_\#LN00245, RECFM=V,LRECL=32767,File Size (bytes)=3116, Last Modified=13Dec2023:12:15:23, Create Time=13Dec2023:12:15:23 NOTE: 1 record was read from the infile OUT. The minimum record length was 984. The maximum record length was 984. NOTE: The data set WORK.WANT has 1 observations and 150 variables. NOTE: DATA statement used (Total process time): real time 40.40 seconds cpu time 0.89 seconds 1 rows created in WORK.WANT from OUT. NOTE: WORK.WANT data set was successfully created. NOTE: The data set WORK.WANT has 1 observations and 150 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 40.62 seconds cpu time 1.09 seconds NOTE: Fileref OUT has been deassigned. NOTE: Appending WORK.WANT to WORK.VIN_DATA. WARNING: Variable bodyclass has different lengths on BASE and DATA files (BASE 20 DATA 36). WARNING: Variable model has different lengths on BASE and DATA files (BASE 4 DATA 30). WARNING: Variable otherengineinfo has different lengths on BASE and DATA files (BASE 1 DATA 61). ERROR: No appending done because of anomalies listed above. Use FORCE option to append these files. NOTE: 0 observations added. NOTE: The data set WORK.VIN_DATA has 1 observations and 150 variables. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. 541 + proc datasets lib=work nodetails nolist; delete want; run; NOTE: Deleting WORK.WANT (memtype=DATA). 541 + quit; NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 541 + ; 542 + *set up space for api response; filename out temp; *send API call; 542 + proc http url="https://vpic.nhtsa.dot.gov/api/vehicles/DecodeVinValues/1HD1FFW121Y603975?format=csv&modely ear=." method="get" out=out; run; WARNING: Apparent symbolic reference MODELYEAR not resolved. NOTE: 200 OK NOTE: PROCEDURE HTTP used (Total process time): real time 0.11 seconds cpu time 0.00 seconds
... View more