Friday
tom_grant
SAS Super FREQ
Member since
01-23-2017
- 214 Posts
- 171 Likes Given
- 23 Solutions
- 119 Likes Received
-
Latest posts by tom_grant
Subject Views Posted 747 11-20-2024 03:28 PM 704 11-18-2024 09:25 PM 1309 10-10-2024 10:06 AM 1406 10-02-2024 10:26 AM 466 09-27-2024 12:16 PM 489 09-27-2024 08:04 AM 2340 09-26-2024 06:56 PM 2413 09-26-2024 06:24 PM 2437 09-26-2024 06:09 PM 893 09-26-2024 10:26 AM -
Activity Feed for tom_grant
- Liked Re: Need help-SAS studio coding area function problem for hollandnumerics. Friday
- Liked Simplifying SAS Viya Part 2: What are Caslibs? for CarleighJoC. 2 weeks ago
- Liked Get help with SAS OnDemand for Academics, SAS Viya for Learners, and SAS Viya Workbench for Learners for BeverlyBrown. 2 weeks ago
- Liked Re: ERROR: Invalid or missing data in Proc Glimmix for JackieJ_SAS. 11-20-2024 03:38 PM
- Posted Re: ERROR: Invalid or missing data in Proc Glimmix on SAS Software for Learning Community. 11-20-2024 03:28 PM
- Liked Re: Unable to Connect to SAS Studio Workspace Server for JackieJ_SAS. 11-19-2024 08:23 AM
- Posted Re: Unable to Connect to SAS Studio Workspace Server on SAS Software for Learning Community. 11-18-2024 09:25 PM
- Liked Re: TITLE statements in SAS Studio - are they global statements? for antonbcristina. 10-18-2024 01:22 PM
- Got a Like for Re: SAS Hackathon 2024: Student Track Support. 10-18-2024 10:00 AM
- Liked Research Triangle SAS User Group for janehowell. 10-17-2024 09:42 AM
- Posted Re: SAS Hackathon 2024: Student Track Support on SAS Hacker's Hub. 10-10-2024 10:06 AM
- Liked Re: SAS Hackathon 2024: Student Track Support for Ravioli. 10-10-2024 10:04 AM
- Liked SAS Skill Builder for Students: THE One-Stop Shop for Marketable Analytics Skills for samperry. 10-07-2024 04:14 PM
- Liked SAS Visual Analytics Tips & Tricks Series: An elegant IsSet solution for KalleM. 10-03-2024 08:25 AM
- Liked Ask the Expert: Why SQL Dictionary Tables are a Game-Changer for Data Scientists for AliceYuan. 10-02-2024 10:37 AM
- Posted Re: SAS Studio issues forces user to terminate run sequence and lose libraries on SAS Software for Learning Community. 10-02-2024 10:26 AM
- Posted Re: "INVALID PHYSICAL NAME" on SAS Software for Learning Community. 09-27-2024 12:16 PM
- Liked SAS Hackathon 2024: Student Track Support for LGroves. 09-27-2024 09:05 AM
- Posted Re: "INVALID PHYSICAL NAME" on SAS Software for Learning Community. 09-27-2024 08:04 AM
- Posted Re: "INVALID PHYSICAL NAME" on SAS Software for Learning Community. 09-26-2024 06:56 PM
-
Posts I Liked
Subject Likes Author Latest Post 2 3 4 2 2 -
My Liked Posts
Subject Likes Posted 1 10-10-2024 10:06 AM 1 09-18-2024 10:38 AM 3 09-12-2024 09:30 AM 1 08-30-2024 08:24 AM 1 08-16-2024 01:44 PM -
My Library Contributions
03-18-2024
09:13 AM
Try hitting the refresh button (several times).
... View more
03-12-2024
10:56 AM
2 Likes
There is also a great Webinar at the top of this Certification post which will help guide you along your SAS Certification Journey & explain what's new in SAS Certifications: https://communities.sas.com/t5/SAS-Certification/bd-p/certification
... View more
03-11-2024
10:54 AM
2 Likes
Interesting post about SAS Certification journey: https://communities.sas.com/t5/SAS-Communities-Library/Decoding-the-World-of-SAS-Certifications-with-Ariel-Mbekwe/ta-p/919758?emcs_t=S2h8ZW1haWx8Ym9hcmRfc3Vic2NyaXB0aW9ufExUTVpFQVhNV1NHQTlIfDkxOTc1OHxTVUJTQ1JJUFRJT05TfGhL
... View more
02-01-2024
10:54 AM
Thanks for screen shot. So you've lost your Server Files and Folders tab. This is an easy fix. Go to the icon on Top Right that looks like a hamburger & click & select View. Then check the Server Files and Folders. Somehow it got un-selected.
... View more
02-01-2024
08:43 AM
Can you send a screen shot of what your Server Files and Folders tab looks like now??
... View more
01-31-2024
12:28 PM
1 Like
Also, I would avoid using your sasuser directory to store files - move your files to Files(Home) or create a subfolder under Files(Home).
... View more
01-31-2024
12:21 PM
So just update the libname statement above with your user id - you can find your user id by clicking on your name in top right on the welcome.oda.sas.com page (usually starts with the a 'u').
... View more
01-31-2024
11:08 AM
Cool feature in SAS Studio is you can right-click on a folder when in the Server Files and Folders tab, & then select Create -> Library. This will bring up a pop-up window where you can supply the libref for this folder & also check a box to assign the library every time you start SAS Studio so you never have to do this again (librefs are deleted when you close or reset your SAS session).
Note: This only works for creating Base SAS libraries.
... View more
01-31-2024
08:45 AM
2 Likes
Check out this community library article for SAS Base Programming Reference Sheet - wish I had this reference when I was learning SAS programming 30+ years ago.
https://communities.sas.com/t5/SAS-Communities-Library/SAS-Base-Programming-Reference-Sheet-Your-Essential-Guide-to/ta-p/913589
... View more
01-30-2024
03:37 PM
3 Likes
Here is a post with examples of papers from previous year:
https://communities.sas.com/t5/The-Curiosity-Cup/SAS-Curiosity-Cup-Papers-what-is-the-expectation/m-p/913406#M14
... View more
01-30-2024
01:03 PM
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
01-30-2024
12:55 PM
1 Like
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
01-25-2024
03:37 PM
2 Likes
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
01-23-2024
11:47 AM
3 Likes
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
01-18-2024
08:20 AM
1 Like
Sorry you are having such a tough time.
My guess is someone has "messed-up" the metadata for COMMSDATA. Try running a very simple model by setting all the variable's roles to rejected & then set Churn to Target & a few of the other variables to Input (like the MB_... vars). See if that runs okay.
You will likely have to correct the metadata to match the course notes.
Unfortunately, there is no way to prevent users from changing the Metadata of a data source.
... View more