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: 
SGB
‎09-01-2015
  • 41 Posts
  • 8 Likes Given
  • 0 Solutions
  • 16 Likes Received

Re: Question about dynamically getting the number of each weekdays(MTW...

by Obsidian | Level 7 in SAS Programming
‎12-12-2013 02:18 PM
‎12-12-2013 02:18 PM
Tom has answered this question in the other link.. Thanks a lot to Tom! https://communities.sas.com/message/190760#190760 ... View more

Re: How to create a macro to see number of sun,mon,tues to sat in each...

by Obsidian | Level 7 in SAS Programming
‎12-12-2013 02:15 PM
‎12-12-2013 02:15 PM
Thanks Tom for your time.. I think the second/above method you have proposed will solve my purpose.. Appreviate your time and help. Thanks SGB ... View more

Question about dynamically getting the number of each weekdays(MTWTFSS...

by Obsidian | Level 7 in SAS Programming
‎12-12-2013 12:07 PM
‎12-12-2013 12:07 PM
https://communities.sas.com/message/190760#190760 - Related Question and Answers from the community! My question regarding dynamically getting the number of each weekdays in all 12 months in a given year has been answered by HaiKuo, Quentin and Tom. I want to know the dates associated with those weekdays as well. I tried tweaking the existing code but it didnt work.. Year Month Day     num date 2013 Jan     Sun    4      Jan 6 2013 2013 Jan      Sun   4      Jan 13 2013 2013 Dec     Sat   4      Jan 7 2013 2013 Dec      Sat   4      Jan 14 2013 2014 Jan     Sun    4      Jan 6 2014 2014 Jan      Sun   4      Jan 13 2014 2014 Dec     Sat   4      Jan 7 2014 2014 Dec      Sat   4      Jan 14 2014 Something like this.  Appreciate your time and help in this regard. Thanks SGB ... View more

Re: How to create a macro to see number of sun,mon,tues to sat in each...

by Obsidian | Level 7 in SAS Programming
‎12-12-2013 11:22 AM
‎12-12-2013 11:22 AM
Hi Tom If I switch the output into the inner do loop I get the intended output in your code.. If I want to want to know the dates corresponding to those days along with number of MTWTHFSS in a month in a year.. How do I modify the code. Is it possible to tweak this code and get the dates.. OR do I need to follow a diff approach? Year Month Day     num date 2013 Jan     Sun    4      Jan 6 2013 2013 Jan      Sun   4      Jan 13 2013 ... 2013 Dec     Sat   4      Jan 7 2013 2013 Dec      Sat   4      Jan 14 2013 Something like this.  I will appreciate your help in this regard. Thanks Bhuvana ... View more

Re: How to create a macro to see number of sun,mon,tues to sat in each...

by Obsidian | Level 7 in SAS Programming
‎12-12-2013 11:20 AM
‎12-12-2013 11:20 AM
Hi Hai.Kuo! If I want to want to know the dates corresponding to those days along with number of MTWTHFSS in a month in a year.. How do I modify the code. Is it possible to tweak this code and get the dates.. OR do I need to follow a diff approach? Year Month Day     num date 2013 Jan     Sun    4      Jan 6 2013 2013 Jan      Sun   4      Jan 13 2013 ... 2013 Dec     Sat   4      Jan 7 2013 2013 Dec      Sat   4      Jan 14 2013 Something like this.  I will appreciate your help in this regard. Thanks Bhuvana ... View more

Re: How to create a macro to see number of sun,mon,tues to sat in each...

by Obsidian | Level 7 in SAS Programming
‎12-10-2013 05:04 PM
‎12-10-2013 05:04 PM
I was just using a data step without arrays and do loops. Tom's and Hai.kuo methods are what I consider the efficient way of programming.. ... View more

Re: How to create a macro to see number of sun,mon,tues to sat in each...

by Obsidian | Level 7 in SAS Programming
‎12-10-2013 05:03 PM
‎12-10-2013 05:03 PM
Hi I wanted to make this a dynamic code to ge the same for any given year. Also this is part of the larger stored process code.. hence was thinking to use macros.. instead of DO loops ... View more

Re: How to create a macro to see number of sun,mon,tues to sat in each...

by Obsidian | Level 7 in SAS Programming
‎12-10-2013 05:01 PM
‎12-10-2013 05:01 PM
Quentin! This is great! Never thought of doing this way!.. Thanks for your time.. ... View more

Re: How to create a macro to see number of sun,mon,tues to sat in each...

by Obsidian | Level 7 in SAS Programming
‎12-10-2013 05:00 PM
‎12-10-2013 05:00 PM
Hi Tom Thanks for your help..Your code was useful.. There might be a bug in the code to see the right output.. I will post it tomorrow.. ... View more

Re: How to create a macro to see number of sun,mon,tues to sat in each...

by Obsidian | Level 7 in SAS Programming
‎12-10-2013 04:54 PM
‎12-10-2013 04:54 PM
- This code works perfectly! Thanks! ... View more

How to create a macro to see number of sun,mon,tues to sat in each mon...

by Obsidian | Level 7 in SAS Programming
‎12-10-2013 03:24 PM
‎12-10-2013 03:24 PM
I am in the process of creating a table consisting number of Sun,Mon,Tues,Wed,Thurs,Fri,Sat in each month in 2013 and 2014. I tried something with INTNX and INTCK functions.. and I thought I would seek the help of the community members for suggestions. Any inputs is hightly appreciated. Thanks Bhuvana ... View more

Re: Streaming output from a SAS® Stored Process to Microsoft Excel

by Obsidian | Level 7 in Developers
‎02-26-2013 10:08 AM
‎02-26-2013 10:08 AM
Thank you very much Cynthia.. This definitely helps. I have one quick Q related to the example mentioned in the link.. Result looks like it’s continuing to run on the web page.  will it cause any issues in the web environment ? Thanks Bhuvana ... View more

Re: capture stored process input parameters

by Obsidian | Level 7 in Developers
‎02-20-2013 11:19 AM
3 Likes
‎02-20-2013 11:19 AM
3 Likes
Yes! I think you can store this in a dataset you can try this.. you can define a library.. 'SEEPARAM' data seeparam.input_param;      _version = "&_version ";      _username = "&_username"; run; SGB ... View more

Streaming output from a SAS® Stored Process to Microsoft Excel

by Obsidian | Level 7 in Developers
‎02-20-2013 11:08 AM
‎02-20-2013 11:08 AM
I have an output created thro PROC REPORT which I want to see as Excel report. Is it possible to do that. I have followed the steps in the following link. http://support.sas.com/kb/40/683.html The code in the above link works well but my code produces only a blank page. Can I get some suggestions on this? ... View more

Re: Passing macro variable values with special characters within sessi...

by Obsidian | Level 7 in Developers
‎09-17-2012 10:22 AM
‎09-17-2012 10:22 AM
Hi lacrefa Thanks for your reply. After posting this, I learnt that using URLENCODE is the one that I would need. Thanks again! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
Likes from
Quick links