topic Re: cre8data.sas in New SAS User

cre8data.sas

DWhite — Thu, 22 Aug 2019 17:54:34 GMT

Hello. I am trying to learn more about how the cre8data.sas works and solve a problem. We have a SAS Studio solution running on our campus and an instructuor is using SAS training materials. The current cre8data.sas includes a setup.sas and p199d00.sas. The setup worked correctly on our system and populated our test user folder just fine in SAS Studio.

The instructor has another zip folder "pg194.zip" that has data and sas files but does not include a cre8data.sas or setup file, but does include the p194.sas script.

A couple questions?

1. Can I modify the cre8data.sas and setup.sas files to work with pg194, if so, can you provide a link to documentation?

2. Are the files (cre8data.sas and setup.sas) available for the pg194 and can be shared?

Thanks.

Re: cre8data.sas

ballardw — Thu, 22 Aug 2019 18:13:10 GMT

Best would be to provide the code of the PG194.SAS file. Then we can ask intelligent questions about what you already have.

Typically I would expect to see something related to 1) assigning SAS library 2) and code to read any input files.

There is likely nothing "magic" about either of your Cre8data or Setup SAS program file names, the important part is the content of the code.

Did your instructor provide any additional instruction in class or a documentation file in the ZIP archive with what to do?

Re: cre8data.sas

Reeza — Thu, 22 Aug 2019 19:39:00 GMT

Do you know the course he's taken the instructions from? If so, you can always sign up for that and see the full instructions and there's video instructions on the set up that you can link to directly.

However, you could also just populate those folders and files for all students automatically instead of making them each run the set up steps to avoid any issues as well via a batch script that would just copy the files to all the user folders provided.

Re: cre8data.sas

Cynthia_sas — Fri, 23 Aug 2019 18:07:04 GMT

Hi:
Sometimes instructors can request an Academic Trainer's kit and in that case, there might be a zip file that includes other assets used for the class. Typically we use different zip file names for different types of classes -- so a Live Web class will use one name for a zip file; the Classroom version of the class will use a different name and the e-learning version of the class may use a third name. It really depends on which class. In many of our classroom classes, we use a file called cre8data.sas with some hardcoded locations (for S:\workshop or c:\workshop) because that is the data location on our classroom image.

Without knowing exactly how your instructor got the zip files and from whom, it is hard to comment. If you want to watch the data creation videos for the current version of the Programming 1 e-learning class, you will find those videos here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-access-data-for-SAS-Programming-1-course/ta-p/494585 and you will see the names of the zip files and the programs we use for the current e-learning class in the videos. There are several SAS Studio videos and you have to follow the right set of instructions for your method of using SAS.

Since I don't know how your instructor got so many different files for Programming 1 or how old the files are, my recommendation would be that you or the instructor send mail to training@sas.com if the zip files came from taking a SAS Education class or send mail to academics@sas.com if the zip files came from an Academic Trainer's Kit.

We did have an older version of Programming 1 with 12 Lessons (the current version has 7 Lessons), as described here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-data-for-Programming-1-and-Programming-2-e/ta-p/494541 the instructions were different for the older course and used a different zip file than used in the newer course. So going back to the source of the zip files may be the quickest way to find out the answer.

My recommendation is that you do NOT try to mix and match from the zip files. We did not design the programs from different classes and different formats to be interchangeable.

Hope this helps,
Cynthia

Re: cre8data.sas

DWhite — Mon, 26 Aug 2019 12:18:08 GMT

Attached is the p194.sas file. I believe that it generates data sets. I included only a snippet.

/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 WARNING: STUDENTS, DO NOT EXECUTE THIS PROGRAM! INSTEAD,
          EXIT AND EXECUTE THE CRE8DATA.SAS PROGRAM TO SETUP 
          YOUR COURSE DATA ENVIRONMENT.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/

/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 WARNING: DO NOT ALTER CODE BELOW THIS LINE 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/

options linesize=256;

