About jl1005

jl1005 · ‎04-12-2017

Once a dataset is read in, I'd like to insert 8 rows of zeros in certain spots: tmp=insert(t2,z,4); tmp=insert(tmp,z,8); tmp=insert(tmp,z,12); tmp=insert(tmp,z,16); tmp=insert(tmp,z,20); tmp=insert(tmp,z,24); tmp=insert(tmp,z,28); t2=insert(tmp,z,32); print t2; There's probably a more efficient way to do that, but that all I'm doing, for now.

jl1005 · ‎04-11-2017

Hi, I've read over Rick's articles that describe how to loop through mutiple datasets in order to output multiple different matricies, and I think I've followed along and should be close, but my code is still throwing errors. I have data sets labeled class_01_data to class_15_data, and would like to put those into matricies titled t01 to t15. Here's what I have so far. proc iml; dsNames = {01 02 03 04 05 06 07 08 09 10 11 12 13 14 15}; do i = 01 to ncol(dsNames); ds = 'class_' + (dsNames[i]) + '_data'; *Should be the name of the input dataset; MatNames = 't01':('t'+strip(char(ncol(dsNames)))); *Want to be the name of the output matrix; use (ds); read all var _ALL_ into X; call valset(MatNames, X); close (ds); print(MatNames); end; Thank you.

jl1005 · ‎04-11-2017

Hi, I'm simply trying to read an existing dataset into a matrix, but keep recieving the same error, that I can't fix. The message is: ERROR: A dataset field name is not a valid IML symbol name. Here's the code: proc iml; use points; read all var _ALL_ into runs; close points; print runs; What's triggering the error?

jl1005 · ‎04-10-2017

Rick, that worked perfectly; thank you. I just have one more question, then I should be set. Currently our transition matrix is rectangular. Is this a valid workaround, or do we need to add rows to make it square? state = 1; /* start in state 1 */ cnt = 1; pts = 0; /* points for this game */ sentinel = 0; do while (sentinel ^= 1); newState = randfun(1, "Table", M[state,] ); /* new state */ pts = pts + points[state, newState]; cnt = cnt + 1; if (newState = 3 | newState =6) then sentinel = 1; state = newState; end;

jl1005 · ‎04-07-2017

Hi Rick, thanks for your help. I do have some experience with SAS, but am nowhere near being an expert. I do have SAS/IML and have a basic understanding of matrix operations. I think the article you linked to helped clarify a few points. The image posted was just a simplification of what we actually have. Attached is a more accurate representation of the matrix, which is actually 24 rows by 32 columns. Currently they're displaying the row cumulative percent which I think is the harder method you talk about in the article. Between your article and some more reading what we have in mind is running a loop to generate a random number to select our first end state. We would then set the end state as our next start state and repeat the process, as certain end states can only be reached from a particular start state. For a more concrete example: suppose we start at state 0_0 then transtition to 1_0. The probabilities of transitioning out of 1_0 are stored in that row. Thus we would want to generate another random number to select our end state, which then becomes our next row. Is that possible to do in both the data step or IML, or is there a better way to approach this? Thank you.

jl1005 · ‎04-06-2017

So then how would I incoroprate the results into that?

jl1005 · ‎04-05-2017

Hi, I've created a markov transition matrix that I now want to simulate. Attached should be a picture of a simplified verision of it. There's many more starting and ending states along with more results, but it's essentially just an expanded version of this. To explain, I'd like to simulate a walk through this a number of times. Each time it reaches an end state that ends with 3, it would reset back to it's starting state, 0_0. In the walk, if a certain transition hapens, then a number of points are added, as shown in the table to the right. The purpose of the walk would be to simulate a game and output the final point counts for each walk. What's the best way to have sas walk through the data as well as keep track of the results?

jl1005 · ‎04-03-2017

Hi, In my data, I have multiple rows for one person and I'd like to combine all the rows into one unique row while summing the values. For example: Where year_id and bat_id are equal, I would like to combine the rows and sum the column values. So for 2015, I would just want one row with values: 82 for G, 232 for AB, and so one. What procedure is best able to do this, or could it be done in the data step? Thank you, Justin

jl1005 · ‎03-30-2017

