Base Prep Guide Data w/ SAS Studio ON DEMAND

Reply
Contributor
Posts: 35

Base Prep Guide Data w/ SAS Studio ON DEMAND

I know this has been brought up before and I've read a thread along the same lines but, it does not help....

Can you in fact use the sample data w On Demand for academics?

Contributor
Posts: 35

Re: Base Prep Guide Data w/ SAS Studio ON DEMAND

When I run the code I get errors in the log. Is there a work around....

ERROR: Write access to member SASUSER.ADMIT.DATA is denied.

ERROR: Write access to member SASUSER.ADMITJUNE.DATA is denied.

ERROR: Write access to member SASUSER.BEFORE.DATA is denied.

ERROR: Write access to member SASUSER.CLTRIALS.DATA is denied.

ERROR: Write access to member SASUSER.COMPANY.DATA is denied.

ERROR: Write access to member SASUSER.CREDIT.DATA is denied.

ERROR: Write access to member SASUSER.DEMOG.DATA is denied.

ERROR: Write access to member SASUSER.DIABETES.DATA is denied.

ERROR: Write access to member SASUSER.EUROPE.DATA is denied.

ERROR: Write access to member SASUSER.FINANCE.DATA is denied.

ERROR: Write access to member SASUSER.FITCLASS.DATA is denied.

ERROR: Write access to member SASUSER.FUNDDRIVE.DATA is denied.

ERROR: Write access to member SASUSER.FUNDDRV.DATA is denied.

ERROR: Write access to member SASUSER.HEART.DATA is denied.

ERROR: Write access to member SASUSER.INSURE.DATA is denied.

ERROR: Write access to member SASUSER.LAGUARDIA.DATA is denied.

ERROR: Write access to member SASUSER.LOANS.DATA is denied.

ERROR: Write access to member SASUSER.MEASURE.DATA is denied.

ERROR: Write access to member SASUSER.NEWLOANS.DATA is denied.

ERROR: Write access to member SASUSER.NEWADMIT.DATA is denied.

ERROR: Write access to member SASUSER.PATIENTS.DATA is denied.

ERROR: Write access to member SASUSER.RECORDS.DATA is denied.

ERROR: Write access to member SASUSER.REPERTORY.DATA is denied.

ERROR: Write access to member SASUSER.REPS.DATA is denied.

ERROR: Write access to member SASUSER.SCH.DATA is denied.

ERROR: Write access to member SASUSER.STRESS.DATA is denied.

ERROR: Write access to member SASUSER.STRESS2.DATA is denied.

ERROR: Write access to member SASUSER.STRESS98.DATA is denied.

ERROR: Write access to member SASUSER.STRESS99.DATA is denied.

ERROR: Write access to member SASUSER.STRESSTEST.DATA is denied.

ERROR: Write access to member SASUSER.SURVEY.DATA is denied.

ERROR: Write access to member SASUSER.TALENT.DATA is denied.

ERROR: Write access to member SASUSER.THERAPY.DATA is denied.

ERROR: Write access to member SASUSER.THERAPY1999.DATA is denied.

ERROR: Write access to member SASUSER.THERAPY2000.DATA is denied.

ERROR: Write access to member SASUSER.TOTALS2000.DATA is denied.

ERROR: Write access to member SASUSER.USA.DATA is denied.

ERROR: Write access to member SASUSER.VISIT.DATA is denied.

ERROR: Write access to member SASUSER.MECHANICS.DATA is denied.

ERROR: Write access to member SASUSER.NAVIGATORS.DATA is denied.

ERROR: Write access to member SASUSER.PILOTS.DATA is denied.

ERROR: Write access to member SASUSER.SALARY.DATA is denied.

ERROR: Write access to member SASUSER.STAFF.DATA is denied.

ERROR: Write access to member SASUSER.TEMP.DATA is denied.

ERROR: Write access to member SASUSER.TEMPS.DATA is denied.

ERROR: Write access to member SASUSER.FLIGHTDELAYS.DATA is denied.

ERROR: Write access to member SASUSER.FLIGHTSCHEDULE.DATA is denied.

ERROR: Write access to member SASUSER.FREQUENTFLYERS.DATA is denied.

ERROR: Write access to member SASUSER.INTERNATIONALFLIGHTS.DATA is denied.

ERROR: Write access to member SASUSER.MARCHFLIGHTS.DATA is denied.

ERROR: Write access to member SASUSER.MECHANICSLEVEL1.DATA is denied.

ERROR: Write access to member SASUSER.MECHANICSLEVEL2.DATA is denied.

ERROR: Write access to member SASUSER.MECHANICSLEVEL3.DATA is denied.

ERROR: Write access to member SASUSER.MONTHLY.DATA is denied.

ERROR: Write access to member SASUSER.PAYROLLCHANGES.DATA is denied.

ERROR: Write access to member SASUSER.PAYROLLMASTER.DATA is denied.

