About paldejong

paldejong · ‎09-17-2020

That is exactly what I needed. Thank you! Pieter

paldejong · ‎09-17-2020

Dear all, I would like to able to produce a cross table with 8 independent categorical variables the same way PROC CORR tabulates the correlation coefficients. I would need to know the frequency of each variable in relation to the other independent variable. I have tried PROC FREQ with the table feature which does part of what I would like but I would love to combine all that information into 1 table. Thank you, Pieter

paldejong · ‎06-22-2020

Thank you so much; that is exactly what I am looking for.

paldejong · ‎06-22-2020

I do not mind admitting that I might not have the chops to perform that specific task and the first sentence of your reply is confusing. I looked at several examples of the Proc Report statements but I have not found one that shows how to combine two variables that are originally in a horizontal orientation in one vertical column for each variable. The reason I am asking this is because I am running several regressions and I would prefer to not having to change the format of the SAS output in Excel each time. Thank you. Pieter

paldejong · ‎06-22-2020

Dear all, I posted two screenshots; one with regular SAS output from a logistic regression, where I adjusted the standard errors to be reported with parentheses. The other screenshot is an Excel spreadsheet picture of the table orientation that I would like to be able to run directly from SAS. I have not figured out how to have the estimates and the standard errors in one column per variable. I appreciate your input. Thank you, Pieter

paldejong · ‎02-12-2017

Thank you so much for your help. Pieter

paldejong · ‎02-12-2017

Okay, Thank you. I added a raw version of the code. At this junction, it will calculate the forecast for the "next" year from all the observations in the sample. I would like it to forecast a observation from 4 previous years and do this continually throughout the sample. Best, Pieter

paldejong · ‎02-11-2017

Dear all, I have sales data that is grouped by company and year. I would like to "forecast" sales data within the sample so that I could compare the predicted sales figures with the actual sales data. For example, the data spans from 1984 to 2015 for many companies and I would like to calculate the predicted sales with a exponential smoothing procedure in 1988 from actual sales of the four previous years (1984-1987) and continue this throughout all available years so I would have a sales value for 1988 (from 1984-1987), 1989 (from 1985-1988) and so forth. So far I have been able to forecast data for the "next" year (in this case 2016) but I do not know how to set the forecast window so that it would move in 4-year increments. Thank you, Pieter

paldejong · ‎10-04-2016

Dear all, I need some help with a macro procedure for paired t-tests in a sample of stocks independently sorted across two variables (please see the top of the attached text file). There are 25 groups that have been formed out of the intersections of the variable rankings (each variable has 5 distinct groups). The means within these groups are of variable DEX. I would like to be able to test the paired t-test for the groups at the outskirts of the rankings; for example the intersection of BM_RK "1" and DEX_RK "1" against the intersection of BM_RK "5" and DEX_RK "1". Following that pattern there would be five test results on the right hand side of the transposed table (see bottom portion of the attached text file) and five test results at the bottom of the table. I have been able to form individual data sets from the sample to capture the needed intersections of the ranked variables but the effort is not very efficient and I believe that there might be a better technique that I am currently not familiar with. Thank you for help.

Online Status	Offline
Date Last Visited	‎05-24-2022 10:17 PM

Re: Cross table

Cross table

Re: Formating table

Re: Formating table

Formating table

Re: Calculate predictions and compare with actual values

Re: Calculate predictions and compare with actual values

Calculate predictions and compare with actual values

paired t-test macro

Re: Cross table

Calculate predictions and compare with actual values

Re: Cross table

Cross table

Re: Formating table

Re: Formating table

Formating table

Re: Calculate predictions and compare with actual values

Re: Calculate predictions and compare with actual values

Calculate predictions and compare with actual values

paired t-test macro