Base Prep Guide Data w/ SAS Studio ON DEMAND

[Nyioves]

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?

[Nyioves]

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.

[Reeza]

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.

[Nyioves]

/*******************************************************************\
| 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;

[Cynthia_sas]

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

:

[Nyioves]

It worked! Thank you Cynthia!