Write and run SAS programs in your web browser

proc mixed data libref not assigned

Accepted Solution Solved
Reply
Occasional Learner
Posts: 1
Accepted Solution

proc mixed data libref not assigned

Hello,

 

I am trying to import data and run a lsmeans in SAS studio (university edition). My code is:

 

proc import datafile="/folders/myshortcuts/sas_folders/cpm_vals_head.tsv"
    out=jd
    dbms=dlm
    replace;
    getnames=yes;
    delimiter='09'x;
run;


proc sort data=work.jd;
by gene UFID;
run;

proc mixed data=work.jd;
by gene;
class UFID row col;
model CPM = UFID /outp = JD.gr;
random row col;
lsmeans UFID;
run;
ods output covparms=JD.cp lsmeans=JD.lsm test3=JD.t3;
run;

 

However when trying to run this I get the error "ERROR: Libref JD is not assigned." and the program does not run after the proc mixed data; line. How can I address this? Do i need to create a library to run mixed models?

 

Thank you,

JD


Accepted Solutions
Solution
‎03-06-2017 06:26 PM
Grand Advisor
Posts: 10,205

Re: proc mixed data libref not assigned

When you use ODS Output the bit after the = is a data set name. When there is period in the name then you have told SAS that the part before the period is a library name, in this case JD.

 

Try;

ods output covparms=JD_cp lsmeans=JD_lsm test3=JD_t3;

to get a prefix to the dataset names.

View solution in original post


All Replies
Solution
‎03-06-2017 06:26 PM
Grand Advisor
Posts: 10,205

Re: proc mixed data libref not assigned

When you use ODS Output the bit after the = is a data set name. When there is period in the name then you have told SAS that the part before the period is a library name, in this case JD.

 

Try;

ods output covparms=JD_cp lsmeans=JD_lsm test3=JD_t3;

to get a prefix to the dataset names.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 2 in conversation