Creating relationships... and keeping SAS users In the Know
web analytics
a2012
Top Members
Events
-
SAS Data Integration Developer for SAS9 Tutorial
May 21, 2012 from 4:30pm to 5:30pm – Online - SAS Expert Channel
0 Comments 1 Like
-
SAS Certified Platform Administration for SAS9 Tutorial
May 28, 2012 from 4:30pm to 5:30pm – Online - SAS Expert Channel
0 Comments 0 Likes
-
SAS Certified Platform Administration for SAS9 Tutorial
July 16, 2012 from 4:30pm to 5:30pm – Online - SAS Expert Channel
0 Comments 0 Likes
-
SAS Certified Advanced Programmer for SAS 9 Tutorial
July 23, 2012 from 4:30pm to 5:30pm – Online - SAS Expert Channel
0 Comments 0 Likes
Groups
-
-
SAS® Programming 1: Esse…
572 members
-
SAS® Programming 2: Data…
286 members
-
SAS® Macro Language 1: E…
250 members
sas professionals convention
Latest Activity
Damien Hustings replied to Damien Hustings's discussion Do Loop does not create Macro Var's"Thanks John and Ian for replying.
I think I have cracked it. My SQL will always create a least 1 row. I have now moved the datastep that uses the var's to within the macro and it processes fine. I was struggle to the the %global outside…"
Ian Sedgwick replied to Damien Hustings's discussion Do Loop does not create Macro Var's"Macro vars will only be created if the SQL returns rows of data. Is this the case ?"
John Anthony Galloway replied to Damien Hustings's discussion Do Loop does not create Macro Var's"I assume you are trying to create macro variables &sumt1 - &sumt12 (not macros %sumt1 - %sumt12)
They exist within the macro, but by using %global you can use them in later code.
See following ...
%MACRO Sum_fun;%DO I =…"
PraneethKumar sunkari replied to PraneethKumar sunkari's discussion Sample code required in the group SAS Expert Channel"Hi Adam,
Thanks for sharing the useful link. it helps me alot.
Regards,
Praneeth"
Adam Upton replied to PraneethKumar sunkari's discussion Sample code required in the group SAS Expert Channel"Preneeth
I did something similiar to this many years ago and used Dynamic Data Exchange (DDE). I have attached a url to a very useful document that I used when doing something similar.
"
SAS Expert Channel
The SAS Expert Channel brings expertise direct to you on-demand and via interactive live sessions. Once approved you can click on the link below to see what's available now and coming up soon and connect with an expert.
Damien Hustings posted a discussionDo Loop does not create Macro Var's
Hi - Hoping someone can help me with this bit of code :- %MACRO Sum_fun;%DO I = 1 %TO 12;proc sql ;select compress(name)into :sumt&Iseparated by ','from sashelp.vcolumnwhere libname='WORK' and memname in ('MYDATA1','MYDATA2')and name not in ('VARA','VARB')and input(trim(left(substr(name,3,2))),2.) = &I;quit;%END;%MENDSum_fun;%sum_fun; When I run the code, it appears to you and produces output. However is i run %put _user_ there are no sumt macros. If I run the same proc SQL replacing…See More
Tricia Aanderud posted a blog postSAS BI: Does Your Organization Have a BI Strategy?
One of the best things about attending the SAS Global Forum is all the brilliant people you get to meet. Guy Garrett’s presentation about planning a BI strategy was quiet popular and I have to say he was very witty. Turns out implementing a BI strategy is similar to dating – who knew? Anyway – here’s a follow up from Guy – I encourage you to sign-up for the Achieve Intelligence monthly newsletter for more goodies.What is Your BI Strategy? I recently had…See More
PraneethKumar sunkari replied to PraneethKumar sunkari's discussion Sample code required"Hi John,
It's really help me a lot.
Thanks for sharing :) have a nice day.
Regards
Praneeth"
Forum
Do Loop does not create Macro Var's
Started by Damien Hustings. Last reply by Damien Hustings yesterday. 3 Replies 0 Likes
Sample code required
Started by PraneethKumar sunkari. Last reply by PraneethKumar sunkari yesterday. 5 Replies 0 Likes
Ho to find mainframe PDS, flat file attributes using SAS code
Started by Sethuraman Vijayakumar. Last reply by John Anthony Galloway yesterday. 2 Replies 0 Likes
SAS Code
Started by eva windridge. Last reply by Peter Hobart on Thursday. 1 Reply 0 Likes
sending mail from SAS using Aliases
Started by Patrick White. Last reply by Patrick White on Tuesday. 2 Replies 0 Likes
Blog Posts
SAS BI: Does Your Organization Have a BI Strategy?
Posted by Tricia Aanderud on May 18, 2012 at 12:07 0 Comments 0 Likes
SAS Stored Processes: 3 Tips to Improve Your Prompts
Posted by Tricia Aanderud on May 16, 2012 at 12:58 0 Comments 0 Likes
SAS Global Forum: Here’s the Wrap Up!
Posted by Tricia Aanderud on May 14, 2012 at 13:45 0 Comments 0 Likes
SAS Enterprise Guide: Import the Excel Spreadsheet – Easy Peasy
Posted by Tricia Aanderud on May 10, 2012 at 17:27 0 Comments 0 Likes
SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide
Posted by Tricia Aanderud on May 7, 2012 at 12:24 0 Comments 0 Likes
Global SAS Users
Friday's Innovation Inspiration - Jenine Milum creates a report
At SAS Global Forum, one of the most difficult areas for me to show to you are the poster presentations. This year, I asked Steve Polilli, a colleague who is great with a Flipcam, to video a few for me. I picked out three that I will use in the [...]So long from SAS Global Forum 2012
Here is the last video from the last day at SAS Global Forum 2012. This one is great! Make sure you stay in there long enough to watch the outtakes: they are so funny! tags: Inside SAS Global Forum, SAS Global ForumSAS User Feedback Award Winner: Pete Lund
Annette Harris spends several minutes during this video extolling many of the high-performance virtues of Pete Lund, Information Systems Manager, Looking Glass Analytics. One thing she didn't mention (it was mentioned to me later) is that Pete is a long-time member of SAS-L. Do you know how many other SAS [...]A QUEST to learn SAS …
As a SAS fan, in a number of roles over the past 15+ years (programmer, statistician, data warehouse developer, business analyst, consultant, trainer, partner), I am also the Queensland Users Exploring SAS Technology (QUEST) chairperson, and I feel very privileged to be able to contribute to the wider SAS community [...]SESUG junior professional grants
SESUG (Southeast SAS Users Group Conference) is an annual conference held in the Southeast US - typically in September or October. This year, the conference will be held at the Sheraton Imperial Hotel and Convention Center in Durham, North Carolina, October 14-16. According to Peter Eberhardt, SESUG 2012 Academic Chair, the [...]© 2012 Created by Richard Peace.