data PG1.CLASS_BIRTHDATE;
   attrib Name length=$8;
   attrib Sex length=$1;
   attrib Age length=8;
   attrib Height length=8;
   attrib Weight length=8;
   attrib Birthdate length=8;

   infile datalines dsd;
   input
      Name
      Sex
      Age
      Height
      Weight
      Birthdate
   ;
datalines4;
Alfred,M,14,69,112.5,16370
Alice,F,13,56.5,84,16756
Barbara,F,13,65.3,98,16451
Carol,F,14,62.8,102.5,16256
Henry,M,14,63.5,102.5,16406
James,M,12,57.3,83,16967
Jane,F,12,59.8,84.5,16873
Janet,F,15,62.5,112.5,15797
Jeffrey,M,13,62.5,84,16552
John,M,12,59,99.5,17036
Joyce,F,11,51.3,50.5,17169
Judy,F,14,64.3,90,16410
Louise,F,12,56.3,77,17021
Mary,F,15,66.5,112,15790
Philip,M,16,72,150,15665
Robert,M,12,64.8,128,16958
Ronald,M,15,67,133,15992
Thomas,M,11,57.5,85,17243
William,M,15,66.5,112,16067
;;;;
run;

data PG1.CLASS_TEACHERS;
   attrib Name length=$8;
   attrib Grade length=8;
   attrib Teacher length=$12;

   infile datalines dsd;
   input
      Name
      Grade
      Teacher
   ;
datalines4;
Alfred,8,Thomas
Alice,7,Evans
Barbara,6,Smith
Carol,8,Thomas
Henry,8,Thomas
James,6,Smith
Jane,5,Garcia
Janet,9,Jones
Jeffrey,7,Evans
John,6,Smith
Joyce,5,Garcia
Judy,8,Thomas
Louise,6,Smith
Mary,9,Jones
Philip,10,Williams
Robert,7,Evans
Ronald,10,Williams
Thomas,6,Smith
William,9,Jones
;;;;
run;

data PG1.CLASS_TEST2;
   attrib Name length=$7;
   attrib Subject length=$7;
   attrib TestScore length=8;

   infile datalines dsd;
   input
      Name
      Subject
      TestScore
   ;
datalines4;
Judy,Math,97
Judy,Reading,91
Barbara,Math,96
Barbara,Reading,86
Louise,Math,92
Louise,Reading,99
James,Math,90
James,Reading,85
Joyce,Math,88
Joyce,Reading,75
William,Math,87
William,Reading,87
Henry,Math,85
Henry,Reading,86
Jane,Math,84
Jane,Reading,76
Alfred,Math,82
Alfred,Reading,79
Mary,Math,81
Mary,Reading,84
Janet,Math,75
Janet,Reading,71
Philip,Math,73
Philip,Reading,80
Alice,Math,71
Alice,Reading,67
Robert,Math,71
Robert,Reading,72
Thomas,Math,70
Thomas,Reading,68
John,Math,68
John,Reading,73
Ronald,Math,66
Ronald,Reading,62
Carol,Math,61
Carol,Reading,57
Jeffrey,Math,55
Jeffrey,Reading,63
;;;;
run;

data PG1.CLASS_TEST3;
   attrib Name length=$7;
   attrib Subject length=$7;
   attrib TestScore length=8;

   infile datalines dsd;
   input
      Name
      Subject
      TestScore
   ;
datalines4;
Judy,Math,97
Judy,Reading,91
Barbara,Math,96
Barbara,Reading,86
Barbara,Math,96
Louise,Math,92
Louise,Reading,99
James,Math,90
James,Reading,85
Joyce,Math,88
Joyce,Reading,75
William,Math,87
William,Reading,87
Henry,Math,85
Henry,Math,90
Henry,Reading,86
Jane,Math,84
Jane,Reading,76
Alfred,Math,82
Alfred,Reading,79
Mary,Math,81
Mary,Reading,84
Janet,Math,75
Janet,Reading,71
Philip,Math,73
Philip,Reading,80
Alice,Math,71
Alice,Reading,67
Robert,Math,71
Robert,Reading,72
Thomas,Math,70
Thomas,Reading,68
John,Math,68
John,Reading,73
Ronald,Math,66
Ronald,Reading,62
Carol,Math,61
Carol,Reading,57
Jeffrey,Math,55
Jeffrey,Reading,63
;;;;
run;

