Hello Again SAS Friends,    This is a followup to an earlier question.   Need to import a .TXT file that has a header that appears irregularly.  The header appears at the top of the first page, and then reappears after 87, or 88, 89, 90, or more rows.  Sometimes the header is inserted into the data subunits (see below), and splits them into two.   The basic data subunit of interest is either a 6 or 7 rows.  The first component of the subunit is a 12 digit number #####-####-##, followed by other variables that are connected to that number.    The code to capture the data from the subunits is below.  What is not included is code to work around the unwanted header information.   Attached is a sample of the .TXT file with the header inserted into inconvenient places to demonstrate the TXT file structure.  The actual dataset is ~17000 pages, so is not attached.     One option tried was to import the entire .TXT file so that there is a single variable and one row for each row of the TXT file.  However I could not get all the text (characters and spaces) from one row into a single variable field.  If that is possible, then I think SAS character editing can be used to take care of the rest of the import.   Or if its possible to somehow remove the header information , that would work too.  Should I parse this in another program?   //////////////////////////////////////////////////// DATA Cost; infile datalines truncover; INPUT @5 ABC $14. @20 DRUG $26. @60 PKG 4.0; if missing(PKG) then input @60 PKG 4.0 / @1 NN_3 $1. / @1 NN_4 $1. / @29 AWP DOLLAR8.2 / @1 NN_6 $1. / @1 NN_7 $12; else input @1 NN_2 $1. / @1 NN_3 $1. / @1 NN_4 $1. / @29 AWP DOLLAR8.2 / @1 NN_6 $1. ; FORMAT AWP Dollar8.2 ; datalines; 20000-0000-00 Product6_________________ 1 0 0 0 0 Min Onhand 0 Max Onhand 0 Lot No Last Sold Manufacture AWP $0.00 Retail $0.00 Cost $0.00 Price Schedule Drug Expire MAC $0.00 WAC Retail Value $0.00 Cost Value $0.00 100000-0000-00 Product7_________________ N 10 0 0 0 0 0 Min Onhand 0 Max Onhand 0 Lot No Last Sold Manufacture BAXA CORP. AWP $158.04 Retail $0.00 Cost $0.00 Price Schedule 0 Drug Expire MAC $0.00 WAC Retail Value $0.00 Cost Value $0.00 ;   Thanks R               ... View more

Hi SAS Friends,    Am using SAS ver 9.4 to parse up a large data set where the first variable of each sub data set is a product number, followed by either 6 or 7 additional rows if information related to the product number. In the 6 row version, row 1 has 124 characters In the 7 row version, row 1 has only 47 characters and the remaining data drop down to create a new row.   I've attached a SAS file with a data step that will import the 6 row data set successfully, and, separately, the 7 row data set successfully.  However the entire dataset includes 17000 products with the 6 or 7 row subdata sets interspersed randomly.   Any suggestions about how such a large dataset can be imported?  How to get SAS to recognize the 6 or 7 row subdata sets and apply the needed code? Or some other strategy   Thanks,  very much appreciated,   R    ... View more

Hi All,  I am using PROC REPORT to generate a meeting agenda.  The major agenda topics are noted with whole numbers, 1.0, 2.0, 3.0, ect.... while the descriptive information is noted with decimals, 3.1, 4.1. Not every major topic has descriptive information. I'd like to INDENT the descriptive information only.  Is there a way to do that? Here is some sample data and code. Thank you !   data Agenda_2; input No Text1 $50. ; datalines ; 1 Members and Attendance 2 Review Minutes of Previous Meeting 3 Interesting First Topic 3.1 All there is to be said about this extremely Interesting First Topic, indeed 4 Interesting Second Topic 4.1 A copious font of knowledge concerning this extremely Interesting second Topic, indeed 5 Interesting third Topic 6 Interesting fourth Topic run;   ods listing close; options papersize=letter orientation=portrait ps=80 ls=100 nocenter LEFTMARGIN=0.75in RIGHTMARGIN=0.75in TOPMARGIN=1.0in BOTTOMMARGIN=0.75in nodate nonumber; ods rtf file="&tabout.\AG_PandT &datetime..rtf" ; proc report data= Agenda_2 NOWD style(report) = [bordercolor=white] style(column) = [bordercolor=white] style(header) = [bordercolor=white background = white] style(summary) = [bordercolor=white] ; column no text1 ; define no / ' ' style(column)={cellwidth= 0.5 in} format=4.1 ; define Text1 / ' ' style (column)={cellwidth=6.0 in} ; title1 j=c "Agenda"; title2 j=c "All The Interesting Things That Have Happened"; title3 j=c "Since We Last Had THis Meeting"; run; ODS _all_ close ; ... View more

Am not able to convert character text to a SAS date, apologies for the simple request: Data to be converted are "Mark_App_s" character of length 12.   Date sample    Mark_App_s  11/20/2001   09/05/2017   06/06/2017   10/31/2017    Code sample is : Data App_2 ; set App_1 ; Mark_App = input(Mark_App_s, yymmdd10.) ; format Mark_App mmddyy10.; run ;   Thanks ! ... View more

Has anyone used PROC KDE, or any other procedure to perform "Earth Mover's Distance" calculations? There is a "Do Loop" blog on the topic from 2013, and I cannot find anything else on the topic since that time. While the blog is helpful and the procedure relatively straight forward, there are nuances used that are application dependent, and I'm hoping to find others that have performed EMD calculations. Thank you     ... View more

HI All,  I have base SAS, E.G., SAS Studio, and  Need to search a large document for all acronyms (2, 3, 4 character), isolate them, and create a table of definitions. The acronyms can be any character like "IND", "mg", 'USP", etc... Is there a SAS function , or combination of functions, that will count the number of characters in a word,  and provide a YES/NO (1/0) answer if a certain number of characters are present?   Thanks ... View more