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;

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 1806 views
  • 0 likes
  • 3 in conversation