data PG1.CLASS_UPDATE;
   attrib Name length=$8;
   attrib Sex length=$1;
   attrib Age length=8;
   attrib Height length=8;
   attrib Weight length=8;

   infile datalines dsd;
   input
      Name
      Sex
      Age
      Height
      Weight
   ;
datalines4;
Alfred,M,14,69,112.5
Alice,F,13,56.5,84
Barbara,F,13,65.3,98
David,M,11,55.3,73
Henry,M,14,63.5,102.5
James,M,12,57.3,83
Jane,F,12,59.8,84.5
Janet,F,15,62.5,112.5
Jeffrey,M,13,62.5,84
John,M,12,59,99.5
Joyce,F,11,51.3,50.5
Judy,F,14,64.3,90
Louise,F,12,56.3,77
Mary,F,15,66.5,112
Philip,M,16,72,150
Robert,M,12,64.8,128
Ronald,M,15,67,133
Thomas,M,11,57.5,85
William,M,15,66.5,112
;;;;
run;

data PG1.EU_OCC;
   attrib Geo length=$2 label='Country Code';
   attrib Country length=$40 label='Reporting Country';
   attrib YearMon length=$8 label='Year Month';
   attrib Hotel length=8 label='Nights Spent at Hotels';
   attrib ShortStay length=8 label='Nights Spent at Short Stay Accommodations';
   attrib Camp length=8 label='Nights Spent at Camp Grounds or RV Parks';

   infile datalines dsd;
   input
      Geo
      Country
      YearMon
      Hotel
      ShortStay
      Camp
   ;
datalines4;
AT,Austria,2017M09,7768564,1453530,524121
AT,Austria,2017M08,11353432,3140217,1997801
AT,Austria,2017M07,10124106,2836425,1752605
AT,Austria,2017M06,7391827,1568683,914560

Re: cre8data.sas

DWhite — Mon, 26 Aug 2019 12:19:34 GMT

Yes. This is what I am leaning towards. We are working in a Linux environment and may just copy all of the needed files over to the user folders.

Thanks.

Re: cre8data.sas

DWhite — Mon, 26 Aug 2019 12:21:00 GMT

I do not have much information from the instructor. Classes have started, and everybody has limited time. Thanks for the information.

Re: cre8data.sas

Cynthia_sas — Mon, 26 Aug 2019 13:25:24 GMT

Honestly, it looks like someone gave your instructor at least some of the Programming 1 data. When we deliver the data creation program, we do not use the name P194.SAS, which is how I know that he got the file from someone else.

As a workaround, you could activate the free Programming 1 class and use the zip and instructions inside the e-learning class to set up the data -- as you can see from the videos I posted the link to -- that data creation works very well and at least you'd have ALL the EPG194 files. My guess is that your instructor's course uses some, but not all of the data we use in the full course.

Hope this helps,
Cynthia

Re: cre8data.sas

Reeza — Mon, 26 Aug 2019 15:17:29 GMT

Also, some of that content is under copyright, you may need to verify with the professor that they have the appropriate licensing for the content they're using.

@DWhite wrote:

I do not have much information from the instructor. Classes have started, and everybody has limited time. Thanks for the information.

D.

Re: cre8data.sas

DWhite — Mon, 26 Aug 2019 16:53:14 GMT

How is licensing applied. We have campus-wide licensing for SAS Studio, SAS VA, Enterprise Miner, SAS DIS, and others.

Re: cre8data.sas

Cynthia_sas — Mon, 26 Aug 2019 16:56:47 GMT

Hi:

With a University license, you should be OK using SAS. I am worried about the files that your instructor gave you and where he got them and how they are intended to be used. They seem close to the files we use for our courses, but seem to be modified. This is really not something that anyone here can resolve for you. Your instructor will have to go back to the group/person who gave him the files and ask them to send him working files for the class material he's using.

Cynthia

Re: cre8data.sas

Reeza — Mon, 26 Aug 2019 18:15:57 GMT