Here's the log: 1 The SAS System 22:47 Wednesday, March 29, 2017 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program (2)'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow (3)'; 5 %LET _CLIENTPROJECTPATH='C:\Users\jblon\Documents\My SAS Files\baseball_2.egp'; 6 %LET _CLIENTPROJECTNAME='baseball_2.egp'; 7 %LET _SASPROGRAMFILE=; 8 9 ODS _ALL_ CLOSE; 10 OPTIONS DEV=ACTIVEX; 11 GOPTIONS XPIXELS=0 YPIXELS=0; 12 FILENAME EGSR TEMP; 13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 14 STYLE=HtmlBlue 15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 16 NOGTITLE 17 NOGFOOTNOTE 18 GPATH=&sasworklocation 19 ENCODING=UTF8 20 options(rolap="on") 21 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 22 23 GOPTIONS ACCESSIBLE; 24 data all_with_weights; 25 merge sorted_all sorted_bat_weights (rename=(season=year_id)); 26 by year_id; 27 run; ERROR: BY variables are not properly sorted on data set WORK.SORTED_BAT_WEIGHTS. year_id=2015 bat_id=aardd001 G=53 AB=0 R=0 H=0 2B=0 3B=0 HR=. RBI=0 SB=0 CS=0 BB=0 SO=0 IBB=0 HBP=0 SH=0 SF=0 _NAME_=count generic_out=. strikeout=1 stolen_base=. pickoff=. wild_pitch=. walk=. intentional_walk=. interference=. error=. fielders_choice=. single=. double=. caught_stealing=. balk=. hit_by_pitch=. passed_ball=. foul_error=. triple=. other_advance=. defensive_indiff=. wOBA=0.313 wOBAScale=1.251 wBB=0.687 wHBP=0.718 w1B=0.881 w2B=1.256 w3B=1.594 wHR=2.065 runSB=0.2 runCS=-0.392 R/PA=0.113 R/W=9.421 cFIP=3.134 FIRST.year_id=1 LAST.year_id=1 _ERROR_=1 _N_=1 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 2 observations read from the data set WORK.SORTED_ALL. NOTE: There were 2 observations read from the data set WORK.SORTED_BAT_WEIGHTS. WARNING: The data set WORK.ALL_WITH_WEIGHTS may be incomplete. When this step was stopped there were 0 observations and 52 variables. WARNING: Data set WORK.ALL_WITH_WEIGHTS was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.03 seconds 28 29 GOPTIONS NOACCESSIBLE; 30 %LET _CLIENTTASKLABEL=; 31 %LET _CLIENTPROCESSFLOWNAME=; 32 %LET _CLIENTPROJECTPATH=; 33 %LET _CLIENTPROJECTNAME=; 34 %LET _SASPROGRAMFILE=; 35 36 ;*';*";*/;quit;run; 37 ODS _ALL_ CLOSE; 38 39 2 The SAS System 22:47 Wednesday, March 29, 2017 40 QUIT; RUN; 41

jl1005 · ‎03-30-2017

Isn't that what the rename is doing in the data step? It's renaming season to year_id so that they are the same variable names.

jl1005 · ‎03-30-2017

Hi everyone, I'm trying to merge two data sets together to use in creating a calculated field. Here's the code for the sorting and merging: proc sort data=all_batting out=sorted_all; by descending year_id; run; proc sort data=bat_weights out=sorted_bat_weights; where season between 1981 and 2015; by descending season; run; data all_with_weights; merge sorted_all sorted_bat_weights (rename=(season=year_id)); by year_id; run; Here's the error: ERROR: BY variables are not properly sorted on data set WORK.SORTED_BAT_WEIGHTS. Here are pictures of what each sorted data set looks like: The sorted_all table contains multiple records for each year, where as the bat_weights only has one row per year. I'm not too sure what's going wrong. Thank you, Justin

jl1005 · ‎03-30-2017

Hi everyone, So I ran a SQL query to return how many times a specific event occurred. Here's a snippet of what that table looks like: I'd like to merge this table with another table, but this one needs transposed first. I'd like to keep the year_id and bat_id as they are, but have the year_id's collapsed into one year. So combine the multiple 1999's in to one single row for 1999, for that batter. Then have the event_cd's be the new column headers and the counts fill each row, if that makes sense. The words columns are just labels for the event_cd's; it'd be nice to have those as column headings, but not neccessary. So here's what the final table structure would look like, if possible. I really appreciate the help, Justin

jl1005 · ‎03-27-2017

The first code you posted worked perfectly, thank you. It's much more efficient than what I had come up with.

jl1005 · ‎03-27-2017

Hi, Essentially I wanted to results I had posted above in a picture to be stored exactly as is, or at least very close to that in a SAS data set. Does that clear it up?

jl1005 · ‎03-26-2017

Okay, so taking everyones advice, here what the code ended up looking like: proc freq data = events_limited; tables start_bases_cd*end_bases_cd / out=transition outpct nopercent nocol nofreq; Title 'Transitions'; run; proc transpose data = transition out=transition_1; by start_bases_cd; id end_bases_cd; var pct_row; run; proc stdize data = transition_1 out = transition_2 reponly missing=0; proc sql; create table transition_3 AS select start_bases_cd, ' 0'n/100 as end_0 format D6.4, ' 1'n/100 as end_1 format D6.4, ' 2'n/100 as end_2 format D6.4, ' 3'n/100 as end_3 format D6.4 , ' 4'n/100 as end_4 format D6.4, ' 5'n/100 as end_5 format D6.4, ' 6'n/100 as end_6 format D6.4, ' 7'n/100 as end_7 format D6.4 from transition_2 ; quit; The stdize was to insert 0's where the field was blank and the sql was to force the columns back in order. In regards to formatting and renaming the columns, is there a more efficient way to accomplish this? Also, in one field only theres a number written as scientific notation. Is there an easy way to force that to round to 0?

Online Status	Offline
Date Last Visited	‎10-23-2018 04:53 PM

Re: Inverse, Divide by 0 Workaround

Inverse, Divide by 0 Workaround

Re: Access Macro Variable Created From Loop

Re: Access Macro Variable Created From Loop

Access Macro Variable Created From Loop

Re: Conditional Ranking

Conditional Ranking

Using Loop Index in Name

Overlay Square in Heatmap

Re: Applying Scalar, and Inverse Scalar

Re: Conditional Ranking

Re: Conditional Ranking

Re: Using Loop Index in Name

Re: Applying Scalar, and Inverse Scalar

Re: Applying Scalar, and Inverse Scalar

Simulating random walk with actions

Re: IML Loop through Table Names

IML Loop through Table Names

Error, IML Symbol Name

Re: Simulating random walk with actions

Re: Simulating random walk with actions

Re: Simulating random walk with actions

Simulating random walk with actions

Adding/Merging Rows

Re: Merging with Many to Few

Re: Merging with Many to Few

Merging with Many to Few

Transposing with Multiple Years

Re: Proc Freq Results as Data Table

Re: Proc Freq Results as Data Table

Re: Proc Freq Results as Data Table