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

Discussion in 'Big Data and Analytics' started by Kunal Guwalani, Dec 8, 2018 at 6:46 AM.

  1. Kunal Guwalani

    Kunal Guwalani Well-Known Member
    Simplilearn Support

    Joined:
    Jul 17, 2018
    Messages:
    90
    Likes Received:
    3
    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:
    23
    Likes Received:
    0
    Hi Jayant,

    Your query has been sent to the trainer.

    Will keep you posted on the same.

    Thanks for your cooperation!
     
    #3

Share This Page