So the correct libname statement for np_info.xlsx would be: libname np xlsx "/home/your user id/my_shared_file_links/ncvpssas0/EPG194/data/np_info.xlsx"; where you replace 'your user id' with your actual userid ... View more

So are you the one that created the course?  I see that in your libname statement: libname np xlsx "/home/ncvpssas0/my_shared_file_links/ncvpssas0/EPG194/data/np_info.xlsx"; the user id is the same as the course creator (ncvpssas0)  If you are the course creator - this is correct but if you enrolled in the course, the first id should be your userid. You can always get the correct path by right-clicking on the folder or file & selecting Properties.   Also, in your first libname statement: libname data "/home/ncvpssas0/my_content/EPG194/data"; Did you create a subfolder called my_content under your Files(Home) directory?   For the Programming 1 course - we highly suggest that you copy the course directory (EPG194) directly under your Files(Home) directory & then you can use the path macro & libname statement: %let path=~/EPG194/data; libname PG1 "&path";   The ~ symbol will default to the user's Files(Home) directory & so this will work for everyone.   One another note:  It looks like you may be using an older version of the Programming 1 class - there is a newer version EPG1V2 - not sure if much changed. Hope that helps.   ... View more

Name and SAS Viya for Learners Location Name: VA_SAMPLE_CASINO_REV_FCST2 SAS Viya for Learners Location: TUNDATA Description This data set contains information for two casinos (Aries Casino and Libra Casino), seven manufacturers, machine denominations that ranging from 0.01 cent to $2.00, and more than 400 different machines. The key metrics are Gross Revenue, Gross Revenue per Machine, Plays, Plays per Machine, and No. Machines. Monthly data are provided. Source Link Information is not currently available. Data Contents Number of Observations: 7306 Number of Variables: 17   Some datasets may not have full descriptions of variables below. For publicly available datasets, please visit the source link above to gain more information and descriptions about the variables contained in this dataset.   Contents Column # Name Label (optional) Type Length Details (optional) 2 Casino Casino char 8 Possible values: Aries, Libra 4 Denomination Denomination num 8 Poker machine denomination Range: $0.01 to $2.00 17 Diff_w_Lower Diff_w_Lower num 8   16 Diff_w_Upper Diff_w_Upper num 8   10 FcstLower FcstLower num 8   11 FcstUpper FcstUpper num 8   9 GrossRevenue GrossRevenue num 8 Gross Revenue Range: $4.00 to $427,760 14 GrossRevenuePerMachine GrossRevenuePerMachine num 8 Gross Revenue per Machine Range: $4.00 to $95,929 1 MachineName MachineName char 44 407 possible values 5 MachineType MachineType char 9 Possible values: Reel, Video, Vpoker 6 Manufacturer Manufacturer char 12 Possible values: Entellus, Global, Jarvey, Naevus, Pyrogen, Realm, Tsunami 7 Model Model char 36 54 possible values 8 Month Month num 8   12 NoMachines NoMachines num 8 Number of Machines Range: 1.00 to 14.00 13 Plays Plays num 8 Total number of plays Range: 44 to 3,211,102 15 PlaysPerMachine PlaysPerMachine num 8 Plays per machine Range: 22 to 672,040 3 Section Section char 23 Possible values: Boundary, Entrance, Interior, RestaurantPlaza   ... View more

Still looking for Data:   More data sources https://communities.sas.com/t5/SAS-Communities-Library/Need-data-for-teaching-or-learning-Get-it-her... ... View more

Still looking for data to use for this Project Based Learner Series?   Check-out this SAS Communities post for lots of data sources: https://communities.sas.com/t5/SAS-Communities-Library/Need-data-for-teaching-or-learning-Get-it-here/ta-p/221088   Hopefully, you'll find something that that is interesting or applicable to your field of study!   ... View more

SAS University Edition is no longer supported. I would suggest moving to SAS Ondemand for Academics (free Cloud platform for students, professors, and independent learners).   See related post on moving to SAS Ondemand for Academics: https://communities.sas.com/t5/SAS-Software-for-Learning/Questions-about-getting-student-University-Edition-files-onto/m-p/758832   Also a short video on Getting Started with SAS Ondemand for Academics: https://www.youtube.com/watch?v=tmL8fdOd-pI   ... View more

For SAS Ondemand for Academics - you'll need to upload your file to your Home directory (or a sub-folder you've created under your home directory).  See this post for useful information about SAS Ondemand for Academics: https://communities.sas.com/t5/SAS-Communities-Library/Getting-started-with-SAS-OnDemand-for-Academics/ta-p/746493   Five steps to upload data and programs into SAS OnDemand for Academics   Use the point and click tools in SAS Studio in SAS OnDemand for Academics to upload data and programs from your computer:   In the Server Files and Folders tab in SAS Studio, right-click the directory to which you’d like to upload your files. Select Upload Files. Select Choose Files. Browse your computer. Select your files and click Upload. Your selected files will be uploaded and available in SAS Studio in SAS OnDemand for Academics. ... View more

I am guessing you have two columns (variables - Before & After) with some kind of measurement as the values. You need to have two columns (variables - for example Stage with values "Before" and "After" & Measurements - with the measurement values)   Here is an example with sashelp.class data:   /* t test */ proc ttest data=SASHELP.CLASS sides=2 h0=0 plots(showh0); class Sex; var Height; run; ... View more

Sure - sent via email ... View more

If you went through the Guided Prep & received your voucher - YOU STILL HAVE TIME To TAKE THE CERTIFICATION EXAM!  The exam vouchers are good through October & you just need to schedule your exam before then.   You can review the course material & take practice exam from the SAS Skill Builder for Students.  ... View more

Only other users assigned to tenant 67. ... View more

This post may help: https://communities.sas.com/t5/SAS-Software-for-Learning/Bulk-Download-all-my-files-from-SAS-Ondemand/m-p/712727#M613 ... View more

Also found this in SAS documentation: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/movefile/n06qan4j3ffr6fn11bs4q11r8r56.htm ... View more