About cov_derek

HowardNewstadt · ‎10-31-2016

I'm finding that this method does not account for days difference greater than 365, e.g., June 1, 2014 to May 31, 2016.

dgammon · ‎06-10-2016

This worked for me when I had to datetime variables(date1 & date2) and wanted the differnce between dates in days /* data test; set test; by subj; days=intck('dtday', date1, date2); put days=; run; */

cov_derek · ‎06-26-2015

Ujjawal, Is your date really a character variable? If so, I would urge you to convert it into a SAS date value first. If your date is stored as a SAS date value, RW9's solution won't work without additional coding. If it is a character value, then you won't be able to do any calulations with it without code to do that transformation to a SAS date value. Xia's solution is the easiest way of dealing with the fact that SAS does not have every possible date format available. Only change I would make is I would use a more descriptive format name than "fmt". IMHO, there is no reason to represent a date as a character variable in a SAS table or view, UNLESS you are dealing with complex ISO8601 dates and need to calculate ISO durations and intervals using CALL IS8601_CONVERT. Derek

Loko · ‎09-30-2014

Hello, A proc sql solution: data have; infile datalines truncover; input id Name $ date ddmmyy10.; format date ddmmyy10.; datalines; 11 john 12/04/2014 22 Matt 26 miac 22/01/2013 ; proc sql; create table want as select *, case when date is missing or date ge '15May2014'd then 0 else 1 end as indicator from have; quit;

Ksharp · ‎08-01-2014

NULL, Don't forget function nwkdom( ) . data friday; do year=2001 to 2013; do month = 1 to 12; date=nwkdom(5,6,month,year); output; end; end; format date weekdate.; run; Xia Keshan

cov_derek · ‎07-24-2014

Krishna, I would use a colon (:) modifier on the ddmmyy10. informat instead of changing the informat length. data g; infile 'e:\test\File4.txt'; format dob date9.; run; The colon basically allows SAS to stop processing as soon as it hits the space in position 10, and translate the string of 9 characters instead of expecting all 10. The problem with the simple solution of changing the format length is that if you have a date longer than that like 14/10/2014, only reading 9 characters will give you incorrect results. Hope this helps your understanding, Derek

cov_derek · ‎02-13-2014

Thank you, Cynthia. Hope y'all are safe and warm.

LinusH · ‎09-06-2013

We could also mention the possibility to override the default SAS/ACCESS data type mapping. When reading from the source DB, you can use the DBSASTYPE data set option: SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Second Edition And for out processing (create/alter table) DBTYPE: SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Second Edition The a bit annoying thing about these is that you can't set a default mapping schema per data type, you must specify it for each column.

cov_derek · ‎05-03-2013

Hi Paul, Sorry for the delay, but I got busy at Global Forum. Here's a code snippet for you in case you haven't solved your problem: chkval = LAG(permhearingdate); IF chkval NE . and chkval GT 213 and permhearingdate NE . THEN permhearingdate = chkval + 213; You mentioned prevdate above, but I wasn't sure if that is an actual variable or the lag of the permhearingdate, so it's not in the IF statement. All SAS keywords are in caps, and I prefer using comparison keywords instead of symbols for comparison operators. Hope this helps.

cov_derek · ‎02-22-2013

Well that would certainly explain it. Guess I would have to add any background to the RTF file in Word.

data_null__ · ‎05-17-2011

[pre] data cntl; retain fmtname 'b' type 'I' hlo ' '; start = 'A'; label = '1 '; output; start = ' '; label = '_ERROR_'; hlo = 'O'; output; run; proc format cntlin=cntl; run; data _null_; y = input('X',b.); put _all_; run; [pre] Message was edited by: data _null_;

Online Status	Offline
Date Last Visited	‎02-06-2017 01:02 PM

Re: Change date format

Re: Help SAS date code to distinguish dates and blanks

Re: Create table showing last friday of month

Re: how to select the attendance for a month?

Re: How to calculate difference in days between two dates (given in SA...

Re: Proc Expand

Re: How to read date from a txt file?

Re: Finding No of Days between two dates in SAS VA

Re: How to calculate difference in days between two dates (given in SA...

Re: text justification with in-line formatting in PDF

Re: Change date format

Re: Help SAS date code to distinguish dates and blanks

Re: How to calculate difference in days between two dates (given in SA...

Re: Finding No of Days between two dates in SAS VA

Re: How to calculate difference in days between two dates (given in SA...

Re: Change date format

Re: Help SAS date code to distinguish dates and blanks

Re: Create table showing last friday of month

Re: How to read date from a txt file?

Re: text justification with in-line formatting in PDF

Re: Date format when importing via ODBC

Re: Add a certain number of days onto a date

Re: I am having a problem getting my background image to show in RTF o...

Re: Other = _ERROR_