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

Base Prep Guide Data w/ SAS Studio ON DEMAND

Nyioves — Mon, 24 Aug 2015 20:53:28 GMT

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?

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

Nyioves — Mon, 24 Aug 2015 20:59:21 GMT

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.

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

Reeza — Mon, 24 Aug 2015 21:32:12 GMT

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.

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

Nyioves — Mon, 24 Aug 2015 21:58:29 GMT

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

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

Cynthia_sas — Tue, 25 Aug 2015 00:49:34 GMT

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

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

Nyioves — Wed, 26 Aug 2015 09:00:43 GMT

It worked! Thank you Cynthia!