Dear Experts ,   I am creating a Statistics summary for the visits ,   eg:- Visit 1 - N SD Mean Median Q1 Q3 MIn Max  visit 2  -N SD Mean Median Q1 Q3 Min MAx   I can create taking each visits and find the statistics using Proc means , but the problem is I need a dynamic code that find if any other visits also occurs in future and then the respective statistics  ... View more

Create the ORDERS dataset and calculate the cumulative total of Total_retail_price for each month. As the month changes, the cumulative total should start from the first date of each month again.     data orders; length order_date $ 10; input order_date$ id price; cards; 02JAN2007      1241054779          195.60 03JAN2007      1241063739          160.80   run;   ... View more

    My client is saying the input files will be coming in the below format   The files we are getting will be ~ delimmited and with no text qualifires and the freq is none   could you please explain me what is text qualifires and the freq is none  ? ... View more

Dear Experts ,   I am in a need of an automation of the file folder path , The exporting file should be taken and placed in the folder and folder name should be todays date ,which should automatically identified . Could any one help on this . I tried with the attached macro  but it is not working %let td_dt=today(); data _NULL; call symput ('Folder_dt',put(&td_dt, YYMMDDd10.)); run; %put &Folder_dt;   ... View more

HI , I have a data set like below Year Claim  Loss_paid  Loss_Incured 2008 100         500              100 2008 200        1000             200 2009 300         2000           300 2009 400        3000           400 I need to get an output like Year Claim_Count Loss_PAid Loss_incured 2008       2                  1500          300 2009      2                   5000          700   Year wise claims counts and sum value of Loss_paid and Loss_Incured ... View more

Hello,   I need to filter data as per the different date range requirements   The requirements are   1. The claims Loss Date between October 01 and oCTOBER 31 2017. 2. CLAIMS LAST UPDATED DATE between October 01 and oCTOBER 31 2017 3. Since we use the second condition there should be claims that have old loss dates , so I need only the Claims Loss date from 2015 January 01 with the Claims Last Updated date between October 01 and oCTOBER 31 2017   Please help me on this   ... View more