About NKormanik

NKormanik · ‎07-02-2016

Please see the following data set: Bob Paul 120 Tina Adele 111 Scott Joe 100 Betty Trish 97 Mark Adam 95 Three columns: Name#1, Name#2, Score. I would like to join the columns to produce the following: Bob 120 Paul 120 Tina 111 Adele 111 Scott 100 Joe 100 Betty 97 Trish 97 Mark 95 Adam 95 Two columns: Name#1 OR Name#2, Score How can this be done efficiently? Any help greatly appreciated. Thanks! Nicholas Kormanik

NKormanik · ‎07-02-2016

Example, please? All Greek to me.... Thanks!

NKormanik · ‎07-02-2016

Data is sorted in descending order (second column), over 100,000 rows. _X _50501 _22001_1 1.51880 _23005_1 1.15927 _23403_1 1.12800 _23401_1 1.12679 _20104_1 1.09546 _20104_1 1.08488 _20204_0 1.06033 _21105_0 1.05820 _21506_0 1.05118 _21801a_0 1.04543 _20104_1 1.04470 I would like to use Proc Freq on just the first xxx rows. How can I do that? Create a new data set (subset)? Use a particular IF or WHERE statement? My objective is to get a 'tally' for the first column, but only the top so many. My preference would be to use the following: -- top 1% -- top 2% -- top 5% -- top 10% -- etc. Is this somehow possible? Help greatly appreciated. Nicholas Kormanik

NKormanik · ‎06-30-2016

Here is the actual code I used. Changing ONLY the first three lines. Leaving alone all the rest: data nicholas.slope; set nicholas.test; array ys(6) _50501 _50502 _50503 _50504 _50505 _50508; array vals(6) (1 2 3 4 5 8); xbar = mean(of vals(*)); ybar = mean(of ys(*)); do i=1 to dim(vals); s_xy=sum(s_xy, i*ys(i)); s_y=sum(s_y, ys(i)); s_x2=sum(s_x2, vals(i)**2); num=(vals(i)-xbar)*(ys(i)-ybar); den=(vals(i)-xbar)**2; num_tot=sum(num, num_tot); den_tot=sum(den, den_tot); end; s_x=sum(of vals(*)); n=dim(vals); slope = (n*s_xy - s_x*s_y)/(n*s_x2 - s_x**2); slope2 = num_tot/den_tot; run;

NKormanik · ‎06-30-2016

How about THAT! I used the code in your "Spoiler Allert" and it came up with the same values that Excel came up with. Soooo..., you did it. "Slope2" was the column with the same answers. Not sure what "Slope" column was, or many of the other columns you created. Before I mark this question as completed, do you want to explain anything further, or make any final changes? Thank you very, very much Reeza.

NKormanik · ‎06-30-2016

"If you have a SAS/IML license I'm sure it's much easier in SAS IML." Not sure is SAS/IML is available here. Assuming that it is, would you, or someone, please post code which might work to get the slopes of the rows? Thanks!

NKormanik · ‎06-29-2016

"You could probably combine functions to do a linear regression across a row without too much difficulty, I think all of the functions are there." Would you please help me get started with that? All I really need is the slope for each series of numbers in the row. _1 _2 _3 _4 _5 _8 -0.069965723 0.492749371 0.955245597 1.346963522 1.701118239 2.523141195 I have thousands of such rows where the slope is needed. Any help would be greatly appreciated. A new column following the series should contain the slope value for that particular series. Nicholas

NKormanik · ‎06-22-2016

Thank you Astounding and Reeza. So glad I asked, and you were so available. I tried experimenting with other formats, but failed. Great to have the answer. Nicholas

NKormanik · ‎06-21-2016

Some of the websites out there talk of using the "most efficient" form for writing a program. Please take a look at the following: data SASData__N (keep = Combo_Plus i1_X i2_X Label1 nValue1 Label2 nValue2); set Moments_Combined (where = (Label1='N')); run; I was very glad to simply get the above program to run. Does it look "efficient" enough? Should I attempt to try some other route? Thanks! Nicholas Kormanik

NKormanik · ‎06-12-2016

Maybe have to do that. Was hoping for some SAS procedure that will project out with data staying as is in row.

NKormanik · ‎06-12-2016

