About nicholasbromley

nicholasbromley · ‎04-12-2022

@Rick_SAS so the original requirement shifted slightly, wondering if it can be a slight mod to this. I am taking these index values and using them to find the value in another vector at those indecies. Now, the requirement is if there isn't an exact match, use the higher and lower value in the other vector. So for example, since 10 and 19 are not exact matches, I would average the 3rd and 4th values in the other vector. Can you please help with that?

nicholasbromley · ‎03-30-2022

I am looking to take a column off an existing dataset (Weight in the example below), do logic on it in IML and then add a new column to the existing data set (or create a new dataset with all the columns from the original and the new column). Thank you. proc iml; ds = "Sashelp.Class"; use (ds); read all var _NUM_ into X; close (ds); ...do some vector logic using Weight... ...add the new column vector back onto the original dataset... run;

nicholasbromley · ‎03-29-2022

Thank you! Hours spent on this, but alot of learning...

nicholasbromley · ‎03-29-2022

I am comparing arrays and need to take values from array A and find the index of the matching value or next lower value in array B. B is ordered if that helps the solution. So using LOC would give the the index of the exact match, but if there isn't an exact match, I want the next lower value. A = {10, 3, 19} B= {1, 3, 7, 42} Wanted Result = {3, 2, 3}

Online Status	Offline
Date Last Visited	‎04-19-2022 04:34 PM

Re: Similar to LOC, but want index of nearest lesser value

Appending new column from IML onto original dataset

Re: Similar to LOC, but want index of nearest lesser value

Similar to LOC, but want index of nearest lesser value

Re: how to count in proc report

Re: Similar to LOC, but want index of nearest lesser value

Appending new column from IML onto original dataset

Re: Similar to LOC, but want index of nearest lesser value

Similar to LOC, but want index of nearest lesser value