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: 
deleted_user
‎09-01-2015
  • -14 Posts
  • 4 Likes Given
  • 6 Solutions
  • 131 Likes Received

Output only special characters

by in SAS Data Science
‎07-11-2015 12:16 AM
‎07-11-2015 12:16 AM
Dear Experts, Regret for posting this question in articles section. I tried to post it in discussions and every time i click post message i get a message that "Not allowed to post content more than once every 120 seconds". I waited for  a day hoping that this issue will be resolved, but its the same. So i had no option when i tried to post it here it worked. This is with regard to a scenario where i would like to output special characters alone from the string. consider that we have the following data "james ,thom,son & eligbeth ' samm" the output should have only ... View more

Re: Promoting SAS users and groups from SAS 9.2

by in Administration and Deployment
‎11-26-2014 04:07 AM
‎11-26-2014 04:07 AM
HI, Thanks for your response. We have recently migrated by using the SMU from 9.2 to 9.4, how ever we have an requirement to promote only user groups and their roles from 9.2 to 9.4. I am aware of the macros which are available and also i am ware of the fact that from 9.2 we cannot promote users and groups. SO i would like to know from experts is there any other way of doing this? Thanks ... View more

Promoting SAS users and groups from SAS 9.2

by in Administration and Deployment
‎11-25-2014 07:34 AM
‎11-25-2014 07:34 AM
Hi, Is there any better way of promoting users and groups information from sas 9.2 to 9.4? I know about the macros which are there, but is there any user friendly of doing this? Thanks ... View more

Re: re-assign values for consecutive obs

by in SAS Procedures
‎10-23-2013 12:29 PM
‎10-23-2013 12:29 PM
Haikuo, thank you very much! ... View more

Re: re-assign values for consecutive obs

by in SAS Procedures
‎10-21-2013 06:10 PM
‎10-21-2013 06:10 PM
My data only have  year 2012, no other year. Thank you! ... View more

re-assign values for consecutive obs

by in SAS Procedures
‎10-21-2013 06:01 PM
‎10-21-2013 06:01 PM
Hello, I'm a beginner of SAS. Could anyone help me out? Thank you! Here is a sample dataset. I have data with patientID, year and month. PatientID  Year Month K1234T     2012  1 K1234T     2012  2 K1234T     2012  3 K1234T     2012  8 M2350Y    2012  7 I4656Y     2012   5 I4656Y     2012   10 The final dataset I need is, in the final dataset, if a patient has consecutive month, then just keep one record and create earlist month and latest month columns (e.g. for K1234T,min_Month=1 ,max_Month=3).If not consecutive month, min_Month=max_Month=Month for this record. So the final dataset would like: PatientID  Year min_Month max_Month K1234T     2012  1          3 K1234T     2012  8          8 M2350Y     2012  7          7 I4656Y     2012  5          5 I4656Y     2012  10       10 Thank you! ... View more

Re: subset in data step

by in SAS Programming
‎06-26-2013 05:08 AM
‎06-26-2013 05:08 AM
Use If and else if instead of else and where ... View more

Re: Delimiter for Tab in SAS.

by in SAS Programming
‎06-26-2013 05:01 AM
3 Likes
‎06-26-2013 05:01 AM
3 Likes
DLM = '09'X; ... View more

Re: how to Load Row Number in SAS DI

by in SAS Programming
‎06-26-2013 04:53 AM
‎06-26-2013 04:53 AM
Try this  coalescec('Name',' ') ... View more

Re: how to Load Row Number in SAS DI

by in SAS Programming
‎06-25-2013 05:36 AM
‎06-25-2013 05:36 AM
Hi, 1. Use a user written transformation and table loader to solve the problem. use the below code in the user written transformation; data _output_; set <your source>; Row_NUM=_n_; run; 2. Connect out put of this transformation to Table loader and table loader to your output data set. Please let me know if you have any concerns. Thanks, Chakra.. ... View more

*(Satellite)*Enjoy Barcelona vs Real Zaragoza Live Online HD Video Str...

