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

Hi,  I have a new installation of SAS ver 9.4 running on a computer that I must log into remotely using LOGMEIN. When I try to export a SAS dataset using the "EXPORT DATA" function, I receive the following error:   ERROR: The setting of the SYSPRINT option to "Adobe PDF via LogMeIn" will be ignored  because "Adobe PDF via LogMeIn" is not the name of a currently installed printer.  This error may be due to changes in SYSPRINT option syntax.  Please refer to your host companion for details of those changes. ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. NOTE: Export Cancelled.   Any suggestions?  Thank you ... View more

Sorry to ask this question again. I have the following character data column in a SAS dataset:   Exp_c 05/01/2018 04/31/2017 10/31/2017 01/1/1901 01/1/1901 01/1/1901 09/31/2016   Column formating is Character Format $12.  Informat $12.  Length 12   Using the following lines of code :   data want ;  set have  ;  new_date = input (Exp_c ,ddmmyy10.) ; format new_date ddmmyy10. ; Put _ALL_ ; run ;   Some dates convert and others do not.  THe following do not:   04/31/2017 10/31/2017 09/31/2016   The log message received is:   "NOTE: Invalid argument to function INPUT at line 12045 column 12."  and "NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been       set to missing values.       Each place is given by: (Number of times) at (Line):(Column).       3 at 12045:12"   Any suggestions ?  Thank you ... View more