Can Pearl functions be used to extract data from notepad and populate in Excel. Data looks like this -> ------------------------------------------------------------------------ PRODUCT Natural pistachios packaged in 4 oz. bags, UPC 076056 09460. Recall # F-1267-2012 CODE Date code 08361 RECALLING FIRM/MANUFACTURER Fritz Company, Inc., Newport, MN, by e-mail on April 1, 2009. FDA initiated recall is complete. REASON The product was manufactured using pistachios recalled by Setton Pistachio Company of Terra Bella because it has the potential to be contaminated with Salmonella. VOLUME OF PRODUCT IN COMMERCE Unknown DISTRIBUTION MN, WI, IA, MO, ND, SD, MT ___________________________________ and then repeats in the same format with a separating line I want data to be in Excel format PRODUCT               CODE          RECALLING FIRM.               REASON                         VOLUME                         DISTRIBUTION Thanks ... View more

For each observation, I want to find the variable that contains the maximum value here is the File structure i/p Obs        CompanyID              Year       Col1       Col2       col3       col4       col5 1             AAAA                    1991           2             3             6             7             2 2             BBBB                    1992           6             9             3             2             0 Intended o/p Obs        CompanyID         Year       Col1       Col2       col3       col4       col5                Max 1             AAAA                    1991      2             3             6             7             2             col4 2             BBBB                    1992      6             9             3             2             0             col2 I used the following code but it just creates column names in the o/p file. proc iml; use FileA; read all var _NUM_ INTO X [colname=VarNames]; close FileA; idxMax = X[,<:>]; /* find columns for max of each row */ varMax = varNames[idxMax]; /* corresponding var names */ print idxMax varNames; run; Any thoughts? Is there a simple way in SQL? ... View more

I want to extract digits from a string For example a typical string is given as  =  PYRIDOSTIGMINE BROMIDE (NDA #020414) I want to extract 020414. I am having hard time telling SAS (pearl functions) to extract after # and stop before ')' Any ideas? Thanks ... View more