topic Re: Import data and add a new variable in Statistical Procedures

Import data and add a new variable

alix1 — Wed, 15 Aug 2018 18:59:00 GMT

I am starting to work with SAS and I would like you to please help me resolve the following questions.

How do I transform an imported database from Excel into a matrix?
How can I add a column vector of ones?

Re: Import data and add a new variable

Reeza — Wed, 15 Aug 2018 19:03:15 GMT

Are you planning to work with SAS/IML or with base programming?

If you're using Base Programming here are some instructions on how to import your data and to create a new column.

Import a CSV file

https://video.sas.com/detail/videos/sas-analytics-u/video/4573016758001/creating-a-sas-table-from-a-csv-file

Import an Excel file

https://video.sas.com/detail/video/4664358166001/using-the-import-data-utility-in-sas-studio

Create a new column

https://video.sas.com/detail/videos/sas-analytics-u/video/4573023399001/creating-a-new-column-in-sas

If you're trying to do this via IML which is more similar to R/Python and matrices/arrays in mathematics, then you would first import your data and then load it into a matrix.

@alix1 wrote:

I am starting to work with SAS and I would like you to please help me resolve the following questions.

How do I transform an imported database from Excel into a matrix?
How can I add a column vector of ones?

Re: Import data and add a new variable

alix1 — Sat, 18 Aug 2018 17:42:22 GMT

Thanks for your help.
I would like to know how I do to build a vector that contains a one and a
random value of a uniform distribution. I tried to do it in the following
way, but it generates an error.

proc iml;
x={1 RAND("UNIFORM")};
print x;

Re: Import data and add a new variable

Reeza — Sat, 18 Aug 2018 19:07:16 GMT

It looks like you're using IML - that isn't my forte so I'd suggest you move that to an IML forum.

Here's some short cut references that may help:

https://blogs.sas.com/content/iml/2015/09/28/create-test-matrices.html

If it was a data step it would be:

data want;
    do Row_Number=1 to 100;
        constant=1;
        x=rand('integer', 5, 10);
        *create a random number between 5 and 10;
        output;
    end;
run;

Re: Import data and add a new variable

alix1 — Sun, 19 Aug 2018 00:07:38 GMT

Thank you, your help is very useful.