Hi, I'm new at SAS so I hope my description is accurrate. I'm using SAS Enterprise Guide 9.4. I'm working with databases available in a remote server, and I am trying to calculate an average on two variables. Here is my code: proc sql; create table "AVG1" as SELECT *, AVG(RMEANIMT+LMEANIMT) AS AVG1 FROM WORK.QUERY_FOR_APPEND_TABLE; QUIT; Here is the log: proc sql CREATE TABLE "AVG 1" AS SELECT *, AVG(RMEANIMT+LMEANIMT) AS AVG1 FROM WORK.QUERY_FOR_APPEND_TABLE; NOTE: The query requieres remerging summary statistics back with the original data ERROR: User does not have appropriate authorization level for library WC000001. However I don't have any library with that name. My guess is that it comes from the WORK library but I'm not sure how to reference it. Thank you!.
... View more