BookmarkSubscribeRSS Feed
lavernal
Calcite | Level 5

Hi all,

I am trying to use proc import to create a SAS database. In particular, one of my columns contain CUSIP data, in which some are 9 digits numbers while some contain a mix of numbers and characters. Thus, I want to make SAS read in that column as character rather than numeric variables, however, the first few rows of my data are all numeric rather than a mix of numeric and character, thus SAS reads in that column as numeric.

Is there a way to just change that column format into character while keeping the other columns as default? I have quite alot of columns so would hope not to have to redefine all columns.

Thank you for any help!

1 REPLY 1
Jagadishkatam
Amethyst | Level 16

Hi ,

Please include the below statement in the proc import code, this will convert the numeric data to character values. This will help you to change the variable into character where there is numeric as well as character data, other columns will be as they are.

MIXED=YES;

Thanks,

Jagadish

Thanks,
Jag

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

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
  • 1044 views
  • 0 likes
  • 2 in conversation