Hi,    I have a macro to create several tables. I use a Do loop to create these tables using proc sql. I need to add a proc export to the loop, such that every time it creates a table, it exports it in excel to a path:   proc sql ; select distinct month,count(distinct month) into :names1-,:c from X; quit; %macro t; proc sql; %do i =1 %to &c; create table &&names&i as select * from X where strip(month)="&&names&i"; quit; proc export data=&&names&i dbms=xlsx outfile="\\...\&&names&i..xlsx" replace; run; %end; %mend t; options mprint; %t However, proc export does not work after proc sql in macro loop. Could you please help me how to use proc export here to export each table that this loop generates? Thanks ... View more

Hi, I try to get month name from a date column (yyy-mm-dd) with the following code:   DATA WANT; SET X; names=put(Date, monname.); RUN; and the new column (names) results are: proc sql ; select distinct names from WANT; quit; However, when I run a query to get all records for each month name, it only works for only one month "September":   proc sql; select * from WANT where names="January"; quit; Surprisingly, the query returns 0 records for all months except "September" ( where names="September"). Could you please help find out why that happens and how to resolve it? Is it the issue with using "monname" format?   Thanks.   ... View more

Hi,   I need to send an email to some body about the status of the main SAS code execution, such that if any error occurs, it send an email and inform that. I used the following macro at the end of my code:   %macro send_mail; filename mymail email 'ABC@gmail.com' subject='Status'; %if &syscc>0 %then %do; data _null_; file mymail; put 'An ERROR has occurred in the code'; run; %end; %else %do; data _null_; file mymail; put 'The job ran to completion'; run; %end; %mend; %send_mail However, it sends an error email (An ERROR has occurred in the code) even when there is no error in the main body of my code. Can you please let me know why it happens and how to resolve it?   Thanks. ... View more

Hello,   I need to read a csv file using the following code:   proc import datafile='\\...\Trades.csv' out=Transactions dbms=csv replace; run;   However, I get the error saying " ERROR: Open code statement recursion detected." The first lines of log is as below:   NOTE: WORK._PRODSAVAIL data set was successfully created. NOTE: The data set WORK._PRODSAVAIL has 8 observations and 6 variables. NOTE: PROCEDURE used (Total process time): real time 0.13 seconds cpu time 0.14 seconds 44 input 45 "PK




!
!®¸yo


z


[C"N $ 46 ; 47 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 48 run; 49 50 GOPTIONS NOACCESSIBLE; ERROR: Open code statement recursion detected. 51 %LET _CLIENTTASKLABEL=; 52 %LET _CLIENTPROCESSFLOWNAME=; 53 %LET _CLIENTPROJECTPATH=; 54 %LET _CLIENTPROJECTPATHHOST=; 55 %LET _CLIENTPROJECTNAME=; 56 %LET _SASPROGRAMFILE=; 57 %LET _SASPROGRAMFILEHOST=; 58 59 ;*';*";*/;quit;run; 60 ODS _ALL_ CLOSE; 61 62 63 QUIT; RUN; 64 Could you please let me know why that happens and how to fix it. Thank you!   ... View more