proc sql;
create table Merged as
select a.*,
b. Sum_Engine,
b.Mean_Engine
from ID_set a
left join (
select Make,
sum(EngineSize) as Sum_Engine,
Mean(EngineSize) as Mean_Engine
from Data_set
group by a.Make
) b on a.Make= b.Make
quit;
... View more
follow the example in : https://documentation.sas.com/?docsetId=casref&docsetTarget=n0lgusu0v43zxwn1kc5m6cvtnzey.htm&docsetVersion=3.4&locale=en try by example: caslib Analytic_Scoring path="<your_path>"
datasource=(srctype="<source_type>");
libname mycas cas caslib=Analytic_Scoring;
data mycas.LAB_RESULTS_CLASSIFICATION(append=force);
set Analytic_Scoring.data201902;
run;
... View more
Hi! Do you know anything about statistics? in this case the crosstab = table of the sums of squares and crossproducts he sums of squares and crossproducts data TEST;
input A B C;
datalines;
1 0 1
0 1 0
0 0 1
1 0 1
1 1 1
0 1 1
1 0 1
1 0 0
0 1 0
0 1 1
;
run;
proc corr data=TEST SSCP outp=SSCP noprint;
var A B C;
run; or a cleaner code (without unnecessary columns) proc corr data=TEST SSCP outp=SSCP(drop = INTERCEPT where=(_TYPE_ ="SSCP" and _NAME_ ne "Intercept")) noprint;
var A B C;
run;
... View more
data TEST;
format DAY1 DAY2 date9.;
DAY1= "10mar2019"d;
DAY2= "20mar2019"d;
DIFF = intck('WEEKDAY', DAY1, DAY2);
run; In fact, it's 8 business days and not 7.
... View more
data A;
input ID AGE IN_2012 $1.;
datalines;
1 30 Y
;
run;
data B;
input ID AGE IN_2013 $1.;
datalines;
;
run;
data C;
input ID AGE IN_2014 $1.;
datalines;
1 32 Y
;
run;
data D;
input ID AGE IN_2015 $1.;
datalines;
1 33 Y
;
run;
data E;
input ID AGE IN_2016 $1.;
datalines;
1 34 Y
;
run;
data F;
input ID AGE IN_2017 $1.;
datalines;
1 35 Y
;
run;
data G;
input ID AGE IN_2018 $1.;
datalines;
1 36 Y
;
run;
data A_TO_G;
set A B C D E F G;
keep ID AGE;
run;
proc sort data=A_TO_G nodupkey;
by ID AGE;
run;
proc sort data=A;
by ID AGE;
run;
proc sort data=B;
by ID AGE;
run;
proc sort data=C;
by ID AGE;
run;
proc sort data=D;
by ID AGE;
run;
proc sort data=E;
by ID AGE;
run;
proc sort data=F;
by ID AGE;
run;
proc sort data=G;
by ID AGE;
run;
data ALL_TABLE;
merge A_TO_G(in=a)
A(drop=age)
B(drop=age)
C(drop=age)
D(drop=age)
E(drop=age)
F(drop=age)
G(drop=age);
by ID;
if a;
run;
... View more
proc sql;
select custID,
HomeCity,
TripCity,
min(DateTime) as FirstDateTime,
max(DateTime) as LastDateTime,
sum(Amt) as TotalAmt
from Transaction_Table
group by custID,
HomeCity,
TripCity;
quit;
... View more
Hi, I modified the Rezza's code and put the information in a row by id: proc sort data=have;
by id date;
run;
data change;
retain id firstdate firstvalue lastdate lastvalue diff;
format firstdate lastdate ddmmyy10.;
set have;
by id;
if first.id then
do;
firstdate = date;
firstvalue = value;
diff= value;
end;
if last.id then
do;
lastdate = date;
lastvalue = value;
diff = diff - value;
output;
end;
drop date value;
run;
... View more
