topic Re: Store Procedure and Proc PLM in SAS University Edition in SAS Studio

Store Procedure and Proc PLM in SAS University Edition

ksn999 — Wed, 23 Jan 2019 16:05:26 GMT

Hi all,

I can't get the Store command to work in SAS University Edition. I get the error message that the file ' NEFA.vc' does not exist or is not a valid item store when I try to use my stored data in the proc plm procedure. I have tried everything I can think of, creating a new library (NEFA), changing the dataset location, using an 'out=' under the store statement, etc. I can't find any resources with a solution online so thought I would post my question here. My code is as follows:

libname NEFA '/folders/myfolders/';

data NEFA.revisions;
set revisions;
run;

proc mixed data=NEFA.revisions;
class condition time Subject_ID;
model glucose=condition time time*condition / ddfm=Kenwardroger;
random Subject_ID;
repeated condition / subject=Subject_ID rcorr;
store NEFA.vc;
run;

proc plm source=NEFA.vc;
lsmeans condition / adjust=tukey lines plot=meanplot;
run;

Any help would be much appreciated! Thanks!

Re: Store Procedure and Proc PLM in SAS University Edition

Reeza — Wed, 23 Jan 2019 16:08:24 GMT

Can you run a PROC CONTENTS right after your first data step, check what is in your data set. Post the output here if you need to.

data NEFA.revisions;
set revisions;
run;

proc contents data=nefa.revisions;
run;

@ksn999 wrote:

Hi all,

I can't get the Store command to work in SAS University Edition. I get the error message that the file ' NEFA.vc' does not exist or is not a valid item store when I try to use my stored data in the proc plm procedure. I have tried everything I can think of, creating a new library (NEFA), changing the dataset location, using an 'out=' under the store statement, etc. I can't find any resources with a solution online so thought I would post my question here. My code is as follows:

libname NEFA '/folders/myfolders/';

data NEFA.revisions;
set revisions;
run;

proc mixed data=NEFA.revisions;
class condition time Subject_ID;
model glucose=condition time time*condition / ddfm=Kenwardroger;
random Subject_ID;
repeated condition / subject=Subject_ID rcorr;
store NEFA.vc;
run;

proc plm source=NEFA.vc;
lsmeans condition / adjust=tukey lines plot=meanplot;
run;

Any help would be much appreciated! Thanks!

Re: Store Procedure and Proc PLM in SAS University Edition

ksn999 — Wed, 23 Jan 2019 16:15:45 GMT

Proc contents works just fine. Everything works perfectly except the store command. I get output from the proc mixed procedure, but then proc plm can't use the output. Here is a screenshot of the proc contents output:

Re: Store Procedure and Proc PLM in SAS University Edition

Reeza — Wed, 23 Jan 2019 16:41:06 GMT

Try changing your STORE line to:

Store out=nfea.vc;

Re: Store Procedure and Proc PLM in SAS University Edition

ksn999 — Wed, 23 Jan 2019 16:45:18 GMT

Thanks Reeza, I’ve already tried that, it doesn’t work. I get the same error message.

Re: Store Procedure and Proc PLM in SAS University Edition

Reeza — Wed, 23 Jan 2019 16:50:43 GMT

Show your full log please.

Re: Store Procedure and Proc PLM in SAS University Edition

Reeza — Wed, 23 Jan 2019 16:58:07 GMT

This was as close as I could get to your question, without data and finding fake data.

The only thing missing is the RANDOM portion.

Does this work for you in SAS UE?

data pr;
   input Person Gender $ y1 y2 y3 y4;
   y=y1; Age=8;  output;
   y=y2; Age=10; output;
   y=y3; Age=12; output;
   y=y4; Age=14; output;
   drop y1-y4;
   datalines;
 1   F   21.0    20.0    21.5    23.0
 2   F   21.0    21.5    24.0    25.5
 3   F   20.5    24.0    24.5    26.0
 4   F   23.5    24.5    25.0    26.5
 5   F   21.5    23.0    22.5    23.5
 6   F   20.0    21.0    21.0    22.5
 7   F   21.5    22.5    23.0    25.0
 8   F   23.0    23.0    23.5    24.0
 9   F   20.0    21.0    22.0    21.5
10   F   16.5    19.0    19.0    19.5
11   F   24.5    25.0    28.0    28.0
12   M   26.0    25.0    29.0    31.0
13   M   21.5    22.5    23.0    26.5
14   M   23.0    22.5    24.0    27.5
15   M   25.5    27.5    26.5    27.0
16   M   20.0    23.5    22.5    26.0
17   M   24.5    25.5    27.0    28.5
18   M   22.0    22.0    24.5    26.5
19   M   24.0    21.5    24.5    25.5
20   M   23.0    20.5    31.0    26.0
21   M   27.5    28.0    31.0    31.5
22   M   23.0    23.0    23.5    25.0
23   M   21.5    23.5    24.0    28.0
24   M   17.0    24.5    26.0    29.5
25   M   22.5    25.5    25.5    26.0
26   M   23.0    24.5    26.0    30.0
27   M   22.0    21.5    23.5    25.0
;


   
proc mixed data=pr method=ml covtest;
   class Person Gender;
   model y = Gender Age Gender*Age / s ddfm=kenwardroger;
   repeated / type=un subject=Person r;
   store out=myDemo;
run;

proc plm source=myDemo;
lsmeans gender / adjust = tukey lines plot=meanplot;
run;

Re: Store Procedure and Proc PLM in SAS University Edition

ksn999 — Wed, 23 Jan 2019 20:27:31 GMT

Hey Reeza,

Sorry for the delay in responding, I've been in meetings. Yes, I can run the code you posted perfectly. I was about to copy over the logbook and attach it here when I realized the logbook said that the model failed to converge and so deleted the output file, which I think is the answer to the problem I've been having! Anyways, thanks again!