Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Programming
- /
- SAS Procedures
- /
- Lining up variables when exporting data to Excel from PROC IML

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 11-12-2015 10:36 AM
(1223 views)

I have a dataset in which three variables (let's call them X, Y, and Z) are to be written into matrices in PROC IML and have some calculations performed upon them. The result of the calculations I need to export to an Excel file. Another column in the original dataset (let's call it N) will not be used in any calculations, but I need it written to the Excel spreadsheet alongside the output of the calculation.

How do I ensure that the values in N line up with the corresponding results in the output? I suspect that a loop of some kind is needed (for every record in N, (write X, Y, and Z to matrices, perform the calculations, write N to Excel, write results to Excel)). Am I right about the loop? Is it possible to have several different steps within one loop? And what is the exact syntax for this?

3 REPLIES 3

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

If PROC IML is not changing the order of the data, you would write the IML results into a SAS data set, and then merge with the original data set that contains N.

If IML is changing the order of the data, you'd need to include N in your IML matrices and sort/re-arrange N the same as you are doing with the rest of the data.

--

Paige Miller

Paige Miller

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Assuming matrix X has variable X in column 1 and variable N in column 2

newcolumn=x[:,1]#y;

But it sounds like there's really no reason to put X and N into the same matrix in IML.

--

Paige Miller

Paige Miller

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

**If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. **

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.