by in SAS Procedures
‎04-14-2013 02:07 PM
‎04-14-2013 02:07 PM
Watch The Masters 2013 Tournament Golf Live Stream Online HDQ Channel Broadcast. You can easily watch Live Streaming of The Masters Tournament 2013 here. 2013 The Masters Tournament Day 4 The Final Round from Augusta National Golf Club, Augusta. You are heartily welcome to watch and enjoy The Masters Golf Tournament 2013 Live and Exclusive Round 4 Day 4. Round 4 - The Final Round Click Here To Watch The Masters Tournament 2013 Live!Live!!Live!! Channel 1 Channel 2 Channel 3 [HD]   Channel 4 [MAC Users Only] Match Schedule: The Masters Golf Tournament 2013 Augusta National Golf Club, Augusta, Georgia From Thursday 11 To Sunday 14 April 2013 Sunday, April 14(Final Round) 11 a.m.-1 p.m. – Masters — On The Range: Masters.com 11:45 a.m.-6 p.m. – Amen Corner live video coverage: Masters.com 12:30 p.m.-6:30 p.m. – Hole Nos. 15 and 16: Masters.com 12:30 p.m.-7 p.m. – Featured Group 1: Masters.com; Featured Group 2: Masters.com 2 p.m. – Final Round: CBS At conclusion of tournament play: Green Jacket Ceremony: Masters.com Round 4 The Masters Tournament 2013, Day 4 The Masters Tournament 2013, masters pga 2013, masters 2013, PGA Tour, The Masters, pga golf, masters golf, Tiger Woods, lindsey vonn tiger woods, Rory McIlroy, bubba golf, golf bubba watson, bubba watson masters, pga masters 2013, pga masters ... View more

Re: Forecasting in different time intervals with Forecast Server

by in SAS Forecasting and Econometrics
‎01-23-2013 06:16 AM
1 Like
‎01-23-2013 06:16 AM
1 Like
Hi Andreas, I think you can use the tasks in EG for moving between frequencies. However, be aware that creating forecasts at the daily level and then accumulate those forecasts the monthly level will not produce the same forecasts as if you are forecasting at the monthly frequency. In order to have forecasts that are coherent at different frequencies you need some mechanism for reconciling them. This is what HPFTEMPRECON does in the frequency dimension. Thanks, Snurre ... View more

Re: Forecasting in different time intervals with Forecast Server

by in SAS Forecasting and Econometrics
‎01-22-2013 06:44 AM
‎01-22-2013 06:44 AM
Hi, First of all, I don't think the standard tasks in Enterprise Guide would help you with reconciliation as the EG time series task only allows you to move from one frequency to another. Reconciliation requires that you have data for both frequencies you want to reconcile. If you want to use point-and-click, one option could be to create a parameterized stored process setup in EG and use this to create your Forecast Server projects using the Forecast Server administrative macros followed by a stored process that does the temporal reconciliation of forecasts created in 2 separate Forecast Server projects. Thanks, Snurre ... View more

Re: Forecasting in different time intervals with Forecast Server

by in SAS Forecasting and Econometrics
‎01-21-2013 01:37 PM
3 Likes
‎01-21-2013 01:37 PM
3 Likes
Hi, In addition to Udos reply, please also bear in mind that if you use PROC HPFTEMPRECON to do temporal reconciliation, the time intervals need to be nested. So for instance reconciling day to weeks is ok but weeks to months do not work since weeks are not nested within months. Cheers, Snurre ... View more

Proc means; by statement

by in SAS Procedures
‎06-01-2011 06:46 AM
‎06-01-2011 06:46 AM
Hi All, Can someone please explain to me the proc means procedure when we have to use by statement. I can understand proc means procedure when there is no by statement. as it averages acoss all variables. But i get really confused when we have 1 or more variables mentioned in by statement. I don't get if the procedure is averaging across the variables mentioned or across variables that arent mentioned. Please help. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:02 AM
Quick links