topic Re: Data Step Object Failure Error in SAS Programming

Data Step Object Failure Error

ManitobaMoose — Mon, 11 Sep 2017 02:38:25 GMT

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 ;

Re: Data Step Object Failure Error

Reeza — Mon, 11 Sep 2017 02:39:26 GMT

Post your full log

Re: Data Step Object Failure Error

ShiroAmada — Mon, 11 Sep 2017 04:54:16 GMT

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 ;

Re: Data Step Object Failure Error

ManitobaMoose — Mon, 11 Sep 2017 15:59:47 GMT

That was it! Thanks!