Hi Experts,
Is it possible to convert below mentioned sql code to data step. i can't use sql in my coding. Please help.
proc sql;
create table safety.test as
select distinct project, employee, supervisor, team, qcdate, hub, COMP, COMPERR,
sum(COMP,COMPERR) as sumcomp, (COMP/(COMP+COMPERR)) AS CasePercentage
from
(select distinct project, employee, supervisor, team, qcdate, hub, sum(input(Case_ID_for_QCCOMP,BESt12.)) as COMP, sum(input(Case_ID_for_QCCOMPERR,BEST12.)) as COMPERR
FROM safety.stag3
group by project, employee, supervisor, team, qcdate, hub
)
quit;
Thanks
I would use a combination of data step and summary procedure such as:
data start; set safety.stag3; comp = input(Case_ID_for_QCCOMP,BESt12.); comperr = input(Case_ID_for_QCCOMPERR,BESt12.); run; proc summary data=start nway; class project employee supervisor team qcdate hub; var comp comperr; output out=startsum sum=; run; data want; set startsum; sumcomp = sum(comp,comperr); casepercentage = comp/sumcomp; run;
I will say I find wanting to add with variables with something like Case_ID in the name looks a tad odd though.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: