SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to create a sparse matrix?

Reply
Occasional Contributor
Posts: 6

How to create a sparse matrix?

Hello,

Currently we have some problemes with using SAS.

We have used the following code

PROC IMPORT OUT= WORK.FRAUD

DATAFILE= "C:\..."

DBMS=CSV REPLACE;

     GETNAMES=YES;

     DATAROW=2;

RUN;


This datafile contains 3958352 records.

Now we want to make a sparse matrix from this datafile.

Do you guys know how we can do this?


We found some example code on the internet:

x = {3 1.1 0 0 ,

  1.1 4 0 3.2,

  0 1 10 0 ,

  0 3.2 0 3 };

a = sparse(x, "sym");

print a[colname={"Value" "Row" "Col"}];

But we don't know how to say that x containts the dataset work.fraud.

We couldn't find anything on the sas community.

Kind regards

Super User
Posts: 10,048

Re: How to create a sparse matrix?

You should post it at another forum.

Ask a Question
Discussion stats
  • 1 reply
  • 234 views
  • 0 likes
  • 2 in conversation