International Bull Evaluation Service evaluations from May 2005 were examined for country bias by... more International Bull Evaluation Service evaluations from May 2005 were examined for country bias by comparing Holstein full-brother families. Countries with ≥25 bulls in multicountry full-brother families were included. The model fit evaluations of US estimated breeding values (EBV) by absorbing full-brother family and producing solutions for country of brothers. For yield and somatic cell score, 24,611 and 22,802 bulls, respectively, were included in the analysis. The study was repeated fitting evaluations on the scales of 9 countries other than the United States. On all countries' scales, bulls from Australia, Germany, Great Britain, and Japan had greater EBV for milk yield than did their full brothers from the United States; Italian bulls had lower EBV. Bulls from Australia, Great Britain, and South Africa had an advantage in EBV for fat yield. For EBV for protein yield, bulls from Germany, Great Britain, Japan, and South Africa had an advantage, whereas bulls from the Netherlands were disadvantaged. For somatic cell score, US bulls were advantaged compared with bulls from South Africa. Significance and rankings of apparent biases were similar across country scales of the international evaluations. Causes of those differences are unknown; differences in incorporation of parental data in national and International Bull Evaluation Service evaluations are a possibility.
The objective of this study was to determine the optimum replacement policy for Holstein dairy he... more The objective of this study was to determine the optimum replacement policy for Holstein dairy herds in Iran using a dynamic programming model. Cows were described in terms of state variables that included milk production class, parity, pregnancy status, and month in milk with a 1-mo stage length. The objective function maximized the net present value of cows over a 15-yr planning horizon. Markov simulation was used to estimate expected herd dynamics under the optimal decision plan determined by dynamic programming. Stochastic elements included probabilities of pregnancy and abortion, production level, and involuntary culling. The optimum annual culling rate was estimated to be 31.4%, and cows had an expected herd life (time from first calving until culling) of 3.18 yr. High replacement cost and low carcass value resulted in only 2.87% voluntary culling (i.e., optimal model-based replacement). Assuming a heat detection rate of 0.4, cows averaged 2.8 services per lactation under the optimal policy. Sensitivity analyses were carried out to evaluate the effect of milk price, herd-average production, feed cost, heifer price, and carcass value on optimum replacement decisions. Herd-average production, replacement cost, and risk of involuntary culling were important factors affecting the optimal culling policy. Changes in the price of feed, calves, and milk and the probability of pregnancy had no considerable effect on the optimal policy considering the market situation in Iran during 2008.
International Bull Evaluation Service evaluations from May 2005 were examined for country bias by... more International Bull Evaluation Service evaluations from May 2005 were examined for country bias by comparing Holstein full-brother families. Countries with ≥25 bulls in multicountry full-brother families were included. The model fit evaluations of US estimated breeding values (EBV) by absorbing full-brother family and producing solutions for country of brothers. For yield and somatic cell score, 24,611 and 22,802 bulls, respectively, were included in the analysis. The study was repeated fitting evaluations on the scales of 9 countries other than the United States. On all countries' scales, bulls from Australia, Germany, Great Britain, and Japan had greater EBV for milk yield than did their full brothers from the United States; Italian bulls had lower EBV. Bulls from Australia, Great Britain, and South Africa had an advantage in EBV for fat yield. For EBV for protein yield, bulls from Germany, Great Britain, Japan, and South Africa had an advantage, whereas bulls from the Netherlands were disadvantaged. For somatic cell score, US bulls were advantaged compared with bulls from South Africa. Significance and rankings of apparent biases were similar across country scales of the international evaluations. Causes of those differences are unknown; differences in incorporation of parental data in national and International Bull Evaluation Service evaluations are a possibility.
The Journal of adolescent health : official publication of the Society for Adolescent Medicine, 2015
We evaluated the feasibility of a multilevel intervention to increase the human papillomavirus (H... more We evaluated the feasibility of a multilevel intervention to increase the human papillomavirus (HPV) vaccine initiation among adolescents. We used a four-arm factorial, quasi-experimental trial to assess feasibility and short-term, preliminary effectiveness of a health system-level, gender-specific postcard campaign and an in-clinic health information technology (HIT) system. Between August and November 2013, we tested the intervention among 11- to 17-year-olds without prior HPV vaccine claims in the Florida Medicaid or Children's Health Insurance Program encounters (2,773 girls and 3,350 boys) who attended or were assigned to primary care clinics in North Central Florida. At least one postcard was deliverable to 95% of the parents. Most parents (91% boys' and 80% girls') who participated in the process evaluation survey (n = 162) reported seeking additional information about the vaccine after receiving the postcard. Only 8% (57 of 1,062) of the adolescents assigned to a...
Lameness is a multifactorial condition with many causes. In this study, cow lifetime records were... more Lameness is a multifactorial condition with many causes. In this study, cow lifetime records were used to quantify the incidence of specific lameness-causing lesions and investigate factors associated with those lesions. Of primary interest were the effects of seasonality and the effects of thin soles (TS). Thin sole-induced toe ulcers (TSTU) occurring adjacent to the white line in the apical portion of the weight-bearing surface were distinguished from white line disease (WLD) occurring in the region of the abaxial heel sole junction. Sole (SU), heel (HU), and toe (TU) ulcers; TS; sole punctures (SP); leg injuries (INJ); and other (OTH) lesions (e.g., infectious diseases, laminitis, unclassified hemorrhage) were also considered. Data were collected from May 2004 through October 2007 and included records for 4,915 cows of which 1,861 had at least one recorded lameness event. Of these, 20% were TSTU, 20% OTH, 16% SU, 13% TS, 10% WLD, 8% HU, 6% INJ, 4% SP, and 2% TU. Annual incidence ...
The Interbull procedure for combining dairy bull evaluations uses estimated genetic correlations ... more The Interbull procedure for combining dairy bull evaluations uses estimated genetic correlations between countries. It is important to know whether the resulting difficulties from differences in ranking in each country are justified by improved accuracy relative to a system assuming unity correlations. Data submitted for the May 2001 yield and somatic cell score (SCS) Interbull evaluations were processed once with the usual estimated genetic correlations (E01) and again assuming these correlations to be essentially unity (0.995; U01). The 2 sets of resulting evaluations were compared with August 2004 national evaluations (N04) for bulls not having local evaluations used in the 2001 evaluations. Thus, the examination was of Interbull evaluations from foreign data in predicting national evaluations. Countries in the study for yield were Australia, Canada, France, Germany, Great Britain, Ireland, Italy, The Netherlands, New Zealand, and the United States. Countries included for SCS wer...
Somatic cell score (SCS) evaluations have been published in the United States since 1994 and inte... more Somatic cell score (SCS) evaluations have been published in the United States since 1994 and international evaluations have been available through Interbull since May 2001. The accumulated data provides an opportunity to investigate the accuracy and stability of SCS evaluations. United States domestic evaluations from January 1995 through August 2004, for 21,500 Holstein bulls were considered, over time and sequentially within bull, for changes to the November 2004 evaluation. On average, predicted transmitting ability (PTA) SCS increased (worsened) by 0.002 from earlier evaluations to November 2004. Although bias was small, PTA changes were more than expected based on change in reliability. When looked at sequentially, bulls' earlier evaluations were generally lower (i.e., merit was overestimated) relative to November 2004. Differences were small, and PTA SCS increased steadily with the addition of second-crop daughters. All 524,081 evaluations were considered pairwise providin...
Combining foreign daughter data with domestic information in dairy bull genetic evaluations has b... more Combining foreign daughter data with domestic information in dairy bull genetic evaluations has been shown to improve prediction of future domestic evaluations for US bulls. This study focused on the accuracy of Interbull evaluations of bulls with only foreign daughters, in predicting the latest domestic evaluations (based on US daughters). August 2003 USDA evaluations based only on US daughters were matched with the most recent February or August Interbull evaluations without US daughters. A minimum reliability of at least 80% for yield and 70% for somatic cell score (SCS) was required in both evaluations. This provided pairs of evaluations based on different daughters (foreign or US) for 286 bulls (60 bulls for SCS). Mean Interbull reliabilities on the US scale were 88% for yield and 84% for SCS, and the mean US reliability for the current evaluations was 91% for yield and 80% for SCS. Correlations between the Interbull and domestic evaluations were 0.90, 0.87, 0.90, and 0.87 for ...
Genetic evaluations for milk, fat, and protein from 1995 through August 2003 for 17,987 Holstein ... more Genetic evaluations for milk, fat, and protein from 1995 through August 2003 for 17,987 Holstein bulls in active artificial insemination (AI) service were examined for changes to the November 2003 evaluation. Evaluations for active AI bulls at each of 31 evaluation dates showed mean declines to November 2003. No evidence was seen of a worsening situation over time. Bulls' early evaluations with active AI status showed much larger declines, but this overevaluation diminished and essentially disappeared after 3 yr. The bulls with first active AI evaluations since 1995 were the primary focus of the study. The influx of second-crop daughters did not appear to cause a decline in evaluations for these bulls, attesting to the successful modification to the genetic evaluation system by expanding the genetic variance of short records. Mean declines and the variation of those differences were generally similar by bull sampling organization. A change from active to inactive AI status was g...
A national fertility evaluation was developed based on pregnancy rate, which measures the percent... more A national fertility evaluation was developed based on pregnancy rate, which measures the percentage of nonpregnant cows becoming pregnant within each 21-d opportunity period. Data for evaluation are days open, which are calculated as date pregnant minus previous calving date. Date pregnant is determined from last reported breeding or from subsequent calving minus expected gestation length. Success or failure of last breeding can be confirmed by veterinary diagnosis or a report that the cow was sold because of infertility. Data are adjusted for parity and calving season within geographic region and time period and evaluated. Fertility records are considered complete at 250 d in milk, and lower and upper limits of 50 and 250 d are applied to days open. For calculation of genetic evaluations, days open are converted to pregnancy rate by the linear formula pregnancy rate = 0.25 (233 - days open). Evaluations are expressed as predicted transmitting ability for daughter pregnancy rate, a...
International Bull Evaluation Service (Interbull) Holstein evaluations from February 1995 through... more International Bull Evaluation Service (Interbull) Holstein evaluations from February 1995 through February 2003 were used to determine characteristics of progeny testing for Holstein bulls in Australia, Canada, Denmark, France, Germany, Italy, New Zealand, Sweden, The Netherlands, and the United States. The decision to graduate a bull from progeny test (PT) was assumed to have been made based on the second Interbull evaluation, and graduation was defined as the addition of 200 daughters in the period 2.5 to 4.5 yr later. Mean bull age at PT decision varied across countries by 12 mo. Mean numbers of herds and daughters ranged from 39 to 111 and 54 to 144, respectively. Countries with higher requirements for official evaluations generally had more herds and daughters but older bulls at PT decision. Mean estimated breeding values for yield traits of sires of tested bulls were most similar across countries for fat, differing by only 6.4 kg. The four countries highest for sire protein di...
Heterosis and breed differences were estimated for milk yield traits, somatic cell score (SCS), a... more Heterosis and breed differences were estimated for milk yield traits, somatic cell score (SCS), and productive life (PL), a measure of longevity. Yield trait data were from 10,442 crossbreds and 140,421 purebreds born since 1990 in 572 herds. Productive life data were from 41,131 crossbred cows and 726,344 purebreds born from 1960 through 1991. The model for test-day yields and SCS included effects of herd-year-season, age, lactation stage, regression on sire's predicted transmitting ability, additive breed effects, heterosis, and recombination. The model for PL included herd-year-season, breed effects, and general heterosis. All effects were assumed to be additive, but estimates of heterosis were converted to a percentage of the parent breed average for reporting. Estimates of general heterosis were 3.4% for milk yield, 4.4% for fat yield, and 4.1% for protein yield. A coefficient of general recombination was derived for multiple-breed crosses, but recombination effects were no...
The milk somatic cell count (MSCC) forms the basis of abnormal milk control programs world wide f... more The milk somatic cell count (MSCC) forms the basis of abnormal milk control programs world wide for goats, cows and sheep. To better understand factors that contribute to elevations in MSCC, the effects of stage of lactation, parity, breed and state/area in the United States ( ...
SAS/ACCESS ® provides virtually seamless interaction with relational databases such as DB2 ®. The... more SAS/ACCESS ® provides virtually seamless interaction with relational databases such as DB2 ®. The SQL passthrough facility gives direct access to the database, but requires knowledge of the native SQL syntax. Alternately, the libname statement can be used to assign SAS ® library references to database objects, allowing database tables to be used like SAS data sets. SAS SQL functions are available that cannot be used with the pass-through facility. For data step diehards, database tables can be treated (almost) just like indexed SAS data sets. SAS statistical procedures can also reference database tables directly using the libref name. This paper covers the basics of accessing database data from SAS using SQL and data step language, using the database with SAS procedures, and getting information about the database delivered through SAS.
ABSTRACT Thesis research directed by Dept. of Animal and Avian Sciences. Thesis (M.S.)--Universit... more ABSTRACT Thesis research directed by Dept. of Animal and Avian Sciences. Thesis (M.S.)--University of Maryland, College Park, 2001. Includes bibliographical references (leaves 60-63).
International Bull Evaluation Service evaluations from May 2005 were examined for country bias by... more International Bull Evaluation Service evaluations from May 2005 were examined for country bias by comparing Holstein full-brother families. Countries with ≥25 bulls in multicountry full-brother families were included. The model fit evaluations of US estimated breeding values (EBV) by absorbing full-brother family and producing solutions for country of brothers. For yield and somatic cell score, 24,611 and 22,802 bulls, respectively, were included in the analysis. The study was repeated fitting evaluations on the scales of 9 countries other than the United States. On all countries' scales, bulls from Australia, Germany, Great Britain, and Japan had greater EBV for milk yield than did their full brothers from the United States; Italian bulls had lower EBV. Bulls from Australia, Great Britain, and South Africa had an advantage in EBV for fat yield. For EBV for protein yield, bulls from Germany, Great Britain, Japan, and South Africa had an advantage, whereas bulls from the Netherlands were disadvantaged. For somatic cell score, US bulls were advantaged compared with bulls from South Africa. Significance and rankings of apparent biases were similar across country scales of the international evaluations. Causes of those differences are unknown; differences in incorporation of parental data in national and International Bull Evaluation Service evaluations are a possibility.
The objective of this study was to determine the optimum replacement policy for Holstein dairy he... more The objective of this study was to determine the optimum replacement policy for Holstein dairy herds in Iran using a dynamic programming model. Cows were described in terms of state variables that included milk production class, parity, pregnancy status, and month in milk with a 1-mo stage length. The objective function maximized the net present value of cows over a 15-yr planning horizon. Markov simulation was used to estimate expected herd dynamics under the optimal decision plan determined by dynamic programming. Stochastic elements included probabilities of pregnancy and abortion, production level, and involuntary culling. The optimum annual culling rate was estimated to be 31.4%, and cows had an expected herd life (time from first calving until culling) of 3.18 yr. High replacement cost and low carcass value resulted in only 2.87% voluntary culling (i.e., optimal model-based replacement). Assuming a heat detection rate of 0.4, cows averaged 2.8 services per lactation under the optimal policy. Sensitivity analyses were carried out to evaluate the effect of milk price, herd-average production, feed cost, heifer price, and carcass value on optimum replacement decisions. Herd-average production, replacement cost, and risk of involuntary culling were important factors affecting the optimal culling policy. Changes in the price of feed, calves, and milk and the probability of pregnancy had no considerable effect on the optimal policy considering the market situation in Iran during 2008.
International Bull Evaluation Service evaluations from May 2005 were examined for country bias by... more International Bull Evaluation Service evaluations from May 2005 were examined for country bias by comparing Holstein full-brother families. Countries with ≥25 bulls in multicountry full-brother families were included. The model fit evaluations of US estimated breeding values (EBV) by absorbing full-brother family and producing solutions for country of brothers. For yield and somatic cell score, 24,611 and 22,802 bulls, respectively, were included in the analysis. The study was repeated fitting evaluations on the scales of 9 countries other than the United States. On all countries' scales, bulls from Australia, Germany, Great Britain, and Japan had greater EBV for milk yield than did their full brothers from the United States; Italian bulls had lower EBV. Bulls from Australia, Great Britain, and South Africa had an advantage in EBV for fat yield. For EBV for protein yield, bulls from Germany, Great Britain, Japan, and South Africa had an advantage, whereas bulls from the Netherlands were disadvantaged. For somatic cell score, US bulls were advantaged compared with bulls from South Africa. Significance and rankings of apparent biases were similar across country scales of the international evaluations. Causes of those differences are unknown; differences in incorporation of parental data in national and International Bull Evaluation Service evaluations are a possibility.
The Journal of adolescent health : official publication of the Society for Adolescent Medicine, 2015
We evaluated the feasibility of a multilevel intervention to increase the human papillomavirus (H... more We evaluated the feasibility of a multilevel intervention to increase the human papillomavirus (HPV) vaccine initiation among adolescents. We used a four-arm factorial, quasi-experimental trial to assess feasibility and short-term, preliminary effectiveness of a health system-level, gender-specific postcard campaign and an in-clinic health information technology (HIT) system. Between August and November 2013, we tested the intervention among 11- to 17-year-olds without prior HPV vaccine claims in the Florida Medicaid or Children's Health Insurance Program encounters (2,773 girls and 3,350 boys) who attended or were assigned to primary care clinics in North Central Florida. At least one postcard was deliverable to 95% of the parents. Most parents (91% boys' and 80% girls') who participated in the process evaluation survey (n = 162) reported seeking additional information about the vaccine after receiving the postcard. Only 8% (57 of 1,062) of the adolescents assigned to a...
Lameness is a multifactorial condition with many causes. In this study, cow lifetime records were... more Lameness is a multifactorial condition with many causes. In this study, cow lifetime records were used to quantify the incidence of specific lameness-causing lesions and investigate factors associated with those lesions. Of primary interest were the effects of seasonality and the effects of thin soles (TS). Thin sole-induced toe ulcers (TSTU) occurring adjacent to the white line in the apical portion of the weight-bearing surface were distinguished from white line disease (WLD) occurring in the region of the abaxial heel sole junction. Sole (SU), heel (HU), and toe (TU) ulcers; TS; sole punctures (SP); leg injuries (INJ); and other (OTH) lesions (e.g., infectious diseases, laminitis, unclassified hemorrhage) were also considered. Data were collected from May 2004 through October 2007 and included records for 4,915 cows of which 1,861 had at least one recorded lameness event. Of these, 20% were TSTU, 20% OTH, 16% SU, 13% TS, 10% WLD, 8% HU, 6% INJ, 4% SP, and 2% TU. Annual incidence ...
The Interbull procedure for combining dairy bull evaluations uses estimated genetic correlations ... more The Interbull procedure for combining dairy bull evaluations uses estimated genetic correlations between countries. It is important to know whether the resulting difficulties from differences in ranking in each country are justified by improved accuracy relative to a system assuming unity correlations. Data submitted for the May 2001 yield and somatic cell score (SCS) Interbull evaluations were processed once with the usual estimated genetic correlations (E01) and again assuming these correlations to be essentially unity (0.995; U01). The 2 sets of resulting evaluations were compared with August 2004 national evaluations (N04) for bulls not having local evaluations used in the 2001 evaluations. Thus, the examination was of Interbull evaluations from foreign data in predicting national evaluations. Countries in the study for yield were Australia, Canada, France, Germany, Great Britain, Ireland, Italy, The Netherlands, New Zealand, and the United States. Countries included for SCS wer...
Somatic cell score (SCS) evaluations have been published in the United States since 1994 and inte... more Somatic cell score (SCS) evaluations have been published in the United States since 1994 and international evaluations have been available through Interbull since May 2001. The accumulated data provides an opportunity to investigate the accuracy and stability of SCS evaluations. United States domestic evaluations from January 1995 through August 2004, for 21,500 Holstein bulls were considered, over time and sequentially within bull, for changes to the November 2004 evaluation. On average, predicted transmitting ability (PTA) SCS increased (worsened) by 0.002 from earlier evaluations to November 2004. Although bias was small, PTA changes were more than expected based on change in reliability. When looked at sequentially, bulls' earlier evaluations were generally lower (i.e., merit was overestimated) relative to November 2004. Differences were small, and PTA SCS increased steadily with the addition of second-crop daughters. All 524,081 evaluations were considered pairwise providin...
Combining foreign daughter data with domestic information in dairy bull genetic evaluations has b... more Combining foreign daughter data with domestic information in dairy bull genetic evaluations has been shown to improve prediction of future domestic evaluations for US bulls. This study focused on the accuracy of Interbull evaluations of bulls with only foreign daughters, in predicting the latest domestic evaluations (based on US daughters). August 2003 USDA evaluations based only on US daughters were matched with the most recent February or August Interbull evaluations without US daughters. A minimum reliability of at least 80% for yield and 70% for somatic cell score (SCS) was required in both evaluations. This provided pairs of evaluations based on different daughters (foreign or US) for 286 bulls (60 bulls for SCS). Mean Interbull reliabilities on the US scale were 88% for yield and 84% for SCS, and the mean US reliability for the current evaluations was 91% for yield and 80% for SCS. Correlations between the Interbull and domestic evaluations were 0.90, 0.87, 0.90, and 0.87 for ...
Genetic evaluations for milk, fat, and protein from 1995 through August 2003 for 17,987 Holstein ... more Genetic evaluations for milk, fat, and protein from 1995 through August 2003 for 17,987 Holstein bulls in active artificial insemination (AI) service were examined for changes to the November 2003 evaluation. Evaluations for active AI bulls at each of 31 evaluation dates showed mean declines to November 2003. No evidence was seen of a worsening situation over time. Bulls' early evaluations with active AI status showed much larger declines, but this overevaluation diminished and essentially disappeared after 3 yr. The bulls with first active AI evaluations since 1995 were the primary focus of the study. The influx of second-crop daughters did not appear to cause a decline in evaluations for these bulls, attesting to the successful modification to the genetic evaluation system by expanding the genetic variance of short records. Mean declines and the variation of those differences were generally similar by bull sampling organization. A change from active to inactive AI status was g...
A national fertility evaluation was developed based on pregnancy rate, which measures the percent... more A national fertility evaluation was developed based on pregnancy rate, which measures the percentage of nonpregnant cows becoming pregnant within each 21-d opportunity period. Data for evaluation are days open, which are calculated as date pregnant minus previous calving date. Date pregnant is determined from last reported breeding or from subsequent calving minus expected gestation length. Success or failure of last breeding can be confirmed by veterinary diagnosis or a report that the cow was sold because of infertility. Data are adjusted for parity and calving season within geographic region and time period and evaluated. Fertility records are considered complete at 250 d in milk, and lower and upper limits of 50 and 250 d are applied to days open. For calculation of genetic evaluations, days open are converted to pregnancy rate by the linear formula pregnancy rate = 0.25 (233 - days open). Evaluations are expressed as predicted transmitting ability for daughter pregnancy rate, a...
International Bull Evaluation Service (Interbull) Holstein evaluations from February 1995 through... more International Bull Evaluation Service (Interbull) Holstein evaluations from February 1995 through February 2003 were used to determine characteristics of progeny testing for Holstein bulls in Australia, Canada, Denmark, France, Germany, Italy, New Zealand, Sweden, The Netherlands, and the United States. The decision to graduate a bull from progeny test (PT) was assumed to have been made based on the second Interbull evaluation, and graduation was defined as the addition of 200 daughters in the period 2.5 to 4.5 yr later. Mean bull age at PT decision varied across countries by 12 mo. Mean numbers of herds and daughters ranged from 39 to 111 and 54 to 144, respectively. Countries with higher requirements for official evaluations generally had more herds and daughters but older bulls at PT decision. Mean estimated breeding values for yield traits of sires of tested bulls were most similar across countries for fat, differing by only 6.4 kg. The four countries highest for sire protein di...
Heterosis and breed differences were estimated for milk yield traits, somatic cell score (SCS), a... more Heterosis and breed differences were estimated for milk yield traits, somatic cell score (SCS), and productive life (PL), a measure of longevity. Yield trait data were from 10,442 crossbreds and 140,421 purebreds born since 1990 in 572 herds. Productive life data were from 41,131 crossbred cows and 726,344 purebreds born from 1960 through 1991. The model for test-day yields and SCS included effects of herd-year-season, age, lactation stage, regression on sire's predicted transmitting ability, additive breed effects, heterosis, and recombination. The model for PL included herd-year-season, breed effects, and general heterosis. All effects were assumed to be additive, but estimates of heterosis were converted to a percentage of the parent breed average for reporting. Estimates of general heterosis were 3.4% for milk yield, 4.4% for fat yield, and 4.1% for protein yield. A coefficient of general recombination was derived for multiple-breed crosses, but recombination effects were no...
The milk somatic cell count (MSCC) forms the basis of abnormal milk control programs world wide f... more The milk somatic cell count (MSCC) forms the basis of abnormal milk control programs world wide for goats, cows and sheep. To better understand factors that contribute to elevations in MSCC, the effects of stage of lactation, parity, breed and state/area in the United States ( ...
SAS/ACCESS ® provides virtually seamless interaction with relational databases such as DB2 ®. The... more SAS/ACCESS ® provides virtually seamless interaction with relational databases such as DB2 ®. The SQL passthrough facility gives direct access to the database, but requires knowledge of the native SQL syntax. Alternately, the libname statement can be used to assign SAS ® library references to database objects, allowing database tables to be used like SAS data sets. SAS SQL functions are available that cannot be used with the pass-through facility. For data step diehards, database tables can be treated (almost) just like indexed SAS data sets. SAS statistical procedures can also reference database tables directly using the libref name. This paper covers the basics of accessing database data from SAS using SQL and data step language, using the database with SAS procedures, and getting information about the database delivered through SAS.
ABSTRACT Thesis research directed by Dept. of Animal and Avian Sciences. Thesis (M.S.)--Universit... more ABSTRACT Thesis research directed by Dept. of Animal and Avian Sciences. Thesis (M.S.)--University of Maryland, College Park, 2001. Includes bibliographical references (leaves 60-63).
Uploads
Papers by Ashley Sanders