DATA SCIENCE WITH SAS |DEC 8- JAN 13 |ASHUTOSH

Discussion in 'Big Data and Analytics' started by Kunal Guwalani, Dec 8, 2018.

  1. Kunal Guwalani

    Kunal Guwalani Well-Known Member
    Simplilearn Support

    Joined:
    Jul 17, 2018
    Messages:
    112
    Likes Received:
    6
    Hi Learners,

    This thread is for you to discuss the query and concepts related to Data Science With SAS course.

    Happy Learning !!

    Regards,
    Team Simplilearn
     
    #1
  2. Jayant Poogalia

    Joined:
    Jan 20, 2017
    Messages:
    2
    Likes Received:
    0
    Hi Ashutosh,

    I was experimenting with SQL and Macro today and to a large extent, i am successful however got stuck at lesson 5 (5.4) Macro.
    I am constantly getting following error

    ERROR: File WORK.DSN.DATA does not exist.
    ERROR 22-322: Expecting a name.
    ERROR 200-322: The symbol is not recognized and will be ignored.

    following is my code

    PROC IMPORT DATAFILE='/home/poogalia0/My first SAS/ECommerce.xlsx'
    DBMS=XLSX
    OUT=work.ecommerce;
    GETNAMES=YES;
    RUN;

    %let DSN = ECommerce;
    %let var = Sales Profit;
    proc means data=$DSN;
    title1 "%upper(scan($var,1)) and %upper(scan($var,2))
    for %upper($DSN) channel";
    title2 "prior to %sysfunc(year("sysdate"d)) calendar year ";
    where year(order_date) < (%sysfunc(year("$sysdate"d)));
    var $var;
    class ship_mode;
    run;


    can you please assist.
     
    #2
  3. Shohini_1

    Shohini_1 Active Member
    Simplilearn Support

    Joined:
    Sep 24, 2018
    Messages:
    48
    Likes Received:
    3
    Hi Jayant,

    Your query has been sent to the trainer.

    Will keep you posted on the same.

    Thanks for your cooperation!
     
    #3
  4. _44470

    _44470 New Member

    Joined:
    Oct 18, 2018
    Messages:
    1
    Likes Received:
    0
    Hi Ashutosh,

    How can I access the Google Drive folder? What is the link?
     
    #4
  5. Nishant_Singh

    Nishant_Singh Well-Known Member
    Simplilearn Support

    Joined:
    Aug 1, 2018
    Messages:
    159
    Likes Received:
    9
    #5
  6. Lawrence Chang

    Lawrence Chang Customer
    Customer

    Joined:
    Aug 28, 2018
    Messages:
    2
    Likes Received:
    0
    Where are all the data files for the examples for any of the lessons? I'm asking about "E-Commerce-Data.xlsx"; "Electronic.xlsx"; "Fashion.xlsx"; "Electronic_CustInfo.xlsx"; and so forth.
     
    #6
  7. Lawrence Chang

    Lawrence Chang Customer
    Customer

    Joined:
    Aug 28, 2018
    Messages:
    2
    Likes Received:
    0
    The PROC DTREE does not seem to be available to use in the SAS University Edition as it appears to be a procedure only available in SAS/OR. Is there another approach to doing decision trees in SAS?
     
    #7
  8. Shohini_1

    Shohini_1 Active Member
    Simplilearn Support

    Joined:
    Sep 24, 2018
    Messages:
    48
    Likes Received:
    3
    Hi Lawrence,

    Greetings!

    Find the path below to download the datasets for DS with SAS.

    Login to your LMS Account > Select the Course 'Data Science with SAS' > SELF LEARNING > Course Resources > Datasets and SAS Installation > Download the Folder and unzip > All the datasets will be visible.

    Attaching screenshot for your reference:

    upload_2019-1-2_14-56-1.png

    After unzipping the folder you will get :

    upload_2019-1-2_14-57-49.png

    Still, if you get stuck somewhere please let me know.
     
    #8
  9. Shohini_1

    Shohini_1 Active Member
    Simplilearn Support

    Joined:
    Sep 24, 2018
    Messages:
    48
    Likes Received:
    3
    #9

Share This Page