Thank you. I had understood that an external file is a file that is stored outside a SAS folder (Work folder for example). Should I understand an external file instead to be any file that is not a SAS dataset?   Regards, Vi ... View more

Hello,   Updated news is that I have PC SAS now. While trying to read the sasdataset that was created by PROC CIMPORT I received errors as you can see below (lines 130-135). However, when I used the path directly within the data step (lines 136-154), SAS is able to read the file. Could you please let me know why?   Thank you, Vi   130 filename newfile 'C:\Users\NGUYEVE\nonprime.sas7bdat'; 131 132 133 data newtest; 134 infile newfile; 135 run; NOTE: The infile NEWFILE is: Filename=C:\Users\NGUYEVE\nonprime.sas7bdat, RECFM=V,LRECL=256,File Size (bytes)=609059840, Last Modified=21Feb2017:13:36:24, Create Time=21Feb2017:13:36:20 NOTE: 0 records were read from the infile NEWFILE. NOTE: The data set WORK.NEWTEST has 1 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 136 137 proc print data=newtest (obs = 10); 138 run; NOTE: No variables in data set WORK.NEWTEST. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 139 140 141 data newtest; 142 set 'C:\Users\NGUYEVE\nonprime.sas7bdat'; 143 run; NOTE: There were 557592 observations read from the data set C:\Users\NGUYEVE\nonprime.sas7bdat. NOTE: The data set WORK.NEWTEST has 557592 observations and 100 variables. NOTE: DATA statement used (Total process time): real time 1.68 seconds cpu time 1.66 seconds 144 145 proc print data=newtest (obs = 10); 146 run; NOTE: There were 10 observations read from the data set WORK.NEWTEST. NOTE: PROCEDURE PRINT used (Total process time): real time 0.07 seconds cpu time 0.04 seconds 147 148 149 data newtest; 150 set 'C:\Users\NGUYEVE\nonprime.sas7bdat'; 151 run; NOTE: There were 557592 observations read from the data set C:\Users\NGUYEVE\nonprime.sas7bdat. NOTE: The data set WORK.NEWTEST has 557592 observations and 100 variables. NOTE: DATA statement used (Total process time): real time 1.66 seconds cpu time 1.63 seconds 152 153 proc print data=newtest (obs = 100); 154 run; NOTE: There were 100 observations read from the data set WORK.NEWTEST. NOTE: PROCEDURE PRINT used (Total process time): real time 0.35 seconds cpu time 0.35 seconds     ... View more

Hello,   Thank you all for your help. My supervisor decided to take another route so for now I would not need to tackle these issues. It may come up again in the future, which then i may need to ask for help with creating xml-style excel work books on the mainframe, as I don't have PC SAS (all the searches relating to xml-style excel work books  I found use PC SAS) and the mainframe datasets I tried to extract are huge (millions of records).   Regards, Vi ... View more

Hi,   I need to extract data from mainframe and store them in Microsoft SQL Sever (the sever doesn't exist yet). However, the first thing I need to do is to see what appropriate data to extract. I thought that using SAS in TSO, I can first create a cport file (through running a batch job), transfer it to my local machine and convert it to some format that can be read in excel or something similar. Could you please let me know some better ways to do this?   Thank you, Vi ... View more

Hello,   The library C:\Users\NGUYEVE is my own local folder. I am running SAS on TSO (I do not have BASE SAS if this info is somehow relevant). Do you think the server does not see my local folder then?   Thank you, Vi ... View more

Hello,   I still received the same error. Below is the except from the job I run to create the cport file. The cported file is 'cagu.nguyeve.cport'. After that, I run the ftp on cmd.exe. ftp> binary ftp> get 'cagu.nguyeve.cport' C:\Test.xpt' //STEP00 EXEC PAPCRMS,TYPRUN='P' //DANFILE EXEC SAS //WORK DD UNIT=(DISK,4),SPACE=(CYL,(2000,1000),RLSE) //SASAUTOS DD DSN=UCLN23.FSDU.XTRACMAC,DISP=SHR //MACROS DD DSN=SSTU.SAS.MACLIB,DISP=SHR //BFILE DD DSN=BTB.P.A26,DISP=SHR //NONP1612 DD DSN=RIRU.SONGK3.TDFS.NONPRIME.LON.V1612,DISP=SHR //DS1612 DD DSN=CAGU.NGUYEVE.CPORT, // DISP=(,CATLG,DELETE),SPACE=(CYL,(2000,1500),RLSE), // UNIT=TSSU,DCB=(RECFM=FB,LRECL=80,BLKSIZE=8000) //SYSIN DD * %MACRO NP (DSIN,DSOUT); DATA NONPRIME; SET &DSIN..RBVFCL; PROC CPORT DATA=NONPRIME FILE=&DSOUT MEMTYPE=DATA; RUN; ... View more

Thank you. I believe this is the answer. Essentially I need to submit the job the right way. ... View more

Hello,   I submmitted the job in ISPF editor. I hope I copied the log correctly for you. In the case the JCL is not recognized, could it be because of the information i provided in the job card (the Account ID etc)? 1 //NGUYEVE1 JOB (XXXX),'XXXX',MSGCLASS=X,CLASS=E, -- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 2 // PRTY=3,NOTIFY=XXXX,TIME=NOLIMIT 3 //STEP00 EXEC PAPCRMS,TYPRUN='P' 4 //DANFILE EXEC SAS 5 //WORK DD UNIT=(DISK,4),SPACE=(CYL,(2000,1000),RLSE) 6 //SASAUTOS DD DSN=UCLN23.FSDU.XTRACMAC,DISP=SHR 7 //NONP1612 DD DSN=RIRU.SONGK3.TDFS.NONPRIME.LON.V1612,DISP=SHR 8 //SYSIN DD * 9 DATA NONPRIME; 10 SET NONP1612.RBVFCL; --- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 11 PROC PRINT DATA=NONPRIME (obs=10); ERROR: File WORK.NONPRIME.DATA does not exist. 12 RUN; NOTE: The SAS System stopped processing this step because of errors. NOTE: The PROCEDURE PRINT used 0.01 CPU seconds and 22181K. NOTE: The address space has used a maximum of 996K below the line and 24564K above the line. ... View more

Hello,   Please see the log in the attachment.   Thank you ... View more