ERROR: Write access to member SASUSER.QSALES.DATA is denied.

ERROR: Write access to member SASUSER.STAFFCHANGES.DATA is denied.

ERROR: Write access to member SASUSER.STAFFMASTER.DATA is denied.

ERROR: Write access to member SASUSER.SUPERVISORS.DATA is denied.

ERROR: File SASUSER.STAFFMASTER.DATA does not exist.

ERROR: File SASUSER.PAYROLLMASTER.DATA does not exist.

ERROR: Write access to member SASUSER.ACITIES.DATA is denied.

ERROR: Write access to member SASUSER.AIRPORTS.DATA is denied.

ERROR: Write access to member SASUSER.ALLEMPS.DATA is denied.

ERROR: Write access to member SASUSER.CAP2000.DATA is denied.

ERROR: Write access to member SASUSER.CAP2001.DATA is denied.

ERROR: Write access to member SASUSER.CAPACITY.DATA is denied.

ERROR: Write access to member SASUSER.CAPINFO.DATA is denied.

ERROR: Write access to member SASUSER.CARGOREV.DATA is denied.

ERROR: Write access to member SASUSER.CARGO99.DATA is denied.

ERROR: File SASUSER.CARGO99.DATA does not exist.

ERROR: Write access to member SASUSER.CARGO99.DATA is denied.

ERROR: Write access to member SASUSER.COMPETE.DATA is denied.

ERROR: Write access to member SASUSER.CONTRIB.DATA is denied.

ERROR: Write access to member SASUSER.CTARGETS.DATA is denied.

ERROR: Write access to member SASUSER.DNUNDER.DATA is denied.

ERROR: Write access to member SASUSER.ECONTRIB.DATA is denied.

ERROR: Write access to member SASUSER.EMPDATA.DATA is denied.

ERROR: File SASUSER.EMPDATA.DATA does not exist.

ERROR: Write access to member SASUSER.EMPDATA.DATA is denied.

ERROR: Write access to member SASUSER.EMPDATU.DATA is denied.

ERROR: Write access to member SASUSER.EMPDATU2.DATA is denied.

ERROR: Write access to member SASUSER.EXPENSES.DATA is denied.

ERROR: Write access to member SASUSER.FLIGHTS.DATA is denied.

ERROR: Write access to member SASUSER.FLIGHTS2.DATA is denied.

ERROR: Write access to member SASUSER.FLIGHTTIMES.DATA is denied.

ERROR: Write access to member SASUSER.JCODEDAT.DATA is denied.

ERROR: Write access to member SASUSER.JOBHSTRY.DATA is denied.

ERROR: Write access to member SASUSER.MEALPLAN.DATA is denied.

ERROR: Write access to member SASUSER.MONTHSUM.DATA is denied.

ERROR: Write access to member SASUSER.NEWCGNUM.DATA is denied.

ERROR: Write access to member SASUSER.NEWEMPS.DATA is denied.

ERROR: Write access to member SASUSER.NEWRTNUM.DATA is denied.

ERROR: Write access to member SASUSER.NEWSALS.DATA is denied.

ERROR: Write access to member SASUSER.NEWTIMES.DATA is denied.

ERROR: Write access to member SASUSER.PILOTEMP.DATA is denied.

ERROR: Write access to member SASUSER.QUARTER2.DATA is denied.

ERROR: Write access to member SASUSER.QUARTER3.DATA is denied.

ERROR: Write access to member SASUSER.QUARTER4.DATA is denied.

ERROR: Write access to member SASUSER.REVENUE.DATA is denied.

ERROR: Write access to member SASUSER.SALCOMPS.DATA is denied.

ERROR: Write access to member SASUSER.SALE2000.DATA is denied.

ERROR: Write access to member SASUSER.TARGET.DATA is denied.

ERROR: Write access to member SASUSER.VCRSALES.DATA is denied.

ERROR: Write access to member SASUSER.WCHILL.DATA is denied.

ERROR: Write access to member SASUSER.WESTAUST.DATA is denied.

ERROR: Write access to member SASUSER.YEAR2000.DATA is denied.

ERROR: Write access to member SASUSER.Y2000.DATA is denied.

ERROR: Write access to member SASUSER.Y200061.DATA is denied.

ERROR: Write access to member SASUSER.Y200062.DATA is denied.

ERROR: Write access to member SASUSER.STUDENTS.DATA is denied.

ERROR: Write access to member SASUSER.SCHEDULE.DATA is denied.

ERROR: Write access to member SASUSER.COURSES.DATA is denied.

ERROR: Write access to member SASUSER.REGISTER.DATA is denied.

ERROR: Write access to member SASUSER.ALL.VIEW is denied.

ERROR: SQL view was not defined due to errors.

Super User
Posts: 17,758

Re: Base Prep Guide Data w/ SAS Studio ON DEMAND

