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.
Creating relationships... and keeping SAS users In the Know
advanced analytics training
Top Members
Events
-
SAS Certified Advanced Programmer for SAS 9 Tutorial
February 6, 2012 from 4:30pm to 5:30pm – Online - SAS Expert Channel
0 Comments 0 Likes
-
SAS Certified Base Programmer for SAS9 Tutorial
February 13, 2012 from 4:30pm to 5:30pm – Online - SAS Expert Channel
0 Comments 0 Likes
Groups
-
SAS® Programming 1: Esse…
539 members
-
-
SAS® Programming 2: Data…
239 members
-
-
-
SAS® Macro Language 1: E…
197 members
competition winner
Latest Activity
Sukhvinder Panesar updated their profile
Overview of the SAS Data Integration and Business Intelligence Applications at Online - SAS Expert Channel
February 2, 2012 from 4:30pm to 5:30pm
This series provides a comprehensive introduction to the Platform for Business Analytics applications. Starting with an overview of how everything fits together before going through each element in turn from the SAS Management Console through to the SAS business visualisation capabilities.There are 11 episodes in this series:Episode 1 - “Introduction”Episode 2 – “Overview of the SAS Management Console”Episode 3 – “Using SAS Data Integration Studio”Episode 4 – “Using SAS OLAP Cube Studio”Episode…See More
Shankar Namana is attending SAS Professionals Administrator's event
John Anthony Galloway replied to Jonathan Wyatt's discussion 'Sequential numbers'
Jon
I no longer have access to EG but the simplest method is to make use of _N_ and create a variable
newvar=15602315 + _N_ ;
If _N_ is not available for any reason then you can use two lines of code;
retain…
Mohammad Abbas replied to Jonathan Wyatt's discussion 'Sequential numbers'
you would need to generate your sequential numbers in a separate SAS table and merge the table with your original dataset.
Data temp; input ID val;
Datalines;
1 10
2 10
3 10
4 10
5 10
. 10
. 10
. 10
. 10
. 10
;
run;
/* create a table containing…
Sanjay Nursing updated their profile
Sequential numbers
Hi everyone,On Enterprise Guide i am trying to add a computed column to a data set which will give me sequential numbers but starting from a specified number.I would need my sequential numbers to start from 15602315 and carry on for the rest of the data (so 15602316, 15602317, 15601318 etc)Could anybody suggest a way which i could do this using EG.Many thanksJonSee More
Discussion posted by Jonathan Wyatt
SAS Professionals Convention 2012 at SAS UK
July 10, 2012 to July 12, 2012
The 2012 convention will be held in Marlow. RSVP if you want to be on our 'first to hear' list. You may recall that we sold out of certification tickets in 2011.
Jethro Day might attend SAS Professionals Convention's event
My SAS Experience
For many undergraduates in their second and final years (more so the latter) one of the big questions you’ll be pondering is ‘What now?’. It seems that your studies are coming to an end, perhaps sooner than you thought? What little you remember of your first year as a student might be hazy and far removed from the worry about burning up on entry (or re-entry in my case) into the real world. However, there might be one employer you hadn’t considered who could change your perception of ‘working…See More
Blog post by Matthew Potts
Shankar Namana replied to Shankar Namana's discussion 'what is the format for the missing date-time character values?'
Thank you both Hobart & Crawford.
The usage of the ? modifier helps me out to run the program well without any error in log windows.
Thanks
James Godden replied to James Godden's discussion 'Infile statements'
Hi Peter,
That seems to have done it after a proc sort. I agree two easy statements are much better than one complicated one.
Thanks for your help!
James
Peter Crawford replied to Shankar Namana's discussion 'what is the format for the missing date-time character values?'
if the data are as they appear above
> no data have embedded blanks
> and values are separated by no more than one blank
> . appears for missing numeric or character fields
then just use infile statement…
Peter Crawford replied to James Godden's discussion 'Infile statements'
I would keep the data as your input statement has it.
Then you have no complexity.
Reporting by registration or option will continue to be straightforward.
To create a new table holding reg, #optns, sum_op_meas could be just like
data reg_sum_data…
Peter Crawford replied to Philip Male's discussion 'Export to Excel 2010 just got a little bit easier' in the group Hints and Tips
good pointer!
From Chris' blog area I picked up the system option viewer addin for EG and as well as requesting/installing the (December2011) maintenance release for SAS9.3
peter
Infile statements
Hi all, I have a file on cars which contains registration (vehicle registration plate), _option_description_(description of option, such as leather seats, aircon etc.) and total__measure_ (price per option). I am upto the point where I can use an infile statement to transfer the data into sas. data car_extras;infile car(infile_car_options.txt) dsd;input registration $ $ _option_description_ & $51. total__measure_ ;run; The format of the raw data is one row per option. So if a car had 5…See More
Discussion posted by James Godden
Forum
Sequential numbers
Started by Jonathan Wyatt. Last reply by John Anthony Galloway 6 hours ago. 2 Replies 0 Likes
what is the format for the missing date-time character values?
Started by Shankar Namana. Last reply by Shankar Namana yesterday. 13 Replies 0 Likes
Infile statements
Started by James Godden. Last reply by James Godden yesterday. 2 Replies 0 Likes
Date Formats. Can someone explain why So.?
Started by Shankar Namana. Last reply by Mohammad Abbas on Wednesday. 8 Replies 0 Likes
Blog Posts
My SAS Experience
Posted by Matthew Potts on January 26, 2012 at 7:42pm 0 Comments 0 Likes
SAS achieves double-digit growth, rockets 12 percent to record $2.725 billion
Posted by Ann Morgan on January 19, 2012 at 5:48pm 0 Comments 1 Like
Business Intelligence Strategy Consultancy
Posted by Guy Garrett on January 18, 2012 at 8:00pm 0 Comments 0 Likes
Data Scientists needed !
Posted by Geoffrey Taylor on January 18, 2012 at 11:03am 1 Comment 0 Likes
Blog Posts for December 2011
Posted by Andrew Ratcliffe on January 18, 2012 at 9:00am 0 Comments 0 Likes
Global SAS Users
Friday's Innovation Inspiration - Surface complexation modeling
What is surface complexation? Everyday I have to look something up on Google or in the dictionary. For example, do you know what a Cthulhu is? I had to search for that term after I tweeted that I thought a SAS surface plot graph was beautiful. Mike Nemecek from SAS [...]Unofficial Official Guide to SAS Global Forum
SAS Global Forum 2012 is just around the corner, and even those who have attended for the past 36 years need guidance in what to do and see. I thought it might be good to create a little users guide for the event: A blog series that will showcase some [...]Friday's Innovation Inspiration - Data miners slow churn
Churn is a huge concern for insurers, credit card providers and telecommunications companies - even utilities. This Post-It Note author says that his company has found a way to reduce customer turnover - churn - by 10 percent using SAS Data Miner. In fact, there are many ways - using SAS - [...]It’s YOU not me!
Sadly, SAS did not three-peat as the No. 1 Best Company to Work For on Fortune’s famous list, but from my point of view, SAS will always be No. 1. It’s not the Healthcare Center or the Pharmacy on campus. It’s not the daycare or the four cafés, also on [...]SAS users collaborating, improving SAS®
As many of you know, I'm also the Editor of the SAS Tech Report. For those who don't know what that is, the SAS Tech Report is a free newsletter published once a month and sent straight to your email inbox. I gather SAS papers, tips and practical information about [...]© 2012 Created by Richard Peace.
