Data Science with SAS | June 2 - July 1

Discussion in 'Big Data and Analytics' started by Priyanka_Mehta, Jun 1, 2018.

  1. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    Hello All,

    Greetings from Simplilearn!!

    Let us have a discussion about the course, explore the course here and try to resolve all our queries related to the same.

    Happy Learning!!

    Regards,
    Priyanka
    GTA - Simplilearn
     
    #1
    mahendran g likes this.
  2. abhijeet bhalerao(3150)

    Alumni

    Joined:
    Sep 25, 2014
    Messages:
    2
    Likes Received:
    0
    Good start for the first session today..... Thanks :)
     
    #2
  3. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    Hi Guys,

    As per our discussion in the session, please find the links for OnDemand SAS:

    Registration--Step 1: https://www.sas.com/en_in/software/university-edition/goaws/register.html
    Step 2: https://odamid.oda.sas.com/SASODARegistration/

    After this step, you will receive your Userid in your inbox (on Emailid with which you will register in above steps). Using this Userid and he password entered by you to login using the last step.

    Login--Step 3: https://odamid.oda.sas.com/SASLogon...sas.com/SASStudio/j_spring_cas_security_check

    And you are good to go. No installation is needed for this.
     
    #3
    Prateek_64 likes this.
  4. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    #4
  5. _30204

    _30204 Member

    Joined:
    Apr 24, 2018
    Messages:
    7
    Likes Received:
    0

    NOt able to login after registration also .tried multiple timee

    pleas help me
     
    #5
  6. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    Hi, please let us know what error you are facing? I hope you are using correct username and password.
    Check in your inbox for the correct username. And if password is wrong then try forgot password. I am sure this will help you.
     
    #6
    Last edited: Jun 2, 2018
  7. Shyam Sunder_1

    Joined:
    Oct 10, 2017
    Messages:
    9
    Likes Received:
    0
    I am unable to download SAS , neither the student nor on demand version despite following the three steps. Pls help.thx.
     
    #7
  8. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    HI Shyam,

    Guide us with the screenshot of your errors so that we can guide you more accurately.
     
    #8
  9. Saugata Ghosh_2

    Joined:
    May 18, 2018
    Messages:
    5
    Likes Received:
    0
    Hi Priyanka,

    Facing issue to open SAS studio which was working yesterday -
    Error : The application could not connect to any server in the cluster "(odaws02.oda.sas.com:8591,odaws01.oda.sas.com:8591)"
     

    Attached Files:

    #9
  10. _29514

    _29514 Member

    Joined:
    Apr 17, 2018
    Messages:
    2
    Likes Received:
    1
    Please share the todays session code please for practice ..?
     
    #10
    _6639 likes this.
  11. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1
    Hi Guys,

    Please find attached the code for today's class.
    I am sure that this will help you.

    Thanks.
     

    Attached Files:

    #11
    _6639 likes this.
  12. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1
    Hi Guys,

    Please find attached the code for today's class.
    I am sure that this will help you.

    Thanks.
     

    Attached Files:

    #12
  13. _29514

    _29514 Member

    Joined:
    Apr 17, 2018
    Messages:
    2
    Likes Received:
    1
    thanks prateek
     
    #13
  14. _30204

    _30204 Member

    Joined:
    Apr 24, 2018
    Messages:
    7
    Likes Received:
    0
    Hi

    while trying to save .sas file i got belo error

    TypeError: Cannot read property 'parentNode' of null
     
    #14
  15. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    #15
  16. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    Hi Saugata,

    I think you are using SAS in your office laptop, and this is the reason why you are not able to access the SAS. You can once check with the IT team. If still, you are stuck, kindly try using SAS University Edition. All the steps for the same are mentioned in this thread.

    I hope this will help you.
     
    #16
  17. Satish Kumar_22

    Satish Kumar_22 New Member

    Joined:
    Jun 1, 2018
    Messages:
    1
    Likes Received:
    0
    Hello Priyanka/Prathik .... I am trying to find city_parking.xlsx that you used in your demo code... Could you share that data file
     
    #17
  18. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1
    Hi people,

    I hope everyone is geared up for tomorrow's class.
    In Class 2, we went through the following topics:

    DATA Step in SAS- Syntax
    DATA step Processing --- Compilation
    Data Step Processing --- Execution Phase
    Data Step Processing Examples
    SAS Libraries --- Creation
    SAS Libraries --- Temporary and Permanent
    We also saw the use of If and else statements.
     
    #18
  19. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1
    In the class for 9th June, we will be studying the following topics:
    Merging and Modifying Datasets
    Set statement
    Proc Append
    Interleaving
    One to One Reading
    One to One Merging
    Merging Examples - Case Study
    Data Modification delete and group observation
    Data Modification keep and Drop variables
    Modifying variable Attributes

    We shall also look into PROC Sql, which is the SQL equivalent for SAS.

    Thanks and look forward to see you in the next class!!

    Happy Learning.
     
    #19
  20. _30204

    _30204 Member

    Joined:
    Apr 24, 2018
    Messages:
    7
    Likes Received:
    0
    even though iam saving every time libraries are getting deleted and also files under folder section.
    please let us know hoe to save permanently
     
    #20
  21. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1
    After you assign a library by the statement:
    libname name_of_library "address";

    After running this command, the library reference is saved at that location and you can find it under the list "My Libraries", even after starting a new session, Not sure why you are getting such error, can you please elaborate?
     
    #21
  22. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1
    Hi Satish,

    I am not able to upload the excel file of city_parking since .xlsx extension is not able to upload.
    however, I can upload it in text format, Please find attached the transit_demand.txt file.(2nd tab of the city_parking.xlsx)
     
    #22
  23. Saugata Ghosh_2

    Joined:
    May 18, 2018
    Messages:
    5
    Likes Received:
    0
    Hi Prateek,

    Facing the same issue.
    libname name_of_library "address"; - Library creation is doing properly. If I want to do some data set creation or modification which also able to perform without any issue.
    But when I am logging off from the session, only my created library is going to remove.
    How to create permanent library?
     
    #23
  24. Saugata Ghosh_2

    Joined:
    May 18, 2018
    Messages:
    5
    Likes Received:
    0
    Hi Priyanka,
    After reboot my PC, it started to work properly.
     
    #24
  25. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1
    Hi everyone,

    Please find attached the code which we shall use in today's class.
     

    Attached Files:

    #25
  26. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    Great Saugata, Congratulations!!
    Have a great Learning experience. Happy Learning!!!
     
    #26
  27. Shwetank Shivhare

    Joined:
    May 14, 2018
    Messages:
    5
    Likes Received:
    0
    Hi Prateek,
    I am also facing the same issue, I have created the user library, once i logged in again i cant see the user library. But if i create the library again I can see the data set also which i have created in previous session. And i think this issue is with other also.
     
    #27
  28. Neha Jain_4

    Neha Jain_4 Member

    Joined:
    May 19, 2018
    Messages:
    3
    Likes Received:
    0
    Hey Priyanka,
    I was working on sas university edition, as you know due to some error it stopped working in middle of the class today. As Prateek asked me log in into the system again, I tried the same and after that I'm unable to sign in again.I'm attaching the screenshot of what sas studio has come up with. Kindly request you to help me with the same.
     

    Attached Files:

    #28
  29. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1

    Hi Neha,

    Please use the SAS ODA link given below and try to login into SAS .Maybe this will work for you.
    As we discussed in class, after you create a profile as independent learner, then you will get a link after about half an hour, and then you can login and work. Let me know in case this suffices-

    Thanks
    Prateek.

    Registration--Step 1: https://www.sas.com/en_in/software/university-edition/goaws/register.html
    Step 2: https://odamid.oda.sas.com/SASODARegistration/

    Login--Step 3:
    https://odamid.oda.sas.com/SASLogon...sas.com/SASStudio/j_spring_cas_security_check
     
    #29
  30. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    Hi all, as discussed in today's session, kindly find the city_parking dataset attached here.

    **Note - Zip file is attached, kindly unzip it and use the city_parking.xlsx file.
     

    Attached Files:

    #30
  31. Neha Jain_4

    Neha Jain_4 Member

    Joined:
    May 19, 2018
    Messages:
    3
    Likes Received:
    0
    Hi Priyanka,
    I tried using SAS ODa as well. It is also showing some error. Screenshot of the same I have shared below.
     

    Attached Files:

    #31
  32. Sharmistha Chakrabarti

    Joined:
    May 14, 2018
    Messages:
    6
    Likes Received:
    0

    Hi Priyanka,

    I enrolled for Data Science with SAS. However, I live in the east coast of Florida and the classes are schedules on Fri/Sat from 11:30 PM to 3:30 AM. I tried my best to listen/watch to Prateek's lessons on Jun 1 and Jun 2. However, it is extremely hard to focus during that time slot.

    I started going through the online lessons. Would I still be able to download the recording of the class?

    Thanks
    Sharmistha
     
    #32
  33. _31429

    _31429 Member

    Joined:
    May 7, 2018
    Messages:
    2
    Likes Received:
    0
    Same issue here. I do not see the Library that I created when I log into a new session. But If I create the same library again I can see all the datasets created in previous sessions. I am using SAS university edition.
     
    #33
  34. Prateek_64

    Prateek_64 Active Member
    Alumni Trainer

    Joined:
    Jun 1, 2018
    Messages:
    15
    Likes Received:
    1
    Hi Learners,

    Please find attached the code for today's class.

    Happy learning !
     

    Attached Files:

    #34
  35. Juyufi Tayal

    Juyufi Tayal Member

    Joined:
    May 27, 2018
    Messages:
    5
    Likes Received:
    0
    Unable to see the chat box.
     
    #35
  36. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    Sure dear, you will be able to download the recording as you have registered for the batch. Please go ahead and refer the self-paced learning videos and the recordings. I am sure this will help you. All the very best for the same.
     
    #36
  37. Rajasekhar Pustakala

    Joined:
    Aug 4, 2017
    Messages:
    4
    Likes Received:
    0
    Hi

    Every time i am logging SAS on demand I am not able to see Permanent Library.Do I need to create again each time?
     
    #37
  38. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    HI Rajasekhar,

    It is true that when you start a new session OnDemand SAS, the library will not be visible. You have to just execute the "libname" statement and the whole library will be available under the Library tab.

    I hope this will help you.
     
    #38
  39. Juyufi Tayal

    Juyufi Tayal Member

    Joined:
    May 27, 2018
    Messages:
    5
    Likes Received:
    0
    Hi Prateek/Priyanka,

    In last class, you said we will receive files for practice.

    Regards,
    Juyufi Tayal
     
    #39
  40. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    783
    Likes Received:
    50
    @Juyufi - Thank you so much for the reminder.

    @All - I would like to inform you that, we will be providing you some practice sample to work on, but before that, kindly complete the Assignments already available in our LMS account for Lesson 2, 3 and 4 before our next session.

    Kindly find the path to locate the assignment:
    LMS account > Course Icon > Syllabus > Lesson > Assignment.

    I am sure this will help you to get a good hands-on for the concepts discussed till the date. If you are stuck anywhere, please feel free to have a good discussion here.
     
    #40
  41. Rajasekhar Pustakala

    Joined:
    Aug 4, 2017
    Messages:
    4
    Likes Received:
    0
    Yes Thanks for quick reply
     
    #41
  42. Rahul sekhar

    Rahul sekhar Member

    Joined:
    May 22, 2018
    Messages:
    2
    Likes Received:
    0
  43. Rahul sekhar

    Rahul sekhar Member

    Joined:
    May 22, 2018
    Messages:
    2
    Likes Received:
    0
    received this error while executing the below mentioned program , plz explain in next class
    proc sql;
    connect to oracle as ora2 (user=user id password=password);
    select * from connection to ora2 (
    select name, id from staff
    );
    disconnect from ora2;
    quit;
     
    #43
  44. Juyufi Tayal

    Juyufi Tayal Member

    Joined:
    May 27, 2018
    Messages:
    5
    Likes Received:
    0
    Hi Prateek,

    Please let me know the difference between the Quit statement in Proc SQL & RUN in data step.

    Regards,
    Juyufi
     
    #44
  45. _30204

    _30204 Member

    Joined:
    Apr 24, 2018
    Messages:
    7
    Likes Received:
    0
    data Assign.Orders;

    input OrderID OrderDate DDMMYY10. Region $12. Order_ExpDate MMDDYY10.;
    format OrderDate date9.;
    format Order_ExpDate DDMMYY8.;
    Datalines;
    1 12/01/2018 Hyderabad 12/10/2018
    1 12/02/2018 Secundrabad 12/10/2018
    1 12/03/2018 Medak 12/10/2018
    ;
    run;


    upload_2018-6-15_19-7-7.png

    In the output Order_ExpDate is blank.Could you please let me know what is the issue.

    Instead of Order_ExpDate MMDDYY10. if i give Order_ExpDate MMDDYY8. the output is coming as expected.
     
    #45
  46. Shwetank Shivhare

    Joined:
    May 14, 2018
    Messages:
    5
    Likes Received:
    0
    Do you have DB installed ?
     
    #46
  47. Shwetank Shivhare

    Joined:
    May 14, 2018
    Messages:
    5
    Likes Received:
    0

    Hi,
    Try this..

    data Orders;
    length region $12.;
    input OrderID OrderDate DDMMYY10. Region $ Order_ExpDate MMDDYY10.;
    format OrderDate date9. Order_ExpDate DDMMYY8.;
    cards;
    1 12/01/2018 Hyderabad 12/10/2018
    1 12/02/2018 Secundrabad 12/10/2018
    1 12/03/2018 Medak 12/10/2018
    ;
    run;

    upload_2018-6-16_0-24-31.png

    Thanks,
    Shwetank
     
    #47
  48. _30204

    _30204 Member

    Joined:
    Apr 24, 2018
    Messages:
    7
    Likes Received:
    0
    data Assign.NorthSouth;
    /* rename Sales Amount=Sales_Amount; */
    set Assign.North Assign.South;
    rename Sales Amount=Sales;
    if Sales>=4000;
    run;


    in the dataset there is a space in the column name.Not able to rename also.


    Error:
    79
    ERROR: Alphabetic prefixes for enumerated variables (Sales-Amount) are different.
    ERROR: Old and new variable name specifications for RENAME must be of the same type. Statement is ignored.
    ERROR 79-322: Expecting a -.
     
    #48
  49. Abhishek Prabhakar

    Abhishek Prabhakar Active Member

    Joined:
    Nov 22, 2016
    Messages:
    18
    Likes Received:
    0
    The SAS on demand online page link is not working or may be under maintenance. Is there any other link to work on SAS

    Abhishek
     
    #49
  50. Shwetank Shivhare

    Joined:
    May 14, 2018
    Messages:
    5
    Likes Received:
    0
    Mine is working..

    upload_2018-6-16_11-28-58.png
     
    #50

Share This Page