BookmarkSubscribeRSS Feed
ncross
Calcite | Level 5

Hi all

Experiencing difficulties with import of a large database. I can import the csv file successively however SAS replaces the values with one digit equivilents. For example; 123999 would become 1. 5677 would become 5. How can I prevent this? The file is not of much use to me if it replaces the characters.

The current command I am using is:

PROC IMPORT OUT= WORK.MoreAccVar          

DATAFILE= "C:\Users\253507F\Desktop\accountingVar.csv"           

DBMS=CSV REPLACE;     GETNAMES=YES;     DATAROW=2; RUN;

1 REPLY 1
ballardw
Super User

It is generally not necessary to post the same request multiple times on this board.

Look for answers in your "Import Problem" thread.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1062 views
  • 0 likes
  • 2 in conversation