Information Technology Reference
In-Depth Information
QUERY_FOR_H94A.TC2,
QUERY_FOR_H94A.TC2S1,
QUERY_FOR_H94A.TC2S1_1,
QUERY_FOR_H94A.TC2S1_2,
QUERY_FOR_H94A.TC2S2,
QUERY_FOR_H94A.TC3,
QUERY_FOR_H94A.TC3S1,
QUERY_FOR_H94A.TC3S1_1,
QUERY_FOR_H94A.RXSF05X,
QUERY_FOR_H94A.RXMR05X,
QUERY_FOR_H94A.RXMD05X,
QUERY_FOR_H94A.RXPV05X,
QUERY_FOR_H94A.RXVA05X,
QUERY_FOR_H94A.RXTR05X,
QUERY_FOR_H94A.RXOF05X,
QUERY_FOR_H94A.RXSL05X,
QUERY_FOR_H94A.RXWC05X,
QUERY_FOR_H94A.RXOT05X,
QUERY_FOR_H94A.RXOR05X,
QUERY_FOR_H94A.RXOU05X,
QUERY_FOR_H94A.RXXP05X,
QUERY_FOR_H94A.PERWT05F,
QUERY_FOR_H94A.VARSTR,
QUERY_FOR_H94A.VARPSU,
((CASE WHEN “ACTONEL” = QUERY_FOR_H94A.RXNAME THEN “Actonel” WHEN “ACTONEL
(DOSEPACK,FILM-COATED)” = QUERY_FOR_H94A.RXNAME THEN “Actonel” WHEN “ACTONEL (FILM-COAT-
ED)” = QUERY_FOR_H94A.RXNAME THEN “Actonel” WHEN “BONIVA” = QUERY_FOR_H94A.RXNAME THEN
“Boniva” WHEN “BONIVA (FILM-COATED)” = QUERY_FOR_H94A.RXNAME THEN “Boniva” WHEN “CALCI-
TONIN SALMON” = QUERY_FOR_H94A.RXNAME THEN “Calcitonin” WHEN “ESTROGEN CON” = QUERY_FOR_
H94A.RXNAME THEN “Estrogen” WHEN “ESTROGEN CONJUGATED” = QUERY_FOR_H94A.RXNAME THEN “Es-
trogen” WHEN “ESTROGENS” = QUERY_FOR_H94A.RXNAME THEN “Estrogen” WHEN “ESTROGENS CONJ”
= QUERY_FOR_H94A.RXNAME THEN “Estrogen” WHEN “ESTROGENS CONJUGATED” = QUERY_FOR_H94A.
RXNAME THEN “Estrogen” WHEN “ESTROGENS, CONJ.” = QUERY_FOR_H94A.RXNAME THEN “Estrogen”
WHEN “ESTROGENS, CONJUGATED CR” = QUERY_FOR_H94A.RXNAME THEN “Estrogen” WHEN “EVISTA” =
QUERY_FOR_H94A.RXNAME THEN “Evista” WHEN “EVISTA (UNIT OF USE)” = QUERY_FOR_H94A.RX-
NAME THEN “Evista” WHEN “FORTEO” = QUERY_FOR_H94A.RXNAME THEN “Forteo” WHEN “FOSAMAX” =
QUERY_FOR_H94A.RXNAME THEN “Fosamax” WHEN “FOSAMAX (RASPBERRY)” = QUERY_FOR_H94A.RXNAME
THEN “Fosamax” WHEN “FOSAMAX (UNIT OF USE)” = QUERY_FOR_H94A.RXNAME THEN “Fosamax” WHEN
“FOSAMAX (UNIT OF USE,BLISTER PCK)” = QUERY_FOR_H94A.RXNAME THEN “Fosamax” WHEN “FOSAMAX
(UNIT OF USE,BLISTER PK)” = QUERY_FOR_H94A.RXNAME THEN “Fosamax” WHEN “FOSAMAX PLUS D” =
QUERY_FOR_H94A.RXNAME THEN “Fosamax” ELSE QUERY_FOR_H94A.RXNAME END)) AS RevisedRXName
FROM SASUSER.QUERY_FOR_H94A AS QUERY_FOR_H94A;
QUIT;
Search WWH ::
Custom Search