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'
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: