@Kurt_Bremser wrote: He may have some code in the autoexec features of Enterprise Guide that causes an ERROR. (code sent when signing on, code sent before task nodes, code sent before program nodes, code in an Autoexec project flow) We use the same autoexec files so I don't know why he would get an error and I wouldn't. Thanks for the reply. ... View more

@CaseySmith wrote: I suspect the SYNTAXCHECK SAS system option is set on your colleague's server, thus when the error occurs, the SAS session goes into syntax check mode (see Overview of Syntax Check Mode), which sets OBS= option to 0, thus no records are returned.  To avoid, try setting NOSYNTAXCHECK option (ex. submit "options nosyntaxcheck;"), or fix the error that caused SAS to enter syntax check mode.   Casey We use the same server so I don't know why it would work for me and not him. We'll try this suggestion. Thanks Casey. ... View more

@Kurt_Bremser wrote: NOTE: Statement not executed due to NOEXEC option. 30 quit; That is only the last message in a chain of messages that somewere starts with an ERROR or even just a WARNING. Please post the whole log of the failing step; if this is part of a multi-node project, make sure that all nodes executed previously within the same session do so without generating a WARNING or an ERROR. 1          ;*';*";*/;quit;run; 2          OPTIONS PAGENO=MIN; 3          %LET _CLIENTTASKLABEL='Program'; 4          %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5          %LET _CLIENTPROJECTPATH=''; 6          %LET _CLIENTPROJECTNAME=''; 7          %LET _SASPROGRAMFILE=; 8          9          ODS _ALL_ CLOSE; 10         OPTIONS DEV=ACTIVEX; 11         GOPTIONS XPIXELS=0 YPIXELS=0; 12         FILENAME EGSR TEMP; 13         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 14             STYLE=HtmlBlue 15             STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SAS94/x86/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 16             NOGTITLE 17             NOGFOOTNOTE 18             GPATH=&sasworklocation 19             ENCODING=UTF8 20             options(rolap="on") 21         ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 22         23         GOPTIONS ACCESSIBLE; 24         libname data1 "/optum/csg/01datafs/dev/phi/output/auto/sas/OHCA_Dashboard/22766_32637002"; NOTE: Libref DATA1 was successfully assigned as follows:       Engine:        V9       Physical Name: /optum/csg/01datafs/dev/phi/output/auto/sas/OHCA_Dashboard/22766_32637002 25         proc sql; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 26              create table temp7 as 27              select * 28              from data1.engagement 29         ; NOTE: Statement not executed due to NOEXEC option. 30         quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds        31         32         33         GOPTIONS NOACCESSIBLE; 34         %LET _CLIENTTASKLABEL=; 35         %LET _CLIENTPROCESSFLOWNAME=; 36         %LET _CLIENTPROJECTPATH=; 37         %LET _CLIENTPROJECTNAME=; 38         %LET _SASPROGRAMFILE=; 39         40         ;*';*";*/;quit;run; 41         ODS _ALL_ CLOSE; 42         43         44         QUIT; RUN; 45           This is the error when he runs the query. There is no error when he tries to click on the data and open it. It just opens with no results. Thanks. ... View more

Because other columns in other tables in our database are in number format.   Year_month2 isn't in the format statement and it doesn't work.   I just realized that in the proc sql that follows the data step I forgot to change year_month to year_month2. It works now. Thanks a lot Reeza. ... View more

I've tried everything I can think of but I still can't get the format to a number. Here is some of what I tried.   data table2 ;      set table1;      format year_month year_month1 yymmn6.;      format new_time date9.;      new_time=datepart(dttime);      year_month=input(new_time,6.);      year_month1=input(put(new_time,yymmn6.),6.);      year_month2=input(put(new_time,yymmn6.),6.); run; ... View more

i understand what you're saying. The example you give is what I have now. I wanted to simplify it to year month. I don't really need the day. How do I do that?   ... View more