Random Sample Failed with "ERROR: Procedure SURVEYSELECT not found"

[User_Help]

Hi all,

Tried to generate a random record but failed with log below:

PROC SURVEYSELECT DATA=ECLIB000.data_0821()
ERROR: Procedure SURVEYSELECT not found.
43 OUT=WORK.RANDRandomSampledata_08
44 METHOD=SRS
45 N=10;
46 RUN;

Anyone knows what's going on?

Thank you.

[PeterClemmensen]

Run 

proc setinit;
run;

and see if the SAS/STAT is available to you

[User_Help]

Hi @PeterClemmensen ,

Here is the results, is it okay?

Product expiration dates:
---Base SAS Software 31DEC2021
---SAS/STAT 31DEC2021
---SAS/Secure 168-bit 31DEC2021
---SAS/Secure Windows 31DEC2021
---SAS Enterprise Guide 31DEC2021
---SAS/ACCESS Interface to PC Files 31DEC2021
---SAS/ACCESS Interface to ODBC 31DEC2021
---SAS Workspace Server for Local Access 31DEC2021
---High Performance Suite

[Ksharp]

Run this :

proc product_status;run;

[User_Help]

Hi @Ksharp ,

The log as below, is it okay?

1 The SAS System 09:42 Thursday, October 21, 2021

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTNAME='';
7 %LET _SASPROGRAMFILE=;
8
9 ODS _ALL_ CLOSE;
10 OPTIONS DEV=ACTIVEX;
11 FILENAME EGSR TEMP;
12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
13 STYLE=HtmlBlue
14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
15 NOGTITLE
16 NOGFOOTNOTE
17 GPATH=&sasworklocation
18 ENCODING=UTF8
19 options(rolap="on")
20 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
21 FILENAME EGXLSSX TEMP;
22 ODS EXCEL(ID=EGXLSSX) FILE=EGXLSSX STYLE=Excel
23 OPTIONS (
24 EMBEDDED_TITLES="no" EMBEDDED_FOOTNOTES="no"
25 );
WARNING: Unsupported device 'ACTIVEX' for EXCEL(EGXLSSX) destination. Using device 'ACTXIMG'.
26
27 proc product_status;run;

For Base SAS Software ...
Custom version information: 9.4_M3
Image version information: 9.04.01M3P062415
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M3
For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.4_M3
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
real time 0.02 seconds
cpu time 0.03 seconds

28
29 %LET _CLIENTTASKLABEL=;
30 %LET _CLIENTPROCESSFLOWNAME=;
31 %LET _CLIENTPROJECTPATH=;
32 %LET _CLIENTPROJECTNAME=;
33 %LET _SASPROGRAMFILE=;
34
35 ;*';*";*/;quit;run;
36 ODS _ALL_ CLOSE;
NOTE: Writing EXCEL(EGXLSSX) file: C:\Users\xx\AppData\Local\Temp\SEG13660\SAS Temporary Files\_TD6256_MYLURM9516ZG3_\#LN07718
37
38
39 QUIT; RUN;
40

[Ksharp · Accepted solution]

Ha. Here is.
Compare to the output of " proc setinit;run; " .
You will find you missed module SAS/STAT . (a.k.a you don't have license of SAS/STAT)
That is the reason you are unable to run PROC SURVEYSELECT.
Try install sas package again .


Product expiration dates:
---Base SAS Software 31DEC2021
---SAS/STAT 31DEC2021
---SAS/Secure 168-bit 31DEC2021
---SAS/Secure Windows 31DEC2021
---SAS Enterprise Guide 31DEC2021
---SAS/ACCESS Interface to PC Files 31DEC2021
---SAS/ACCESS Interface to ODBC 31DEC2021
---SAS Workspace Server for Local Access 31DEC2021
---High Performance Suite