sas professionals convention

Latest Activity

Tom Williams and Jonathan Foster are now friends
4 hours ago
Julie Cleret updated their profile
yesterday
Terry Knight and Peter Hobart are now friends
yesterday
Rodney Jennings is now friends with Mohamed Mowafy and Rachael Boggon
yesterday
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…"
yesterday
ZIMPI DASHUA and Jason Threadgill are now friends
yesterday
sergio munoz peralta and Randeep Singh Kooner are now friends
yesterday
John Anthony Galloway and PraneethKumar sunkari are now friends
yesterday
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 ?"
yesterday
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 =…"
yesterday
Profile IconMohamed Mowafy and eva windridge joined Philip Male's group
Thumbnail

Hints and Tips

For even more hints and tips take a look at 'Tip of the Day' on SAS Community.
yesterday
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"
yesterday
Ayodeji Ayorinde is now friends with Brian Howat and stuart shaw
yesterday
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.      "
yesterday
Mohamed Mowafy updated their profile
yesterday
Profile IconShaheen Ranalvi and John Quinn joined Katharine Bean's group
Thumbnail

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.
yesterday
Damien Hustings posted a discussion

Do 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
yesterday
Tricia Aanderud posted a blog post

SAS 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
yesterday
PraneethKumar sunkari updated their profile
yesterday
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"
yesterday
 
 
 

Forum

Do Loop does not create Macro Var's

Started by Damien Hustings. Last reply by Damien Hustings yesterday. 3 Replies

Sample code required

Started by PraneethKumar sunkari. Last reply by PraneethKumar sunkari yesterday. 5 Replies

Ho to find mainframe PDS, flat file attributes using SAS code

Started by Sethuraman Vijayakumar. Last reply by John Anthony Galloway yesterday. 2 Replies

SAS Code

Started by eva windridge. Last reply by Peter Hobart on Thursday. 1 Reply

sending mail from SAS using Aliases

Started by Patrick White. Last reply by Patrick White on Tuesday. 2 Replies

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 Forum

SAS 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.

Badges  |  Report an Issue  |  Terms of Service