In my code below, I suppose to get three product, ...

Discussion in 'Big Data and Analytics' started by _32783, Jul 11, 2018.

  1. _32783

    _32783 Member

    Joined:
    Jun 21, 2018
    Messages:
    2
    Likes Received:
    0
    In my code below, I suppose to get three product, but it miss number 3.

    1.Simple Statistics
    2.Pearson Correlation Coefficients
    3.Graphic Chart
    please examine my code below and share with me if there is anything wrong.
    PROC IMPORT DATAFILE="/folders/myfolders/Electronic.xlsx"
    OUT=WORK.Electronic
    DBMS=XLSX
    REPLACE;
    RUN;

    ODS Graphics on;

    proc corr Data=Electronic plots=matrix(Histogram);
    var profit sales discount;
    run;

    ODS Graphics off;
     
    #1
  2. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    726
    Likes Received:
    50
    Hi,

    Apologies for the delay in response. Please find the explanation mentioned below for the concern:

    I would like to inform you that, kindly have a look on the log when we are running your code:
    upload_2018-7-18_11-20-23.png

    So we need to add a bit in the code to solve the warning, please find the code mentioned below:

    ODS Graphics on;
    proc corr Data=IMPORT plots(maxpoints=10000)=matrix;
    var sales profit discount;
    run;
    ODS Graphics off;

    And we are good to go with the plot, kindly find the output mentioned below:

    upload_2018-7-18_11-22-43.png

    I am sure this will help you. Thank you so much for your cooperation.

    Happy Learning!!
     
    #2

Share This Page