topic Re: SQL in SAS Programming

SQL

Ranjeeta — Tue, 18 Dec 2018 15:54:07 GMT

Hello I am writing a query in Microsoft SQL Server management studio and not sas but am getting an error with the statement below

I dont have training in SQL Wold someone be able to advise how to write the query corectly?

create table TAVIPx as select [WaitlistEntryID],[TAVIAccessSiteCD],[TransCathAorticValveInterventionIND]from [dbo].[CardiacReferralTAVIIntraProcedure];

Re: SQL

Jagadishkatam — Tue, 18 Dec 2018 16:22:23 GMT

Could you please post the error for better response.

as per the code provided I believe there is no space between [TransCathAorticValveInterventionIND] and from

so i updated the code to have space.

you may try it

create table TAVIPx as select [WaitlistEntryID],[TAVIAccessSiteCD],[TransCathAorticValveInterventionIND] from [dbo].[CardiacReferralTAVIIntraProcedure];

Re: SQL

Ranjeeta — Tue, 18 Dec 2018 17:23:09 GMT

Thankyou !!
How would I add more years to the code below e.g :2018-04-1' and '2019-03-31'
USE WCPRDDB1
GO

SELECT

ip.WaitlistEntryID
,ip.TAVIAccessSiteCD
,ip.TransCathAorticValveInterventionIND
,cwle.RemovalDate
,f.FacilityName
,f.FacilityNumber
FROM
CardiacWaitListEntry CWLE

INNER JOIN [CardiacReferralTAVIIntraProcedure] IP ON
CWLE.waitlistentryID = ip.waitlistentryid

INNER JOIN Site S ON
s.SiteNumber = cwle.AcceptanceSiteNumber

INNER JOIN FacilitySiteRel FSR ON
Fsr.SiteNumber = s.sitenumber

INNER JOIN Facility F On
F.FacilityNumber = fsr.FacilityNumber

WHERE
IP.TransCathAorticValveInterventionIND = 'Y'
AND cwle.RemovalDate between '2017-04-1' and '2018-03-31'
AND cwle.removalreasonCD = 'PS'
and cwle.fundingsourceCD = 'H'
and cwle.authorityissuing = 'CANON'

Re: SQL

SASKiwi — Tue, 18 Dec 2018 20:33:38 GMT

AND cwle.RemovalDate between '2017-04-01' and '2019-03-31'