BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ernie86
Calcite | Level 5

The dataset I would like to import has some repeat column names, but changing the column names in the raw dataset is not an option. When I run the following script, SAS is deleting all the columns that have repeating column names. However, when my colleague runs the exact same script in his machine, SAS is automatically renaming the repeat column names with adding _1, _2...at the end. We would like to import the dataset with SAS renaming the repeat column names instead of deleting them. We are not sure if that has something to do with SAS EG setup? Or can we add something in the following script to make the import consistent. 

 

proc import out=WORK.SURVEY_00_Import
datafile = "J:\DATA\Appeals Eligibility Rescoring Tool\Input\Survey Extract Raw.sav"
dbms = SAV replace;
fmtlib = WORK.FORMATS;
run;

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

Try this in your SAS session: options VALIDVARNAME = V7;

View solution in original post

2 REPLIES 2
Reeza
Super User
Check your settings for the VALIDVARNAME option and make sure they're the same across the two systems.
SASKiwi
PROC Star

Try this in your SAS session: options VALIDVARNAME = V7;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 2 replies
  • 1640 views
  • 0 likes
  • 3 in conversation