I have a column of names.  How do I remove everything in the parentheses (), including the parentheses, and all punctuation (i.e., . , / and the like)?  Here's the file with observation number and name.     1 ACCU TEST SYSTEMS INC 2 ADDVANTAGE TECHNOLOGIES GROUP INC (AEY) 3 AIRXPANDERS INC 4 ALFI, INC. (ALF, ALFIW) 5 AMERICAN PAIN AND STRESS INC 6 AMERICAN TELEDATA CORP. 7 BIONOVO INC 8 BRENCO INTERNATIONAL INC. 9 CANOO INC. (GOEV, GOEVW) 10 CAREER EDUCATION CORP (PRDO) 11 CODI CORP 12 COMPUTER STORE INC (THE ) 13 CPI LTD (COMMUNICATIONS & POWER INDUSTRIES) 14 CYREN LTD. (CYRN) 15 DIPLOMAT ELECTRONICS CORP 16 DIXIE EQUIPMENT COMPANY, INC. 17 DUTCH GOLD RESOURCES INC 18 ELECTRIC LAST MILE SOLUTIONS, INC. (ELMS, ELMSW) 19 ELECTRONIC CIGARETTES INTERNATIONAL GROUP, LTD. 20 ELECTRONIC GAME CARD INC 21 EMPIRE POST MEDIA, INC. (EMPM) 22 ENERGROUP TECHNOLOGIES 23 GLOBAL ENVIRONMENTAL LABORATORIES, INC. 24 GLOBE PHOTOS, INC. (GBPT) 25 GREENROSE HOLDING CO INC. 26 HURRICANE CREEK PARTNERS LTD. 27 INTEGRATED NETWORK CORP. 28 INTERNATIONAL HERITAGE, INC. 29 IVDS INTERACTIVE ACQUISITION PARTNERS 30 JACKS INC 31 LEXAGENE HOLDINGS INC. (LXXGF) 32 LIQOUR BARN NORTHERN CALIF. INC 33 LOGOS SCIENTIFIC, INC. 34 LUXEYARD, INC. 35 MAD CATZ INTERACTIVE INC 36 MARK BENSKIN & CO. INC 37 MEDIA CENTRAL, INC. 38 META MATERIALS INC. (MMAT) 39 MOMENTOUS ENTERTAINMENT GROUP INC 40 NDIVISION INC. (NDVN) 41 NEUROLOGIX INC/DE 42 PROTECH, INC. D.B.A. OMEGA TEST SYSTEMS 43 REDBOX ENTERTAINMENT INC. (RDBX, RDBXW) 44 REGENT ENTERPRISE INC. 45 RODAC CORP 46 RPC INC (RES) 47 SHAPEWAYS HOLDINGS, INC. (SHPWQ) 48 STEALTH TECHNOLOGIES, INC. (STTH, STTHD) 49 SULPHCO INC 50 SUNWORKS, INC. (SUNW) 51 TOYS PLUS INC 52 TRANSBIOTEC, INC. (IMLE, SOBR, IMLED) 53 TRANSWITCH CORP /DE 54 UNIQUE FABRICATING, INC. (UFAB) 55 VISION COMMUNICATIONS CORP 56 VSC INC (VULCAN STEEL COMPANY) 57 WEBER INC. (WEBR) ... View more

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