I have the following Teradata code that successfully performs a Z test on data in the z_base table
SELECT * FROM TD_ZTest (
ON z_base AS InputTable
USING
FirstSampleColumn ('FALLOW_RR')
SecondSampleColumn ('NONFALLOW_RR')
AlternativeHypothesis ('two-tailed')
) AS dt;
The output is shown in the attached image.
I need help with the following:
How can I attach the output to the z_base table? How can I group the data by a specific column and perform the Z test on each group individually? Thanks!
SELECT * FROM TD_ZTest ( ON z_base AS InputTable USING FirstSampleColumn ('FALLOW_RR') SecondSampleColumn ('NONFALLOW_RR') AlternativeHypothesis ('two-tailed') ) AS dt;
I want z_base attached to output and an output line for each group.
发布者:admin,转转请注明出处:http://www.yc00.com/questions/1744699202a4588676.html
评论列表(0条)