About mohamed_zaki

ameey · ‎10-21-2014

Hi cynthia I applied a same code using ODS TAGSETS.MSOFFICE2K_X which is mentioned in sas support link but still sheet name is not changing. I am not understanding if this code is mentioned on sas support link then why it doest not work and unable to renaming excel report sheet name (Actually I have more then 50 reports where I have to rename excel sheet name by sas code only because by default it is not taking more then 32 character name and this is mandatory for me to use ODS TAGSETS.MSOFFICE2K_X only..please if possible then help me or guide me how can I do it. Base SAS: The MSOffice2K_x Tagset Adds Options to the MSOffice2K Tagset

BartDekeyser · ‎10-10-2014

this is it : data test; informat Birth_Date2 Admit_date1 date9.; format Birth_Date2 Admit_date1 date9.; input Admission Birth_Date2 Admit_Date1; var1 = intck('Year' , BirthDate2, Admit_Date1); if Admission = 0 and var1 > 1 then AgeAtAdmission = var1; else AgeDay = intck('day', BirthDate2, Admit_date1); drop var1; cards; 1 15apr1980 . 0 15apr1980 20jun1985 0 10jul2000 22aug2010 0 15may2010 15jun2010 ; run:

Reeza · ‎10-06-2014

SAS Global Certification program I think the pass mark was 60% though it could be 70%. Score Report You will receive an immediate pass/fail score upon completion of your exam attempt at your testing facility. The score report will display the percentage of items in each section that you answered correctly for your exam. Please note: These section scores are calculated on a per section basis and cannot be used in determining your total score. They are provided to you for descriptive purposes only. Sections: import and export raw data files manipulate and transform data combine SAS data sets create basic detail and summary reports using SAS procedures identify and correct data, syntax and programming logic errors.

akramaiya · ‎10-03-2014

Thank you very much! It worked

Community_Help · ‎04-01-2015

Hi Venkatesh - I apologize for the confusion - I realize now that my link that I posted on your status update didn't transfer over. Here is where I recommend that you post your question - otherwise I'm afraid people will not see it. Go to this page: and click "Start a Discussion" in the right navigation area. This way, SAS experts who are looking for new discussions and questions will see yours. Thank you!

mohamed_zaki · ‎09-29-2014

data want (drop=newV ); set have; by id1 id2; if (first.id2 ) then do; retain newV ' '; if STATUS = ' ' then Do ; STATUS = 'V'; newV=STATUS; End; Else if STATUS in ('C','V') then newV=STATUS; End; Else do; If STATUS in ('C','V') then newV=STATUS; Else if STATUS=' ' then STATUS=newV; end; run;

Rakeon · ‎10-03-2014

Hi , sorry for my delay in my answer.... I yes the result is what that zaki said... I used the code of hai.kuo and it works. thanks!

mohamed_zaki · ‎09-28-2014

the previous one to see the change but the final code should be like the following" data newC (drop=newV ); retain newV ' '; set new; if _n_=1 and STATUS = ' ' then Do ; STATUS = 'V'; newV=STATUS; End; Else if STATUS in ('C','V') then newV=STATUS; Else if STATUS=' ' then STATUS=newV; run;

mohamed_zaki · ‎09-27-2014

When i checked his paper i did not find any reference to the code " A Rake-Trim SAS® Macro and Its Uses at Westat ", you may want to ask him. You can find his mail at the end of the paper. Although i think it is in the property of Westat

munitech4u · ‎09-28-2014

never mind, first part was good enough to solve the problem

M_Maldonado · ‎09-29-2014

Hi Hussein, What do you mean by "type of cross-validation" in neural networks? The Start/End group nodes support cross validation for any model. For a quick example, take a look at page 7 of this paper (http://support.sas.com/resources/papers/proceedings10/123-2010.pdf)... I can't remember top of my head if you have that option in EM 6.2. If your EM version does not have cross validation option for the Start groups, I suggest go back to the basics. When I read the wikipedia definition of k-fold validation, it sounds like something easy to do in EM. Just an idea, use several Sample nodes, add the same model node to all of them, and use an Ensemble node to combine the posterior predicted probabilities. I have not ran this, but that would be my first try. Please let me know if this worked OK. Thanks! Miguel

das · ‎09-30-2014

I was unfamiliar with 'nodupkey' but it works very well. Thank you for the suggestion. Dave

SteveDenham · ‎10-14-2014

If patient id is unique, then you don't need the parenteheses (or crossed, for that matter) notation. Steve Denham

mohamed_zaki · ‎09-25-2014

If your week data set is only incremented integer you can use this also without SQL: data test1; input x y$; datalines; 23 A 23 B 24 A 24 B ; data all; set test1; do week = 1 to 5 by 1; output; end; run; proc sort data=all; by week; run;

munitech4u · ‎10-13-2014

.... I have the situation modified a little bit. I want to retain the key product combination from only if a a key is missing in particular week

Online Status	Offline
Date Last Visited	‎10-09-2023 04:22 PM

Re: Deleting Rows

Re: How to convert numeric variable to character which contains decim...

Re: How do I match IDs from multiple dataset to one dataset

Re: problem using select when

Re: Difference between row values

Re: Extract Week from first.date

Re: ERROR: Output SAS data set must be provided.

Re: Lag function help

Re: Run time error occurred in EM,while creating an ensemble of model

Re: PROC MI, FCS Logistic, WARNING: The maximum likelihood estimates f...

Re: keep variable order when using length statement to merge data sets

Re: How to read Raw data with embedded blank without increasing the sp...

Re: Pick up the date

Re: INFORMAT: How not to read (') ?

Visual Analytics Science and Technology (VAST) Challenge accepted by S...

Re: functions

Re: Filling gap in a panel data

Re: Sum Statement

Re: PROC Export: Replacing sheet error

Re: proc glm: class vs. absorb

Re: help to rename the sheet name using ods msoffice2k_x only

Re: SAS CODE

Re: SAS Certification question- Are we allowed to use pc sas /base sas...

Re: How do you add a row with values?

Re: Congratulations Rick Wicklin on recent Master Level achievement

Re: By Group -- Replace MISSING VALUES ALONG CONSECUTIVE DATES - (Repo...

Re: problem with merge

Re: By Group -- Replace a var's values based on another variables spec...

Re: rake-trim sas macro

Re: How to create rolling 1 year average value for a particular combin...

Re: Cross Validation type in Enterprise Miner

Re: Generate summary report for data imported from Access

Re: subject in repeated statement of proc mixed

Re: How to merge the data to create multiple records?

Re: how to retain combination if doesnt occur in next period?