About Ron_Cody

Ron_Cody · ‎09-28-2021

Hi. I see you are using the RANUNI function. Take a look at the RAND function that replaces EVERY previous random function. You set the seed with "Call Streaminit(seed);" and to get uniform random numbers, you use "Variable = rand('Uniform');". The beauty of this function is that by changing the first argument you can generate normal, Bernoulli, Poisson, etc. You can also set a mean and standard deviation for normal distributions. Take a look. I think you will like this function. SAS recommends it and says it generates "better" random strings.

Ron_Cody · ‎08-21-2021

Hi. I am assuming you have access to SAS. If not, I strongly recommend SAS OnDemand for Academics. It is a free cloud based platform for people wanting to learn SAS. You don't have to download any software and the interface is called SAS Studio. Please check out my SAS author web site to see my SAS books. In particular, check out Learning SAS by Example, 2nd edition or a more recent book, Getting Started with SAS Programming Using SAS Studio in the Cloud. You can access my author web site at support.sas.com/Cody. Also feel free to email me at Ron.Cody@gmail.com

Ron_Cody · ‎08-19-2021

Hi. I didn't notice the specification that the last character in the string had to be 'A', so I modified my solution: data Test; length String $ 11; input String; if findc(String,'A',lengthn(String)-1) then substr(String,11,1) = '0'; datalines; SGJ604-01-A XXX999-090B AFD345-03-A ; title "Listing of Test"; proc print data=Test; run; The last argument in the FINDC function is a starting position. The LENGTHN function is the same as the older LENGTH function--it returns the length of a string, not counting trailing blanks. The 'N' version returns a 0 when the first argument is a missing value; the non 'N' (older function) returns a 1 in this situation. I recommend always using LENGTHN. Hope this helps and clarifies.

Ron_Cody · ‎08-18-2021

Hi. Glad to hear you have read some of my books. I like simple coding, that %syseval is too complicated for me! I have two new books using SAS Studio with OnDemand for Academics. I have become a huge fan of OnDemand and Studio. Best, Ron

Ron_Cody · ‎08-18-2021

Hi. Try this: data Test; informat String $10.; input String; Position = findc(String,'/'); if Position then do; put _all_; Numerator = substr(String,1,Position-1); Denominator = substr(String,Position+1); Number = input (Numerator,10.) / input(Denominator,10.); end; else number = input(String,10.); datalines; 1/3 2/5 8 ; title "Listing of Test"; proc print data=Test; run; Please check out support.sas.com/Cody to see some of my SAS programming books.

Ron_Cody · ‎08-18-2021

Here is a really interesting solution that uses the SUBSTR function on the LEFT side of the = sign. I assume you mean the digit 0 (character) for the last position. Here it is: data Test; length String $ 11; input String; substr(String,11,1) = '0'; datalines; SGJ604-01-A AFD345-03-A ; title "Listing of Test"; proc print data=Test; run; Hope this helps, Ron

Ron_Cody · ‎08-13-2021

Hi. I just wrote a blog on transitioning fro UE to OnDemand Here is the link: https://blogs.sas.com/content/sgf/2021/08/03/migrating-from-sas-university-edition-to-sas-ondemand-for-academics/ my email is ron.cody@gmail.com if you want to contact me. I have just published two books using ODA (Getting Started with SAS Programming Using SAS Studio in the Cloud and A Gentle Introduction to Statistics Using SAS Studio in the Cloud. Ron

Ron_Cody · ‎08-13-2021

I might suggest "Learning SAS by Example, 2nd edition" or Getting Started with SAS Programming Using SAS Studio in the Cloud. Both by me (Ron Cody) Just go to support.sas.com/cody or enter "Ron Cody" in Amazon search. You will see examples similar to your question

Ron_Cody · ‎08-13-2021

Hi. Is Age a character or numeric variable? You don't want to use AND because Age can never be equal to two different values. If Age were numeric I would suggest something like: If missing(Age) then Age_Grp = ' '; else if Age le 4 then Age_Grp = '0 to 4'; else if Age le 8 then Age_Grp = '4 to 8'; I don't know if you want lt or le, it is up to you

Ron_Cody · ‎03-28-2018

I've been told my Functions talk will be recorded. But, I'd rather see you in person!

Ron_Cody · ‎03-19-2018

Hi Stephen. Nice to hear from you. I would try an get involved in volunteering in the conference. That way, you get to meet more people. I hope you stop by my talk or Monday night at the Publication booth and say hello. Best, Ron

Ron_Cody · ‎03-15-2018

Great, see you there. I have some new vacation pictures!

Ron_Cody · ‎03-15-2018

I know Jan will be GEOCACHING!

Ron_Cody · ‎02-28-2018

Hi. Here is the solution I used in the answers to the even numbered problems (available to teachers or self-learners who make a request to SAS). data markup; input manuf : $10. Markup; datalines; Cannondale 1.05 Trek 1.07 ; proc sort data=learn.bicycles out=bicycles; by Manuf; run; data markup_prices; merge bicycles markup; by Manuf; NewTotal = TotalSales*Markup; format NewTotal dollar10.; run; title "Listing of MARKUP_PRICES"; proc print data=markup_prices noobs; run; By the way, I have just finished the second edition of the Learning SAS by Example book and the technical edits are due today. I hope you will take a look at it. All of the programs are up to date with the changes in SAS since the first edition was written. The chapter on SAS Graph was replaced with one on PROC SGPLOT and a new chapter covering regular expressions was added. Best, Ron Cody

Online Status	Offline
Date Last Visited	‎08-23-2023 05:08 PM

Re: If-Then is not working

Re: [Q] How did you learn the programming skills (like SAS, SQL, R) to...

Re: change the last digit alphabet A to the number 0

Re: Character expression conversion to numeric result

Re: Character expression conversion to numeric result

Re: change the last digit alphabet A to the number 0

Re: Welcome to the SAS Software for Learning Community!

Re: what is wrong with this code

Re: what is wrong with this code

Re: SAS Global Forum 2018 takeout?

Re: If-Then is not working

Re: Welcome to the SAS Software for Learning Community!

Re: what is wrong with this code

Re: Any tips for a first time GF attendee?

Re: Are you going to SAS Global Forum in Denver? I'm presenting there!

Re: What to do in Denver?

Re: If-Then is not working

Re: [Q] How did you learn the programming skills (like SAS, SQL, R) to...

Re: change the last digit alphabet A to the number 0

Re: Character expression conversion to numeric result

Re: Character expression conversion to numeric result

Re: change the last digit alphabet A to the number 0

Re: Welcome to the SAS Software for Learning Community!

Re: what is wrong with this code

Re: what is wrong with this code

Re: SAS Global Forum 2018 takeout?

Re: Any tips for a first time GF attendee?

Re: Are you going to SAS Global Forum in Denver? I'm presenting there!

Re: What to do in Denver?

Re: What approach to use in this problem?

SAS Global Forum 2018