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: 
Di_Pat
‎07-11-2017
  • 13 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: DATE AND TIME

by Fluorite | Level 6 in SAS Programming
‎01-05-2017 04:18 PM
‎01-05-2017 04:18 PM
Thank you. This works in proc export. There was a typo in my datastep. Thank you. ... View more

Re: DATE AND TIME

by Fluorite | Level 6 in SAS Programming
‎01-05-2017 03:55 PM
‎01-05-2017 03:55 PM
marco variable is created but proc export part is not working    data _null_ ; format dt mmddyy10. tm time. ; dt = today() ; tm = timepart(datetime()) ; charval = compress(put(dt,mmddyy10.)||put(tm,time.), ":/") ; call symput("dateval",charval) ; run; %put &dateval ;     proc export data= abc  outfile='C:\Users\mno\New folder\&dateval..xlsx' dbms = xlsx replace ; putnames=no; run;   final output is generated with name as "&dateval.xlsx"  no error in log. ... View more

DATE AND TIME

by Fluorite | Level 6 in SAS Programming
‎01-05-2017 03:02 PM
‎01-05-2017 03:02 PM
I have an urgent situation. I am trying to export excel file into current date and current time.  Will be generating two files each day and final output needs to be like below.    File should be named as such [mmddyyyyhhmmss]_ABC   Please help urgently. Thank you. ... View more

Re: Pull one row if the other rows are same

by Fluorite | Level 6 in SAS Programming
‎10-10-2016 04:03 PM
‎10-10-2016 04:03 PM
Sort your table by id and course and use nodupkey option.  then drop the uncessory observations with grade = " "  ... View more

Re: Issue with the loop

by Fluorite | Level 6 in SAS Programming
‎10-10-2016 01:43 PM
‎10-10-2016 01:43 PM
Your solution is not working either. My observations are increasing. Below is the data I am looking forward too Also if holiday is on weekend, then no need to add additional day.  data have ; App Duedate 001 07/03/16 002 07/04/16 003 08/31/16 004 11/09/16 005 11/25/16 006 11/30/16 007 12/27/16 List of few holidays 05/25/15 07/04/15 05/30/16 07/04/16 09/05/16 10/10/16 11/11/16 11/24/16 12/25/16   data Want ; App Duedate Updated 001 07/03/15 07/03/15 002 07/04/15 07/05/15 003 08/31/16 08/31/16 004 11/09/16 11/09/16 005 11/25/16 11/26/16 006 11/30/16 12/01/16 007 12/27/16 12/28/16 ... View more

Re: Issue with the loop

by Fluorite | Level 6 in SAS Programming
‎10-09-2016 04:05 PM
‎10-09-2016 04:05 PM
Thanks for reply. Will try tomorrow and keep you posted. If it wont work then I will post some data to have a peek.    ... View more

Re: Issue with the loop

by Fluorite | Level 6 in SAS Programming
‎10-07-2016 02:35 PM
‎10-07-2016 02:35 PM
You are absolutely right. format was creating the issue. Thank you for sparing time and explaining in detail. I bet I would have never found it in any documentation.    New problem is -- else check_4 = check3 ; overwrites everything    I will have to write additional step to replace the missing dates. ... View more

Issue with the loop

by Fluorite | Level 6 in SAS Programming
‎10-07-2016 01:03 PM
‎10-07-2016 01:03 PM
I am running below steps and output is not generated.  Step 1) Converting Holidays into macro variable for last four years - so total 40 macro variables  Step 2) Issue lies here - in do loop, check_4 is generating missing observations for all records.    /* For holiday, I am running below link with minor twerks  http://www.sascommunity.org/wiki/Generating_Holiday_Lists */ proc sql noprint;   select count(*)   into :NObs   from holidays2;   select Day_off   into :Day_off1-:Day_off%left(&NObs)   from holidays2; quit; %put &day_off40 ;     /* check_3 is mmddyy8. format, trying to add additional day if holiday falls on check_3 or within last three days of it */ data trial4 ; set trial ; do i = &day_off1. to &day_off40. ; if check_3 - 1 = i then check_4 = check_3+1 ; else if check_3 - 2 = i then check_4 = check_3+1 ; else if check_3 - 3 = i then check_4 = check_3+1 ; else if check_3 - 0 = i then check_4 = check_3+1 ; else check_4 = check_3 ; end; format check_4 mmddyy8. ; run;     Please suggest some good do loop documents as well.  Thank you. ... View more

Re: Filling the missing dates in column

by Fluorite | Level 6 in SAS Programming
‎10-04-2016 12:46 PM
‎10-04-2016 12:46 PM
Thank you. This works.  ... View more

Re: Filling the missing dates in column

by Fluorite | Level 6 in SAS Programming
‎10-04-2016 12:45 PM
‎10-04-2016 12:45 PM
Yesterday I used your other code and solved it but it was way longer than what you have provided here.  Thank you. It works for me. ... View more

Re: Filling the missing dates in column

by Fluorite | Level 6 in SAS Programming
‎10-03-2016 06:01 PM
‎10-03-2016 06:01 PM
it does not work for me. It generates error for do loop. Thank you ... View more

Re: Filling the missing dates in column

by Fluorite | Level 6 in SAS Programming
‎10-03-2016 03:14 PM
‎10-03-2016 03:14 PM
They are two different variables. For missing dates, time can be anything. ... View more

Filling the missing dates in column

by Fluorite | Level 6 in SAS Programming
‎10-03-2016 02:50 PM
‎10-03-2016 02:50 PM
Hello, I have a dataset and need to calculate the applications through out the month they where touched and not touched and thus need to add dates on missing days. My dataset looks like below.   Actual dataset. App# Modified Time 001 09/07/16 11:03:08 001 09/08/16 12:26:15 001 09/08/16 11:04:52 001 09/12/16 09:05:10 002 09/01/16 11:03:08 002 09/02/16 12:26:15 002 09/04/16 11:04:52 002 09/09/16 09:05:10   Correct output should look like below App# Modified Time 001 09/07/16 11:03:08 001 09/08/16 12:26:15 001 09/08/16 11:04:52 001 09/09/16 01:01:01 001 09/10/16 01:01:01 001 09/11/16 01:01:01   001 09/12/16 09:05:10 002 09/01/16 11:03:08 002 09/02/16 12:26:15 002 09/03/16 01:01:01 002 09/04/16 11:04:52 002 09/05/16 01:01:01 002 09/06/16 01:01:01 002 09/07/16 01:01:01 002 09/08/16 01:01:01 002 09/09/16 11:04:52   Thank you.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-11-2017 08:58 PM
Likes given to
Quick links