Hello everyone,
I looked for the answer to this, but I am still confused because it seems like I have the required SAS/STAT package installed according to proc setinit. Does anybody know any other reason that I might not be able to access this procedure?
This is the code I used. It is a modification of code I found online on the SAS website. Thanks so much for your help!
ods graphics on;
proc psmatch data=contempcompar0 regions=allobs;
class dx sex race agegrp;
psmodel Drug(Treated='refer')= dx sex agegrp;
assess lps var=(Gender Age Bmi)/ varinfo plots=(boxplot barchart)
weight=attwgt;
output out(obs=all)=OutEx1;
run;
This is what my proc setinit returned in the log:
1306 proc setinit;
1307 run;
NOTE: PROCEDURE SETINIT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Original site validation data
Site name: 'COLUMBIA UNIVERSITY-MORNINGSIDE CAMPUS-T&R'.
Site number: #######.
Expiration: 31AUG2019.
Grace Period: 45 days (ending 15OCT2019).
Warning Period: 47 days (ending 01DEC2019).
System birthday: 09AUG2018.
Operating System: WX64_WKS.
Product expiration dates:
---Base SAS Software
31AUG2019
---SAS/STAT
31AUG2019
---SAS/GRAPH
31AUG2019
---SAS/ETS
31AUG2019
---SAS/FSP
31AUG2019
---SAS/OR
31AUG2019
---SAS/AF
31AUG2019
---SAS/IML
31AUG2019
---SAS/QC
31AUG2019
---SAS/SHARE
31AUG2019
---SAS/ASSIST
31AUG2019
---SAS/CONNECT
31AUG2019
---SAS/EIS
31AUG2019
---SAS/SHARE*NET
31AUG2019
---MDDB Server common products
31AUG2019
---SAS Integration Technologies
31AUG2019
---SAS/Secure 168-bit
31AUG2019
---SAS/Secure Windows
31AUG2019
---SAS Enterprise Guide
31AUG2019
---SAS Bridge for ESRI
31AUG2019
---OR OPT
31AUG2019
---OR PRS
31AUG2019
---OR IVS
31AUG2019
---OR LSO
31AUG2019
---SAS/ACCESS Interface to DB2
31AUG2019
---SAS/ACCESS Interface to Oracle
31AUG2019
---SAS/ACCESS Interface to Sybase
31AUG2019
---SAS/ACCESS Interface to PC Files
31AUG2019
---SAS/ACCESS Interface to ODBC
31AUG2019
---SAS/ACCESS Interface to OLE DB
31AUG2019
---SAS/ACCESS Interface to Teradata
31AUG2019
---SAS/ACCESS Interface to Microsoft SQL Server
31AUG2019
---SAS/ACCESS Interface to MySQL
31AUG2019
---SAS/IML Studio
31AUG2019
---SAS Workspace Server for Local Access
31AUG2019
---SAS/ACCESS Interface to Netezza
31AUG2019
---SAS/ACCESS Interface to Aster nCluster
31AUG2019
---SAS/ACCESS Interface to Greenplum
31AUG2019
---SAS/ACCESS Interface to Sybase IQ
31AUG2019
---SAS/ACCESS to Hadoop
31AUG2019
---SAS/ACCESS to Vertica
31AUG2019
---SAS/ACCESS to Postgres
31AUG2019
---SAS/ACCESS Reserved Slot 565
31AUG2019
---SAS/ACCESS Reserved Slot 567
31AUG2019
---SAS/ACCESS Reserved Slot 568
31AUG2019
---High Performance Suite
31AUG2019
---SAS/ACCESS to SAP HANA
31AUG2019
---PRODNUM964
31AUG2019
For SAS/STAT ... Custom version information: 12.3 (maintenance)
That's a weird setup. Otherwise, why be on 9.4 and not have 14.3 or 15.1.
Unfortunately, it looks like you're using a really old version, 12.3.
If this is related to academia you can download SAS UE or if your data can go to the cloud you can use SAS Academics on Demand and use PSMATCH there. Or try to convince your IT area to update your SAS installation.
You need SAS/STAT 14.3 I believe. You can check what's installed with the following:
proc product_status;
run;
Most likely you have an older version of SAS/STAT or you don't have SAS/STAT installed.
FYI - I modified your post to remove your Site Number.
Upgrades are free though.
Hi Reeza,
Thanks so much for your reply. You are always a big help. I believe I do have SAS/STAT installed because proc setinit showed that this package was installed and expires in Aug 2019. I just ran the procedure you talked about and this is what I got in the log:
For Base SAS Software ...
Custom version information: 9.4
Image version information: 9.04.01M0P061913
For SAS/STAT ...
Custom version information: 12.3 (maintenance)
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
real time 0.05 seconds
cpu time 0.01 seconds
Is SAS 9.4 not the most updated version?
For SAS/STAT ... Custom version information: 12.3 (maintenance)
That's a weird setup. Otherwise, why be on 9.4 and not have 14.3 or 15.1.
Unfortunately, it looks like you're using a really old version, 12.3.
If this is related to academia you can download SAS UE or if your data can go to the cloud you can use SAS Academics on Demand and use PSMATCH there. Or try to convince your IT area to update your SAS installation.
Hi Reeza,
My SAS installation is updated by the IT department at my university and is out of my hands. I'm not sure if they are that knowledgeable about the different elements of the installation package, but this is great information, and I will relay it to them. Thanks so much for your help!
Hi @sabataged,
Your release seems to be more than five years old. There have been six maintenance releases since then: SAS 9.4M1, ..., SAS 9.4M6 (yours is M0). PROC PSMATCH was added in M4 (SAS/STAT 14.2 -- yours is 12.3) according to "What’s New in SAS® 9.4 and SAS® Viya® 3.4."
Wow, thank you for letting me know! I don't know if my tech support at my university can help me with this, but I will relay this information to them. Thanks again
There's a part of me that wonders if someone forgot to update the SAS/STAT components. 12.3 was available in 9.2 I think, so to have 9.4 but still have SAS/STAT 12.3 seems really weird to me.
9.4M0 is fairly buggy as well, I'm surprised they're not itching to move to 9.4M6 or M5 which are much better. The ODS EXCEL feature alone is worth the upgrade.
Hi Reeza,
so I told IT about the issue and they updated me to the M3 version, which is still not the latest M6 version. It took over an hour to complete, and afterwards they said, "Oh we just realized there is an M6 version" and said I'd have to wait until the next license update to get upgraded again. Oh well! The PSMATCH procedure is still not working on this newer M3 version, but I am too wary of asking them about it again as I've already wasted a few hours of the workday! Anyway, thanks so much for your assistance and insight. It's always very appreciated.
-Saba
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.