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-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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
  • 3312 views
  • 0 likes
  • 5 in conversation