Various questions on SAS procedures

nenè — Fri, 25 Aug 2017 08:36:29 GMT

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

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;

Re: proc sql

RW9 — Fri, 25 Aug 2017 08:35:30 GMT

These are some sort of learning exercises are they not? If so they are there for you to learn, copy the code into your code window in University Edition, or whichever SAS product you use and run them to get the outputs.

Also, as noted before use a descriptive title line.

Re: Various questions on SAS procedures

Kurt_Bremser — Fri, 25 Aug 2017 09:43:40 GMT

See Maxim 4.

topic Re: proc sql in SAS Procedures

Various questions on SAS procedures

Re: proc sql

Re: Various questions on SAS procedures