The ANYDTDTM informat will not handle the AM/PM. The MDYAMPM informat would do the trick, except it does not come in a DMY flavor. Assuming you have no control over the structure of the value, I think that you are back to parsing the input line. ... View more

If you can get the SQL to work it will probably be for efficient than the following, which at least seems to work. It does read portions of the data twice and requires a sort, so may be less practical for large data sets. [pre]data idprod; input id DATE1 :YYMMdd. DATE2 :YYMMdd. PROD OUTC $; format date1 date2 date9.; datalines; 17 20041016 20041107 1010 N 17 20041016 20050131 1010 Y 17 20050718 20050919 1010 N 17 20050718 20060221 1010 Y 17 20070206 20070314 1227 N 17 20070206 20071021 1227 N 17 20080714 20081027 1624 Y RUN; proc sort data=idprod; by id prod date2; run; data select(keep=id date1 date2 prod outc); set idprod; by id prod; retain point start . found ' '; cnt+1; if first.prod then do; start=cnt; found=' '; end; if outc='Y' & found=' ' then do point=start to cnt; set idprod point=point; output select; found='x'; end; run; [/pre] ... View more

Now I better understand the question, and I learned some TABULATE syntax too! I noticed that in the LISTING destination the word AND is used as in: a, b, and c for the page label. In PDF each is comma separated as in: a, b, c This is demonstrated in the following code, which mimics yours: [pre]ods pdf file='c:\temp\shoes.pdf' style=default; PROC TABULATE DATA=sashelp.shoes; VAR sales; CLASS region product subsidiary; TABLE region*product, subsidiary, sales*sum; RUN; ods pdf close;[/pre] I have not yet found a style attribute that will solve the problem however. ... View more

Have you looked at using PROC FCMP to build/store a function, and then use it in your SQL step? ... View more

I imagine that you are also getting a number of errors in the LOG. 1) there is no order=unformatted 2) Beware of missmatched quotes - these are getting you in trouble here 3) You must have the system option validvarname=any turned on to use the nonstandard variable name structures. 4) what are you trying to do with the ={label="} ?? this gives you the mismatched quote and is not valid syntax. ... View more

Ron Cody has several very good books on programming examples as well as workbooks with problems and exercises. Go to the SASPress catalog and search for Author=Cody; https://support.sas.com/pubscat/complete.jsp ... View more

CALL DEFINE is a routine specific to the COMPUTE block of PROC REPORT. As an executable function it allows the user to apply characteristics, in this case a style attribute, differentially. The first arg tells where to apply the attribute. In this case for the _ROW_. ... View more

I do not know of a way to do this directly. Certainly there are screen capture programs that could be used, but it would be a manual operation. Would not a PDF file answer just as well? It too would be scalable. ... View more

The INDSNAME SET statement option might do the trick for you. [pre] data two; set sashelp.shoes sashelp.class indsname=innames; put innames=; run; [/pre] ... View more

As INFORMATS these two are aliases of each other. ... View more

We will also need to know if you are running a batch or interactive program. ... View more

If you do not use the SELECT statement the default is everything of the given memtype. ... View more

If PRINT displays the value using TIME8. format without you specifying the format, then the format has already been attached to the variable. Format assignments are usually inherited from earlier steps. PROC CONTENTS will show the format assignments for the variables in your data set. Formats do not alter what is stored only how the value is to be displayed. ... View more

While not a cheat sheet, either Rick Aster's Professional SAS Programmers Pocket Reference http://www.amazon.com/Professional-SAS-Programmers-Pocket-Reference/dp/1891957120 or Slaughter and Delwiche's The Little SAS Book: Primer, 4th Edition https://support.sas.com/pubscat/bookdetails.jsp?pc=61860 might be helpful. ... View more