About sasxii

sasxii · ‎10-03-2019

so I tried using that as well which was a datetime. format - which consisted of data X; set Y; if DATE >= '01SEP19:20:55:00'd and DATE <= '30SEP19:20:55:00'd; run; and it doesnt pull up anything, why would that be the case?

sasxii · ‎10-03-2019

underlying value?

sasxii · ‎10-03-2019

Hi everyone, I have a problem filtering a date based on the format new_date monyy5.; I have variables that have that format and I want to pull the data based on the month that they land on. I tired to do something like this data X; set Y; where new_date='SEP19'd; run; keeps telling me that I have an invalid date/time/datetime constant - why is that?

sasxii · ‎09-11-2019

what happens if I the value is not by a specific interval? how would this be done then?

sasxii · ‎09-11-2019

Would I do it in a proc format? proc format; DATE = DATE + 10800; run;

sasxii · ‎09-11-2019

so would it be DATETIME18. + hours converted to seconds?

sasxii · ‎09-11-2019

Hi there, I have a date format in DATETIME18. and would like to add three hours to it to reflect a timezone. EX. 12/31/2018 8:13:55 AM will become 12/31/2018 11:13:55 AM in the column for all the variables that fall under that column. How would you do this? At the moment I have already put my data in and it is listed as data1 with the date column being 'DATE' .

Online Status	Offline
Date Last Visited	‎10-08-2019 04:09 PM

Re: filtering by date

Re: filtering by date

filtering by date

Re: Formatting Hours - adding 3 hours to variable/date in data

Re: Formatting Hours - adding 3 hours to variable/date in data

Re: Formatting Hours - adding 3 hours to variable/date in data

Formatting Hours - adding 3 hours to variable/date in data

Re: filtering by date

Re: filtering by date

filtering by date

Re: Formatting Hours - adding 3 hours to variable/date in data

Re: Formatting Hours - adding 3 hours to variable/date in data

Re: Formatting Hours - adding 3 hours to variable/date in data

Formatting Hours - adding 3 hours to variable/date in data