Dataset cut short after proc import

ernie86 — Mon, 28 Jan 2019 20:58:50 GMT

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;

Re: Dataset cut short after proc import

Reeza — Mon, 28 Jan 2019 21:08:04 GMT

Check your settings for the VALIDVARNAME option and make sure they're the same across the two systems.

Re: Dataset cut short after proc import

SASKiwi — Mon, 28 Jan 2019 21:08:41 GMT

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

topic Dataset cut short after proc import in SAS Enterprise Guide

Dataset cut short after proc import

Re: Dataset cut short after proc import

Re: Dataset cut short after proc import