proc mixed data libref not assigned

[JD_UFGI]

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

[ballardw · Accepted solution]

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.