ASSET TIPE DOB VEHICLE_AGE VEHICLE COST REG_DATE SNAPSHOT_DATE TERM NEW 10/09/81 0 15000 01/03/14 01/04/14 12 USED 15/08/86 6 10000 01/09/13 01/04/14 12 NEW 26/11/92 0 20000 01/03/14 01/04/14 24 USED 17/02/95 18 5000 01/09/12 01/04/14 36 write sql procedure using dataset_initial to calculate total vehicle cost (TOT_VEH_COST) by ASSETTYPE for vehicles not older than 12. i think that :       select Assettype,SUM(Vehicle_cost) as TOTAL_COST from Initial_data where TERM<=12 group by Assettype;   IS CORRECT?? ... View more

i) What macro statement would write the output to the log after the below code is submitted? ii) What would the resulting output be?   data clap_attib;  UN= "GMAC"; PD= "BANK"; run; data_nuli_; set clap_attib; UN1 = cats("'",UN,"'"); PD1 = cats("" PD,"");   cali symput("UN",UN1); cali symput("PD",PD1); run; ... View more

  Hi to all, i have a problem with this: The dataset initial is below: ASSET TIPE DOB VEHICLE_AGE VEHICLE COST REG_DATE SNAPSHOT_DATE TERM NEW 10/09/81 0 15000 01/03/14 01/04/14 12 USED 15/08/86 6 10000 01/09/13 01/04/14 12 NEW 26/11/92 0 20000 01/03/14 01/04/14 24 USED 17/02/95 18 5000 01/09/12 01/04/14 36    can you help me please??   Find the resulting outputs for each of the below 1. proc freq data= work initial_data noprint; table ASSETTYPE/out=freq (drop=percent); where vehicle_age<12; run;   2.proc summary data=work.initial_data nway missing; class ASSETTYPE; var vehicle_cost; where year(reg_date)>2012; output out=summary (drop=type__freq_) sum(vehicle_cost=summary; run;   3.proc sort data=freq(where=(ASSETTYPE='NEW'));by ASSETTYPE;run; proc sort data=summary;by ASSETTYPE;run; data output_merged (keep=new_var); merge freq (in=a)summary(in=b); by ASSETTYPE; if a;   new_var='count*summary; run;     ... View more

Hi to all, i have a problem with this: The dataset initial is below: ASSET TIPE DOB VEHICLE_AGE VEHICLE COST REG_DATE SNAPSHOT_DATE TERM NEW 10/09/81 0 15000 01/03/14 01/04/14 12 USED 15/08/86 6 10000 01/09/13 01/04/14 12 NEW 26/11/92 0 20000 01/03/14 01/04/14 24 USED 17/02/95 18 5000 01/09/12 01/04/14 36     CAN YOU TELL ME WHAT IS A SAS DATASTEP WHICH CAN BE USED TO FIND THE AGE (IN WHOLE YEARS) FOR THE CUSTOMERS OF THE NEW VEHICLES AS AT SNAPSHOT_DATE.? AND WHAT IS A SAS DATASTEP CAN BE USED TO FIND THE CONTRACT END DATE OF THE VEHICLE WITH TERM =36, ASSUMING THE VEHICLE WAS PURCHASED ON THE SNAPSHOT_DATE?   I THINK THAT THE CORRECT ANSWER IS:  SELECT ADD_MONTHS(SNAPSHOTDATE,36) FROM'INITIAL DATA' WHERE TERM=36 ... View more

  Hi. i have to write SQL procedure using dataset 'Inizial_data' to calcolate total vehicle cost (TOT_VEH-COST) BY ASSETTYPE for vehicles not older than 10.What will be my output?   Can we help me?   thank you     ... View more

Hello,   can i ask a list of 3 macro debugging options in SAS? Please i have to do for an universitary exams 🙂   thank you very much ... View more