I am attempting to use SASEFRED to access the FRED database.  I have been going through the examples in the SAS documentation, and I'm having issues. I have my APIKEY from FRED.  Below is my code that I modified from an example located at: http://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/etsug/etsug_sasefred_details11.htm .  I am using SAS on Demand for Academics.   Here are my questions/comments: I do not understand sslcalistloc.   I do not know what to do with it or what it does.  I do not know where to look for certificates.  Any explanation is appreciated.  I do not know what to enter after sslcalistloc.  I have read the product documentation and still don't understand. Why does the SAS data set fred.gstart have zero (0) observations? The FRED library is successfully created but I get the spinny wheel of death when I click on it.  See screenshot below.  The wheel doesn't stop spinning.   options validvarname=any /* sslcalistloc="/SASSecurityCertificateFramework/1.1/cacerts/trustedcerts.pem"; */ title 'FRED Data: SP500 Stock Index and Wilshire 5000 Price Index'; LIBNAME FRED sasefred "/home/u49890908/FRED" OUTXML=gstart AUTOMAP=replace MAPREF=FRED XMLMAP="/home/u49890908/FRED/gstart.map" APIKEY='FAKEAPIKEY0123456789012346579801' IDLIST='sp500,will5000pr' START='2011-01-01' END='2012-01-01' FREQ='m' FORMAT=xml; data stock_price; set FRED.gstart; run; proc contents data=stock_price; run; proc print data=stock_price; run; Here's my log. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 options validvarname=any 74 75 /* sslcalistloc="/SASSecurityCertificateFramework/1.1/cacerts/trustedcerts.pem" */; 76 title 'FRED Data: SP500 Stock Index and Wilshire 5000 Price Index'; 77 LIBNAME FRED sasefred "/home/u49890908/FRED" 78 OUTXML=gstart 79 AUTOMAP=replace 80 MAPREF=FRED 81 XMLMAP="/home/u49890908/FRED/gstart.map" 82 APIKEY='FAKEAPIKEY0123456789012346579801' 83 IDLIST='sp500,will5000pr' 84 START='2011-01-01' 85 END='2012-01-01' 86 FREQ='m' 87 FORMAT=xml; NOTE: The default frequency of this timeseries (SP500) is equal or higher than the requested FREQ (m). NOTE: Ran the FILENAME URL assignment to request FRED data. NOTE: Ran the DATA Step to get the FRED data for the OUTXML= option. NOTE: Ran the XMLV2 data engine with the XMLMAP= option. NOTE: The default frequency of this timeseries ( WILL5000PR) is equal or higher than the requested FREQ (m). NOTE: Ran the FILENAME URL assignment to request FRED data. NOTE: Ran the DATA Step to get the FRED data for the OUTXML= option. NOTE: Ran the XMLV2 data engine with the XMLMAP= option. NOTE: Libref FRED was successfully assigned as follows: Engine: SASEFRED Physical Name: /home/u49890908/FRED 88 89 data stock_price; 90 set FRED.gstart; NOTE: Ran the data step to access and save the FRED data. ERROR: Database /home/u49890908/FRED/GSTART.sas7bdat could not be opened successfully. The file may not exist or it is currently locked. ERROR: Error detected by XOINFO routine: discrepancy in nvars or nobs count. 91 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.STOCK_PRICE may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.STOCK_PRICE was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.23 seconds user cpu time 0.12 seconds system cpu time 0.01 seconds memory 1638.46k OS Memory 36276.00k Timestamp 06/21/2023 07:06:49 PM Step Count 167 Switch Count 48 Page Faults 0 Page Reclaims 1119 Page Swaps 0 Voluntary Context Switches 636 Involuntary Context Switches 0 Block Input Operations 1472 Block Output Operations 1688 92 93 proc contents data=stock_price; 94 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.03 seconds user cpu time 0.04 seconds system cpu time 0.00 seconds memory 775.50k OS Memory 35756.00k Timestamp 06/21/2023 07:06:49 PM Step Count 168 Switch Count 0 Page Faults 0 Page Reclaims 59 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 95 96 proc print data=stock_price; 97 run; NOTE: No variables in data set WORK.STOCK_PRICE. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 364.37k OS Memory 35496.00k Timestamp 06/21/2023 07:06:49 PM Step Count 169 Switch Count 0 Page Faults 0 Page Reclaims 16 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 98 99 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 111       ... View more

Does anybody know of a good book or resource on PROC PANEL?     I have already explored SAS documentation and examples provided by SAS at:  https://documentation.sas.com/doc/en/etsug/15.2/etsug_panel_toc.htm .    I am supervising a master thesis for an IESEG finance student in France, so I am trying to help one of my students better understand fixed-effects and random-effects models.  The student has panel data. ... View more

Here's my data and program.  u1 and u2 are standard normal variables.   Data set name is have: data cdf (keep=u1 u2 cdf); set have; cdf=probbnrm(u1, u2, &rho); run;   proc transpose data=cdf; by u1; id u2; run;   When I run the code it produces a matrix with the main diagonal terms (in yellow) but missing values for all others.  I've attempted a few other pieces of code but can't seem to get the output below.   Any suggestions?       ... View more

I want to calculate the cumulative bivariate normal distribution of two standard normal variables.  Is  there a SAS PROC or SAS FUNCTION that does this?  When rho=0, this is easy but rho =^ 0, it's more involved.  For example, suppose x1=-2.05 and x2=-1.64. -2.05 is associated 0.02 with and -1.64 is associated with 0.05.  When rho=0, you just multiply 0.02*0.05 to get 0.001 but when rho N=^ 0 it's a little messy.  Trying to avoid writing the code if SAS has a PROC of FUNCTION that does this for me.  No IML please. ... View more