About ChrisBrooks

ChrisBrooks · ‎02-07-2019

There's quite a nice introduction to outliers in this paper which not only covers what they are and how they arise but gives some simple code examples to help you find them -> https://www.lexjansen.com/nesug/nesug10/ad/ad07.pdf

ChrisBrooks · ‎02-07-2019

Hi @klj81 does this not work for you? data customers10; length statename $50; input First $ Last $ City $ State $ Zip; statename=stnamel(state); datalines; Tyler Smith Upland PA 91783 Samantha Davis Montclair NJ 07163 Michael Rodriguez Metuchen NJ 08840 David Jorge Frenso CA 93650 ; run;

ChrisBrooks · ‎02-06-2019

Thanks @Cynthia_sas I'd forgotten about that except I think that was the time I mentioned when I had to clear the cache before the fixed version would work!

ChrisBrooks · ‎02-05-2019

If you've had an issue with SAS Studio in the past you may need to clear Chrome's cache before it'll work again - I had a similar issue a while ago and clearing the cache sorted it.

ChrisBrooks · ‎02-05-2019

Hi Paige - I wonder if some of your issues are caused by using Internet Explorer as I believe the recommended browser for SAS Studio is Chrome with Firefox also supported. The keyboard shortcuts for SAS Studio are listed here -> https://support.sas.com/software/products/university-edition/faq/SASStudio_keyboardshortcuts.pdf and you'll see that the shortcut for opening a Find Window is still CTRL-F and for moving to the top of a document CTRL-HOME. I'm running SAS Studio on a Mac and the Mac equivalents (CMD-F and CMD-Up Arrow) both work for me when running on Chrome. I can't claim to have been using SAS since the days of the Byzantine Empire but I do miss the Keys statement which allowed you to create your own shortcuts.....

ChrisBrooks · ‎02-01-2019

Good to hear @AMMAN I'd encourage you to pick and solution and mark it as accepted. It helps others when searching/filtering through posts.

ChrisBrooks · ‎02-01-2019

Good point @ballardw that's more succinct!

ChrisBrooks · ‎01-31-2019

Hi @Steelersgirl - I think your problem here is you're misunderstanding how the round function works. The second argument is the rounding unit and not the number of decimal places you want. You can see how this works if you look at the section titled "producing Expected Results" in. this link -> https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0tj6cmga7p8qln1ejh6ebevm0c9.htm&docsetVersion=9.4&locale=en What you want is a rounding unit of 0.001 as in the code below proc sql; SELECT name, team, round (nhits / natbat,0.001) as batavg label="Batting Average" FROM sashelp.baseball ORDER BY batavg desc; quit;

ChrisBrooks · ‎01-31-2019

Hi @AMMAN Actually the dates in your attachment aren't formatted as date9 but as mmddyy9 but the same solution should work either way. You can use a put statement with the monnmae format as shown below (I've used the first three records from your attachment data have; infile datalines dlm=","; length name $5 bday 8; informat bday mmddyy9.; format bday mmddyy9.; input name bday; datalines; Chas,5/15/1986 Pearl,3/6/1997 Troy,3/26/1999 ; run; data want; set have; justmonth=substr(strip(put(bday, monname.)),1,3); run;

ChrisBrooks · ‎01-31-2019

Hi @sasnewbiexx and welcome to the community. Do you need to use Proc SQL as a data step merge would be much simpler - automatically overwriting records with matching period_start and period_end values and inserting those which don't?

ChrisBrooks · ‎01-30-2019

Notepad++ is free -> https://notepad-plus-plus.org UltraEdit is $99.95 for a personal licence with discounts for teachers and students -> https://www.ultraedit.com

ChrisBrooks · ‎01-30-2019

It doesn't as far as I know but of course SAS programs are simply text files so you could write them in any text editor (I know many people use Notepad++ and I've used UltraEdit) and then open them in SAS Studio and run them there.

ChrisBrooks · ‎01-29-2019

It's been a little while since I used it but I think data sets created with the JSON engine are read-only. If you want to change them you either need to do as you're doing now and copy them to another library or (which I would recommend) change the JSON map

ChrisBrooks · ‎01-28-2019

Hi @GeorgeSAS - the Matplotlib library isn't available in the SAS University Edition of JupyterLab nor can you install it yourself. I understand the thinking is that saspy contains enough graphing and charting facilities for most peoples needs. If you want to see what modules are available enter the following code in a cell and run it. help('modules')

ChrisBrooks · ‎01-28-2019

The only time I ever had to look for duplicate names with possible misspellings I used the SOUNDEX function - it's not perfect and only really works with names of European origin but it might be worth a try. Once you've identified possible duplicates from that you could go on to match against race and DOB.

Online Status	Offline
Date Last Visited	‎10-08-2024 11:59 PM