competition winner

Latest Activity

Profile Icon
Sukhvinder Panesar updated their profile 3 hours ago
Profile Icon

SAS Expert Channel

Thumbnail
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.
Shankar Namana joined Katharine Bean's group 3 hours ago
Profile Icon

Overview of the SAS Data Integration and Business Intelligence Applications at Online - SAS Expert Channel

Thumbnail
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 3 hours ago
Profile Icon
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…
6 hours ago
Profile Icon
ThumbnailThumbnailThumbnailThumbnailThumbnailThumbnailThumbnailThumbnailThumbnailThumbnailThumbnail
zz ding, Frank Poppe, Howard Redway and 8 more joined SAS Professionals 7 hours ago
Profile IconProfile Icon
Peter Hobart and Anthony Williams are now friends 7 hours ago
Profile Icon
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…
8 hours ago
Profile IconProfile Icon
Matt Lunn and Neil Constable are now friends 8 hours ago
Profile Icon
Sanjay Nursing updated their profile 9 hours ago
Profile Icon

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 9 hours ago
Profile Icon

SAS Professionals Convention 2012 at SAS UK

Thumbnail
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 11 hours ago
Profile IconProfile Icon
Anthony Williams and Zaid Takieddine are now friends 22 hours ago
Profile Icon

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 yesterday
Profile Icon
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
yesterday
Profile Icon
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        
yesterday
Profile Icon
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…
yesterday
Profile Icon
ThumbnailThumbnail
Stuart Woodman is now friends with Lewis Brooke and Brendan James yesterday
Profile Icon
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…
yesterday
Profile Icon
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
yesterday
Profile Icon

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 yesterday
 
 
 

Forum

Jonathan Wyatt

Sequential numbers

Started by Jonathan Wyatt. Last reply by John Anthony Galloway 6 hours ago. 2 Replies

James Godden

Infile statements

Started by James Godden. Last reply by James Godden yesterday. 2 Replies

Shankar Namana

Date Formats. Can someone explain why So.?

Started by Shankar Namana. Last reply by Mohammad Abbas on Wednesday. 8 Replies

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.

Badges  |  Report an Issue  |  Terms of Service