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];
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];
AND cwle.RemovalDate between '2017-04-01' and '2019-03-31'
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.