Hi,
I am trying to replicate the original SQL code into PROC SQL
I could not succeed . Could some one help me find my mistakes from the below???
Thanks
PROC SQL;
CREATE TABLE tempHAC AS
SELECT *
HAC1 AS Measure,
dat.Cal_Yr,
dat.Cal_Mo_Order,
1. <> in sql is not equal, while in SAS it is max, so change that to not equals
2. --('998.4','998.7') is a comment in SQL, remove that from the code or use SAS commenting
3. You'll have to make sure you specify the dates correctly but I *think* it should work from tehre.
1. <> in sql is not equal, while in SAS it is max, so change that to not equals
2. --('998.4','998.7') is a comment in SQL, remove that from the code or use SAS commenting
3. You'll have to make sure you specify the dates correctly but I *think* it should work from tehre.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.