Data lie in a row, not a column. In SAS dataset. From SAS output. Would prefer to use SAS, if possible. Assume series 1, 2, 3, 4, 5, in single row, across. What comes next? 6, of course. What if data are more messy? How to project that?? Somewhat like a time series problem. Project out one additional value. Prefer answer be in same row as data. Just to the right, in it's own column. Willing to use another program, such as Excel, if SAS can't do it. Any help appreciated. Nicholas

NKormanik · ‎06-11-2016

Because of the apparent complexity (for me, that is) I'm wondering if we could just take the one-row case. Here is the first row, y: -1.6264 -0.2521 1.2354 1.2354 2.148 2.148 The x, then, is 1, 2, 3, 4, 5, 8 I'm hoping the code to do the transformation and regression will be more understandable. Another related question: Is there another SAS procedure that will provide a 'forecast' to a succeeding value. Say, for instance, if x=10? Thanks to all here for the assistance.

NKormanik · ‎06-11-2016

Row 1 is 1, 2, 3, 4, 5, 8 (representing days). Row 2 are various values going out several decimal points. I want to run a regression on Row 1 vs. Row 2. I need the intercept and slope. Ideally in columns following the values in Row 2. There are many more rows besides Row 2. Hundreds. Each row needs a regression run, to find intercept and slope. But Row 1 remains the same throughout all the regressions. Since the SAS worksheet is already set up as described above it would be preferable to be able to use it as is. Any possibilities going about this?? Help and suggestions greatly appreciated. Nicholas

NKormanik · ‎05-19-2016

How would I combine two cases of your solution? data nicholas._21305_21501 ; set nicholas._21305_21501 (rename=(i1_Value=i1_Value_Character)) ; i1_Value = put(i1_Value_Character, 1.) ; drop i1_Value_Character ; run ; data nicholas._21305_21501 ; set nicholas._21305_21501 (rename=(i2_Value=i2_Value_Character)) ; i2_Value = put(i2_Value_Character, 1.) ; drop i2_Value_Character ; run ;

NKormanik · ‎05-16-2016

I've output 'Moments' from Proc Univariate to datasets. Many. Example: Moments_001.sas7bdat through to Moments_237.sas7bdat For the first column of each dataset (new added first column, and probably new dataset, as opposed to the original) I would like to have a particular text in every cell going down to bottom row. The exact text would be the name of the respective dataset file: say, "Moments_001". I do not have to 'grab' the filename, per se, if that's not possible. As I know what the names are already, I can put that text into the procedure. However, grabbing the filenames, if possible, would be easier from my standpoint. I'd greatly appreciate any help anyone could provide to accomplish this. Thanks, Nicholas Kormanik

Online Status	Offline
Date Last Visited	4 weeks ago

When is your SAS program good enough???

Re: Reset SAS without restarting SAS????

Reset SAS without restarting SAS????

Re: PROC GAMSELECT

Re: PROC GAMSELECT

PROC GAMSELECT

Re: Fascinating exchange with LLM

Fascinating exchange with LLM

Re: Trouble getting a macro to execute....

Trouble getting a macro to execute....

Re: When is your SAS program good enough???

Re: When is your SAS program good enough???

Re: When is your SAS program good enough???

Re: When is your SAS program good enough???

Re: When is your SAS program good enough???

Re: Using SAS Studio Online to Convert A Dataset

Re: User wants SAS code to return to Log window

Re: Logistic Regression -- Understanding Maximum Likelihood

Re: Interpreting 'Predicted' in Proc Logistic -- What's your take?

Interpreting 'Predicted' in Proc Logistic -- What's your take?

Combine (Interleave) two columns, keeping all other columns, too

Re: Use only the top xxx rows of the data set

Use only the top xxx rows of the data set

Re: Regression-type problem, data in a row...

Re: Regression-type problem, data in a row...

Re: Regression-type problem, data in a row...

Re: Regression-type problem, data in a row...

Re: "Efficient" form for SAS data step

"Efficient" form for SAS data step

Re: Regression-type problem, data in a row...

Regression-type problem, data in a row...

Re: Regression data are across rows

Regression data are across rows

Re: Variable has been defined as both character and numeric

Insert text into all cells of first column in a sas dataset