cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lic054
‎11-28-2016
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: calculate difference of two dates in different format

by Calcite | Level 5 in SAS Programming
‎10-03-2016 09:07 PM
‎10-03-2016 09:07 PM
Thank you all for the reply.   I used some similar codes (see below) which work fine for the cases when B29,B29_B,B29_C are all non-missing. However, when only year is available (case 1), or only year and month are available (case 2), the codes will just skip these and do not calculate the difference in days. My goal actually is to classify the difference in days into 2 groups (Yes and No): Yes for 0 =< diffdays <=30 No for diffdays >30 So I modified the codes by adding the lines in bold to find the difference in year, but that will not resolve the whole issue for both cases, and needs to be further investigated.    Also, if I just want to do a count for Case 1 (the cases when only year is available), and also a count for Case 2 (the cases when only year and month are available), how do I do that? proc freq, table, where=? Based on the counts/frequency, we can access and decide how to treat the cases with the missing days/months.    Thank you!     data want;     set Revised2015;   if f_B29 <0 then f_B29n = . ;       else f_B29n = f_B29 ;       *format f_B29n f_B29n. ;     label f_B29n = "Month";   if f_B29_B <0 then f_B29_Bn = . ;       else f_B29_Bn = f_B29_B ;       *format f_B29_Bn f_B29_Bn. ;     label f_B29_Bn = "Day";   if f_B29_C <0 then f_B29_Cn = . ;       else f_B29_Cn = f_B29_C ;       *format f_B29_Cn f_B29_Cn. ;     label f_B29_Cn = "Year";     f_date=mdy(f_B29n,f_B29_Bn,f_B29_Cn);     f_enddaten=input(f_enddate, yymmdd8.);     format f_enddaten f_date mmddyy10.;         f_diffdays=intck('days',f_date,f_enddaten);     f_diffyears= year(f_enddaten)- f_B29_Cn;     if f_diffdays <0 then f_diffdaysn = .;     else if 0 <= f_diffdays <= 30 then f_diffdaysn = 1;     else if f_diffdays >30 then f_diffdaysn = 2;     label f_diffdaysn = "Last smoked or had a puff on a cigarette within the past 30 days" ;     format f_diffdaysn YN.;  run; ... View more

calculate difference of two dates in different format

by Calcite | Level 5 in SAS Programming
‎09-28-2016 07:45 PM
‎09-28-2016 07:45 PM
I need to calculate difference of two dates in different format.    At time point 1 (earlier date) has 3 variables "B29" for month, of type "Number", Length 8, Format Best12., Informat F12., which shows value in the form of "1" through "12", representing month: January through December.  "B29_B" for day, of type "Number", Length 8, Format Best12., Informat F12., which shows value in the form of "1" through "31", representing days.  "B29_C" for year,  of type "Number", Length 8, Format Best12., Informat F12., which shows value in the form of "1990" through "2016", representing years.    At time point 2 (later date)  has just 1 variable "ENDDATE", type "Text", Length 48, Format $F48., Informat $48., which shows value in the form of "20160125", for example.     Question 1 So to combine the 3 variables at time point 1 to be 1 variable in the same form of the variable "ENDDATE", which SAS function should be the best? Or should they (both time point 1 and time point 2 variables) be both converted to a third format?  Will the codes below be good? Or needs to be modified or changed to a better approach?    data want;     set have;     date=input(catx("",month,day,year),mmddyy10.);     format date mmddyy10.; run;   Question 2 To calculate difference of two columns of dates after conversion in the same format, which SAS function should be the best? I found DATDIF and INTCK, but don't know which or if there's a better way to proceed, based on the ideal date format to be chosen in my question 1 above.  If I try to adapt the codes below, should the changes be just the variable names?   data _null_; sdate="12mar1998"d; edate="12jun2008"d; days=intck(‘days’,sdate,edate); put days; run;   data _null_; sdate="12mar1998"d; edate="12jun2008"d; days=datdif(sdate,edate,'act/act'); put days; run;   Thanks! ... View more

missing rows in table generated by running a macro

by Calcite | Level 5 in SAS Programming
‎08-31-2016 10:05 PM
‎08-31-2016 10:05 PM
Has anyone seen before such error message in the log below (I highlighted it)? What's the cause of the problem and how can I fix that? The results table in rtf file I got from running macros ended up missing some rows of certain categories. Do I need to include the macros here as well? It's a long file of codes to call the macro at the end. Thanks!     NOTE: There were 17 observations read from the data set WORK.TB. NOTE: The data set WORK.TB has 17 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Writing RTF Body file: C:\Users\LQL\Desktop\Lixian\CSC\2015\output\successfulquitters_vs_stillsmoking_QuitHelpLChen 08312016.rtf NOTE: Groups are not created because the usage of DEMO is DISPLAY. To avoid this note, change all GROUP variables to ORDER variables. ERROR: The width of DEMO is not between 1 and 128. Adjust the column width or line size. NOTE: This affects LISTING output. ... View more

Re: saved a sas file created in SAS in desktop C drive but it can't be...

by Calcite | Level 5 in SAS Programming
‎08-31-2016 04:13 PM
‎08-31-2016 04:13 PM
Here is the log related to the codes I previous posted. These codes are at the end of a longer SAS file. Also, there are some comments in my codes. It seems that the new file psrai_merged_noIDnew is created, but don't know why it can't be opened in SAS. If it's an issue of OS, how can I fix that? Thanks!   8575 libname library "C:\CTS - backup - Aug16_2016\CSC\2011\data\share" ; NOTE: Libref LIBRARY refers to the same physical library as TMP1. NOTE: Libref LIBRARY was successfully assigned as follows: Engine: V9 Physical Name: C:\CTS - backup - Aug16_2016\CSC\2011\data\Share 8576 8577 *export SAS format - not being able to open sas file generated - have to figure out if it's 8577! sas versin or what 8578 can try to generate the SAS file correctly by opening SAS, importing the CSV and then saving 8578! it some other way; 8579 data library.psrai_merged_noIDnew; 8580 set to_share2; 8581 run; NOTE: There were 1000 observations read from the data set WORK.TO_SHARE2. NOTE: The data set LIBRARY.PSRAI_MERGED_NOIDNEW has 1000 observations and 727 variables. NOTE: DATA statement used (Total process time): real time 0.54 seconds cpu time 0.51 seconds     ... View more

saved a sas file created in SAS in desktop C drive but it can't be ope...

by Calcite | Level 5 in SAS Programming
‎08-29-2016 06:21 PM
‎08-29-2016 06:21 PM
  Hi there,    Using the following code, the file psrai_merged_noidnew.sas7bdat created can not be opened in SAS 9.4  Can anyone tell if it's a problem of the codes below, or other issues? How can the codes be modified if so? The data set to_share2 works fine in SAS.    libname library "C:\CTS - backup - Aug16_2016\CSC\2011\data\share" ; data library.psrai_merged_noIDnew;   set to_share2;  run;   Thanks! Li ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-28-2016 05:46 PM
Quick links