how to set a table of one code in another code with same libname

[annypanny]

I have two codes casestudy1 and casestudy2 with same libname.

libname sas "c:\mysaslib" access=readonly;

now I want to append a table final1 of casestudy1:

proc transpose data = fp
out = final1
by Scheme name;
var performance;
run;

with another table final 2 of casestudy2:

proc transpose data = perf
out = final2;
by Number name;
var performance;
run;

I have done the coding in casestudy2 as,

Data final_perf;
set sas.final1;
run;

proc append base-final1 data=final2;

run;

but getting error as final1 does not exist.

How can I solve this issue?

[Kurt_Bremser]

There seems to be an ERROR in your first step, so final1 is not created. If that is not the case, make sure that all this runs in one session with one WORK.

Post your whole log of all these steps if you still have problems.

[annypanny]

24 Data final;
25 set sas.final1;
ERROR: File SAS.FINAL1.DATA does not exist.
26 run;

NOTE: Compression was disabled for data set WORK.FINAL because compression overhead would increase the size of the data set.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.FINAL may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.FINAL was not replaced because this step was stopped.

[Jagadishkatam]

Seems like you are not saving the final1 in sas library, you need to update the proc transpose step to use out=sas.final1 to again use the sas.final1 in later steps.

proc transpose data = fp
out = sas.final1
by Scheme name;
var performance;
run;

[Kurt_Bremser]

You really need to take care to READ everything that is asked:

Post your whole log of all these steps if you still have problems.

[biopharma]

Problem is here.
Data final_perf;
*set sas.final1; /* wrong */
set final1 ; /* you have saved FINAL1 to the work library */
run;