BookmarkSubscribeRSS Feed
nenè
Calcite | Level 5
ASSET TIPEDOBVEHICLE_AGEVEHICLE COSTREG_DATESNAPSHOT_DATETERM
NEW10/09/8101500001/03/1401/04/1412
USED15/08/8661000001/09/1301/04/1412
NEW26/11/9202000001/03/1401/04/1424
USED17/02/9518500001/09/1201/04/1436

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??

3 REPLIES 3
Reeza
Super User

No, it's not correct. 

 

You're not accounting for the vehicles not older than 12 properly - mostly I think you're using the wrong variable. 

ChrisBrooks
Ammonite | Level 13

It  looks to me like reg_date is probably the correct variable to use as term is most likely the term of a loan issued to buy the vehicle.

HB
Barite | Level 11 HB
Barite | Level 11

You don't really provide enough information.

 

Vehicles not older than 12?  Is that records with a vehicle_age value of less than or equal to 12?  Or is it Term vlaues?  Or is it current date minus reg_date?  Or is it something else?

 

Let's assume a term amount <= 12.

 

So with data like

data stuff;
   input ASSET_TYPE $4. VEHICLE_COST TERM;
datalines;
NEW 15000 12
USED 10000 12
NEW 20000 24
USED 5000 36
NEW 15000 6
NEW 15000 9
USED 10000 6
;
run;

You can use the SQL you posted

proc sql;
create table cost_by_asset_type as
	select asset_type, sum(vehicle_cost)
	from stuff
	where term <=12
	group by asset_type;
quit;

 and come up with

 

ASSET_TYPE _TEMG001
NEW 45000
USED 20000

 

Is this what you want?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 805 views
  • 0 likes
  • 4 in conversation