Hi,   I need your help.   I want to understand how PROC UNIVARIATE decides how many bins are required?   I have the following code:   ods output HistogramBins = prefix_th;  proc univariate data = datain noprint;  histogram y / vscale = percent  MIDPERCENTS; run;   and I see depending on the data I have different numbers of bins.    I found the original paper: https://www.jstor.org/stable/2288074 and I use the following approach: width = 3.5 * σ * n^(-1/3) nbins = ceil( (max - min) / width )   but still I have different number of bins.   Can you help?   from support:   ENDPOINTS <=values |KEY |UNIFORM> uses histogram bin endpoints as the tick mark values for the horizontal axis and determines how to compute the bin width of the histogram bars. You can specify the following values: values specifies both the left and right endpoints of each histogram interval. The width of the histogram bars is the difference between consecutive endpoints. The procedure uses the same values for all variables. KEY determines the endpoints for the data in the key cell. The initial number of endpoints is based on the number of observations in the key cell by using the method of Terrell and Scott (1985). The procedure extends the endpoint list for the key cell in either direction as necessary until it spans the data in the remaining cells. UNIFORM determines the endpoints by using all the observations as if there were no cells. In other words, the number of endpoints is based on the total sample size by using the method of Terrell and Scott (1985). ... View more

Hi,   in my work I need to upload temporary table from SAS server to EAP server. Now we are using TRINO/Voyager and under SAS we can do it running the below codes, but it is very sloooooow. Uploading 428 records from SAS (sashelp.cars) to EAP takes 13/24 minutes. I have experience with hadoop and under hadoop it takes 2-3 minutes.    Do you know how can I speed up this step ? I tried to add “BULKLOAD=YES” option but no change.    Best Regards     28         29         libname libtest jdbc classpath='/opt/sas/JDBC3/' 30          class='io.trino.jdbc.TrinoDriver' 31          URL='jdbc:trino://ccc.aaa.bbb.net:8980/eap/aml?SSL=true&SSLVerification=CA&SSLTrustStorePath=/opt/sas/JDBC3/cacerts.jks&SSLTrustStorePassword=changeit' 32            user=&sysuserid. 33            password="&pass." 34         schema=my_schema 35         36         ; NOTE: Libref LIBTEST was successfully assigned as follows:       Engine:        JDBC   37         38         data libtest.sas_test_upl_presto2; 39         set sashelp.cars; 40         run;   NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. NOTE: There were 428 observations read from the data set SASHELP.CARS. NOTE: The data set LIBTEST.SAS_TEST_UPL_PRESTO2 has 428 observations and 15 variables. NOTE: DATA statement used (Total process time):       real time           13:08.07       cpu time            0.35 seconds ... View more

Hi,   I have problem with one warning: """WARNING: The font <sans-serif> is not available. Albany AMT will be used.""" on SAS server. I understand the problem but how to solve it without Admin rights. any hints?   IF I run the following code in EG8, there is no warning:   proc univariate data = sashelp.cars noprint; histogram horsepower ; title1 j=center height=15pt "title"; inset mean median n / position=nw cfill=ywh; label horsepower= "sub_title"; run; NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.13 seconds cpu time 0.14 seconds     But when I try to export to PDF I get the following warning: ods graphics on; ods pdf FILE="/home/aaaa.pdf" style=HTMLBlue ; ods select Histogram; proc univariate data = sashelp.cars noprint; histogram horsepower ; title1 j=center height=15pt "title"; inset mean median n / position=nw cfill=ywh; label horsepower= "sub_title";  run; WARNING: The font <sans-serif> is not available. Albany AMT will be used. WARNING: The font <sans-serif> is not available. Albany AMT will be used. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 2.87 seconds cpu time 0.18 seconds         ... View more