What code did you submit to generate those errors?

You can most likely use the data sets, but perhaps not upload new datasets.

You can always use SAS UE which is similar to SAS On Demand for Academics - and free.

Contributor
Posts: 35

Re: Base Prep Guide Data w/ SAS Studio ON DEMAND

/*******************************************************************\     
| Copyright (C) 2012 by SAS Institute Inc., Cary, NC, USA.      |     
|                                                               |     
| SAS (R) is a registered trademark of SAS Institute Inc.       |     
|                                                               |     
| This program sets up practice data for some of the examples   |
| in the Certification Prep Guide: Base Programming for SAS 9.  |
|                                                               |
| Last updated: July 8, 2015                                    |
\*******************************************************************/     

options nosource nonotes nocardimage validvarname=V7 replace;

   /* create sample data */

data _null_;

   /* determine fileref paths, delimiters, file options */

   length fileno fileyes $18 fileset $ 1024;

   oshost=trim(substr(symget('sysscp'),1,2));

   filepath=trim(pathname("sasuser"));

  if (oshost = "OS") and (length(symget('sysscp'))=2) then
     do;
        filepath=scan(filepath,1);
        dlm=".";
        fileno="disp=(new,catlg)";
        fileyes="disp=(old,catlg)";
     end;
  else do;
     host=trim(substr(symget('sysscp'),1,3));
        if (host in ('WIN','OS2')) then
           do;
              filepath=trim(pathname("sasuser"));
              dlm="\";
              fileno="";
              fileyes="";
           end;
       else if (host = "VMS") then
           do;
              filepath="";
              dlm="";
              fileno="";
              fileyes="";
           end;
       else
           do;
              filepath=trim(pathname("sasuser"));
              dlm="/";
              fileno="";
              fileyes="";
           end;
  end;

   /* assign filerefs */

   array filelst1{8} $ filesas1-filesas8 ('accnt','accnt01','accnt02',

                                      'accnt03',
                                      'accnt04','activity','fee',
                                      'printfee');
  do i=1 to dim(filelst1);
     if (host = "CMS") then fileset=trim(filelst1(i)) || " sas *";
     else fileset=trim(filepath) || dlm || trim(filelst1(i)) || ".sas";
     isfile=fileexist(fileset);
     if isfile=1 then fileopts=trim(fileyes);
     else fileopts=trim(fileno);
     rc=filename(filelst1(i),fileset,"",fileopts);
  end;

   array filelst2{48} $ filedt1-filedt48 ('admit','aprdata','aug99dat',

     'bookdata','cardata','census','choldata','citydata','credit2','credit3',
     'credit4','credit5','creditc','creditcr','cc','cccomma','data97',
     'empdata','excdata1',
     'excdata2','excdata3','exer','group3','invent','invent1','invent2',
     'jan98dat','loan','memdata','newloans','orderdat','patdata','personel',
     'phonsurv','powerdat','pubdata','rawdata','salary','saledata','satdata1','satdata2',
     'stordata','survey1','tempdata','tests','tests2','topten', 'vandata');
  do i=1 to dim(filelst2);
     if (host="CMS") then fileset=trim(filelst2(i)) || " data *";
     else fileset=trim(filepath) || dlm || trim(filelst2(i)) || ".dat";
     isfile=fileexist(fileset);
     if isfile=1 then fileopts=trim(fileyes);
     else fileopts=trim(fileno);
     rc=filename(filelst2(i),fileset,"",fileopts);
  end;

run;

SAS Super FREQ
Posts: 8,740

Re: Base Prep Guide Data w/ SAS Studio ON DEMAND

Hi:

 

  The  SAS University Edition did not exist at the time the original program for the Prep Guides was written, so the program is currently designed to work on a machine where the student has write access to the SASUSER library. But, this is not the case with the University Edition or SAS OnDemand -- in those interfaces, the SASUSER library is a read-only library. This presents an issue if you try to run the program used for the Prep Guides, as originally written, the program will generate error messages.

  

  As I indicated in previous Community Forums postings, you can continue to use SAS Studio and the SAS University Edition or SAS OnDemand for Academics with the Base Programmer Certification Prep Guide, and you can also use the SAME data with the Advanced Programmer Certification Prep Guide.

   

  To make the data you need to follow the instructions in the attached web page: http://support.sas.com/publishing/cert/basecertguide3.html.

  Basically, you will make a folder, (we recommend naming the folder certprep) either in your /home directory on the SAS OnDemand server or in your /folders/myfolders directory and then you will tell SAS that your SASUSER library should use the alternate folder location (where you DO  have write access).

cynthia

:

Contributor
Posts: 35

Re: Base Prep Guide Data w/ SAS Studio ON DEMAND

It worked! Thank you Cynthia!

Ask a Question
Discussion stats
  • 5 replies
  • 433 views
  • 0 likes
  • 3 in conversation