BookmarkSubscribeRSS Feed
RobPratt
SAS Super FREQ

OK, I see that the macro uses -- instead of - to range the control variables, so the selection does depend on the order of the variables in the data set.  Here is the log from running %vmatch(dist=tr, idca=key, a=1, b=4, lilm=12574, n=3069, firstco=&start, lastco=&end, print=n, out=result_optnet) with PROC OPTNET:

NOTE: ------------------------------------------------------------------------------------------------

NOTE: Running OPTNET version 13.1.

NOTE: ------------------------------------------------------------------------------------------------

NOTE: The number of columns in the input matrix is 12574.

NOTE: The number of rows in the input matrix is 12276.

NOTE: Data input used 1.83 (cpu: 1.82) seconds.

NOTE: ------------------------------------------------------------------------------------------------

NOTE: Processing the linear assignment problem.

NOTE: The linear assignment problem is infeasible (3436 rows are unassigned).

NOTE: The minimum cost partial linear assignment is 3682.8496594.

NOTE: Processing the linear assignment problem used 6.82 (cpu: 6.82) seconds.

NOTE: ------------------------------------------------------------------------------------------------

NOTE: The output data set contains a partial linear assignment.

NOTE: Data output used 0.67 (cpu: 0.67) seconds.

NOTE: ------------------------------------------------------------------------------------------------

NOTE: The data set WORK.__OUTT has 8840 observations and 3 variables.

NOTE: PROCEDURE OPTNET used (Total process time):

      real time           9.85 seconds

      cpu time            9.59 seconds

New result_optnet is attached.

Giamma14
Fluorite | Level 6

Thanks a lot!!!

Results are similar to proc assign but not the same, and no error is displayed so I tend to trust this more.

I've run all the analyses and final results do make sense.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 31 replies
  • 4464 views
  • 0 likes
  • 5 in conversation