Hello, I am executing a sql query in JCL, using sas, which is running fine, but I want the output in a readable format in a dataset, so that i can extract in CSV format. I am using below JCL //$SAS9 EXEC SAS,SCL='*', // CONFIG='KLM.XYZ.LIB(SASCV2P)',WORK='500,500', // OPTIONS='MACRO,NOCENTRE' //SAVE01 DD DSN=ABC.DEF.GHI,DISP=OLD //SASLOG DD SYSOUT=* //SASLIST DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSIN DD * proc sql; connect to db2 (SSID = DB2Y); create table SAVE01.ABC as select * from connection to db2 ( SELECT ------------ ); %put sqlXRC = &sqlXRC.; %put sqlXMSG = &sqlXMSG.; disconnect from db2; quit; endsas; The output is getting generated in ABC.DEF.GHI and i can read it with TSO SAS. However if I check the same dataset in 3.4, the content is not in simple readable text format. How can i store it in readable text format and so that I can send the output as an attachment in CSV format.
... View more