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
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 CAN YOU HELP ME PLEASE? I HAVE AN IMPORTANT EXAM BUT I DON'T KNOW WHAT IS THE CORRECT ANSWER FOR THIS QUESTION.
... 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 CAN YOU HELP ME PLEASE? I HAVE AN IMPORTANT EXAM BUT I DON'T KNOW WHAT IS THE CORRECT ANSWER FOR THIS QUESTION.
... 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 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 THE MEAN FOT THE DOWNPAYMENT VARIABLE BELOW? DOWNPAYMENT 10 . 2 0
... 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