Hi all,
please help
I am getting the following error
ERROR: Expression using IN has components that are of different data types.
Database Sample:
ID BeginDT Loc Amount
1 12Feb2016: 08:30:00.000000 NY $20
2 19Mar2016: 08:30:00.000000 NY $40
6 28Mar2016: 08:30:00.000000 NJ $40
15 05Jan2016: 08:30:00.000000 NY $60
11 11Dec2015: 08:30:00.000000 NC $40
*** I want to use BEGINDT as my FILTER
*** BeginDT is DATETIME25.6 format and numeric
PLease help me thank you all
willj
Perhaps you didn't specify the dt literal?
Like @Reeza said, you need to share your code so that we can see what's going on/wrong...
data want;
set have;
where datepart(begindt) > '12dec2015'd;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.