Data Step Object Failure Error

[ManitobaMoose]

Hi.

I am not sure what the problem is. I am merging two data sets. Both have character variables, in which one is called 'Subj' and the other 'ID'. The data sets exist and are in the SasData library. I am not sure why I am getting the Data Setp Object Failure Error saying that

the variable SASdata is not an object. Any help would be appreciated. Thanks!

-------------------------------

libname sasdata '/folders/myfolders/SASData' ;

proc sort data=sasdata.survey ;
    by subj ;
run ;

proc sort data=sasdata.demographicsmy ;
    by ID ;
run ;

Options mergenoby = error ;
data MergeDemoSurvey ;
    Merge sasdata.survey (rename =(subj=ID)) ;
          sasdata.demographicsmy ;
    by ID ;
run ;

Title 'Merge Demographics and Survey 1' ;
proc print data=MergeDemoSurvey noobs ;
run ;
   

[Reeza]

Post your full log

[ShiroAmada · Accepted solution]

i think you closed your merge statement too soon.

Options mergenoby = error ;
data MergeDemoSurvey ;
    Merge sasdata.survey (rename =(subj=ID)) ;
          sasdata.demographicsmy ;
    by ID ;
run ;

Try like this:

Options mergenoby = error ;
data MergeDemoSurvey ;
    Merge sasdata.survey (rename =(subj=ID)) 
          sasdata.demographicsmy ;
    by ID ;
run ;

[ManitobaMoose]

That was it! Thanks!