Hello, I have done a simple Mainframe SAS programm which reads an input file, runs a proc sql procedure and I want my results to be written to a dataset, but I don't know how to put my proc sql results to a dataset. Here is my SAS code: //GO EXEC SAS,WORK='1000,500' //SASLIST DD SYSOUT=* //ENTRE1 DD DISP=SHR,DSN=PE5A.MFFFF001.S231020G(0) //SORTIE DD DSN=UE5A.MFFFF001.COUNT.IV, // UNIT=SYSALLDA,DISP=(,CATLG,DELETE), // DCB=(DSORG=PS,RECFM=FB,LRECL=100,BLKSIZE=0), // SPACE=(CYL,(1,10),RLSE) //SSAVE DD * //SYSIN DD * DATA IV; INFILE ENTRE1; INPUT @056 SDU $CHAR2. @085 SYS_EMET $CHAR2. @149 ANNE_RECEP 4. @153 MOIS_RECEP 2. @279 IND_ASSOC $CHAR1.; RUN; PROC SQL; CREATE TABLE IV_PREP AS SELECT SDU, SYS_EMET, CASE WHEN MOIS_RECEP <= 3 THEN ANNE_RECEP - 1 ELSE ANNE_RECEP END AS EXERCICE, IND_ASSOC FROM IV ; QUIT; PROC SQL; SELECT EXERCICE, SDU, COUNT(SDU) AS QTT_SDU_EXE FROM IV_PREP GROUP BY EXERCICE , SDU ; QUIT; /* // Thank you
... View more