Those are licenses for the applications, not the course and/or training material. That's a discussion you need to have with SAS. SAS does offer two levels of free courses - but I don't think that means you can take that content and create your own course entirely based off it because it's copyrighted material. It's equivalent to someone scraping a course from your University and going off and offering it for sale somewhere else. I'm fairly certain the profs would have something to say about that.

Re: cre8data.sas

Tom — Mon, 26 Aug 2019 18:17:57 GMT

Do you actually want to run that program? It says on the top not to run it.

If you did want to run that program then before running it you will need to define the PG1 libref pointing to some place where you can create files. Something like:

libname pg1 '/folder/for/class';
%include 'p184.sas' / source2;

If your intent is to run it once and let students access the dataset then point to a directory that the students have readonly access and run it using a userid that has write access. If the students have write access then one of them is bound to destroy some of all of the datasets or create other datasets in that folder by mistake.

Re: cre8data.sas

Cynthia_sas — Mon, 26 Aug 2019 18:43:35 GMT

This course is training for SAS Certification.

Re: cre8data.sas

DWhite — Mon, 26 Aug 2019 18:46:57 GMT

Please do not jump to conclusions. I am working with very limited information here.

Re: cre8data.sas

DWhite — Mon, 26 Aug 2019 18:49:53 GMT

I am not quite sure how this was attributed to Cynthia_sas, but that is dwhite's comment "This course supports SAS Certification."

Re: cre8data.sas

DWhite — Mon, 26 Aug 2019 18:57:16 GMT

No intention to run this as a stand-alone.

Re: cre8data.sas

Cynthia_sas — Mon, 26 Aug 2019 19:18:14 GMT

Hi: Thanks for the clarification!

There are 2 classes that prepare students for the Base SAS Programmer Certification. Those classes are: Programming 1 and Programming 2. We have various "versions" of these classes. We have 1) the regular e-learning courses that we offer on our web site and in our classrooms and Live Web sessions. We have a 2) specially edited version of these courses that we offer to High School teachers for AP/STEM classes. We have 3) specially edited versions of the courses that we offer to University Professors/Instructors who might want to use some or all of our material in their classes. We have 4) specially customized versions of the courses that may use specific data for a private company class.

When we deliver the zip file with programs and instructions for the "regular" (#1) Programming 1 and Programming 2 classes, we use a zip file that is tailored to how a student will be practicing -- either on their local copy of SAS or on one of the free versions of SAS. All of these zip files and programs have been tested and work well, as you can see from the video link I posted.

For any of the other versions, #2, #3, and #4, it is hard to guess how the data creation programs might have been changed for the specialty version. Since I work extensively with all the forms of the #1 way to deliver the course data via a program, that is why I guessed that your instructor was using programs obtained through one of our Academic Trainer's Kits that may have some kind of problem.

I still think that the fastest way for you to start working with Programming 1 material while you wait for your instructor to resolve the issue (which will NOT be resolved here) -- is for you to activate the free e-learning version of Programming 1 and follow the instructions inside the free Programming 1 course to make the data, as we intended for the e-learning course. My guess is that your instructor is not using ALL the course data files and may have edited the data creation program or else someone sent him an edited program that doesn't work.

The zip file and instructions that are inside the e-learning version of Programming 1 may create more data than you need, but the programs that are inside the e-learning version of Programming 1 all work as they should.

I wish I could be of more help, here, but unfortunately, your instructor will have to resolve this issue and in the meantime, your alternative is to use the free version of Programming 1 to accomplish some of the work.

Cynthia

Re: cre8data.sas

Reeza — Mon, 26 Aug 2019 19:23:57 GMT

@DWhite wrote:

Please do not jump to conclusions. I am working with very limited information here.

I'm trying to warn you that what you're doing may violate copyright act and University regulations. What you choose to do beyond that is your choice.

EDIT: if it's all legitimate usage or that's not an issue your quickest route to resolve this is to talk directly to SAS, this is a user community forum so those are the response you'll get.

Re: cre8data.sas

DWhite — Mon, 26 Aug 2019 19:33:09 GMT

Duly Noted.