DS- SAS Jul 6th Batch

Discussion in 'Big Data and Analytics' started by Shohini_1, Jul 6, 2019.

  1. Shohini_1

    Shohini_1 Well-Known Member
    Simplilearn Support

    Joined:
    Sep 24, 2018
    Messages:
    128
    Likes Received:
    17
    Dedicated thread for 6th July Batch
     
    #1
  2. Priyanka Ahuja Dawer

    Joined:
    Apr 30, 2019
    Messages:
    1
    Likes Received:
    0
    @Shohini_1
    In my account in LMS it is showing 0 classes attended, even though i attended full class yesterday , Can you check .
    Thanks
     
    #2
  3. _40387

    _40387 Member

    Joined:
    Sep 14, 2018
    Messages:
    6
    Likes Received:
    1
    I am student as well but i think once you attend 80% of the sessions you will have 1 class attended , so once you attend the most of the sessions it will be 1 class attend
     
    #3
  4. Koushik Radhakrishnan

    Joined:
    Apr 29, 2019
    Messages:
    10
    Likes Received:
    0
    Hi,

    Can you please share drive path or the code that the instructor worked on July 7th. It would be helpful for all those in the batch for practicing.
     
    #4
  5. _49137

    _49137 Member

    Joined:
    Nov 22, 2018
    Messages:
    3
    Likes Received:
    0
    HI can anyone share the google drive link please
     
    #5
  6. _48714

    _48714 Member

    Joined:
    Nov 19, 2018
    Messages:
    2
    Likes Received:
    0
    HI can anyone share the google drive link please
     
    #6
  7. Dilip D. Dhuri

    Joined:
    Mar 28, 2019
    Messages:
    4
    Likes Received:
    0
    Please share the drive link. I remembered trainer never share the link.
     
    #7
  8. Jude Rodriguez

    Jude Rodriguez Active Member

    Joined:
    Jul 18, 2019
    Messages:
    17
    Likes Received:
    1
    Hi, I have a query. using proc SQL, how would I go about calculating the "Total sales per day irrespective of the products" in the ecommerce dataset {attached below}? I tried using a code, but not too confident about it. it is also generating error

    code:
    /* Total sales per day irrespective of the products */
    proc SQL;
    format (Order_Date,date9.)
    select order_date,sum(sales) as total_sales
    group by 1;
    quit;

    error:
    WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.
    OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

    Please help me.
     

    Attached Files:

    #8

Share This Page