05-03-2017
VNguyen
Calcite | Level 5
Member since
01-20-2017
- 12 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by VNguyen
Subject Views Posted 1019 04-27-2017 01:24 PM 2270 02-22-2017 09:25 AM 2285 02-21-2017 01:51 PM 2298 02-08-2017 10:26 AM 2307 02-02-2017 05:06 PM 2314 02-02-2017 04:26 PM 2322 02-02-2017 04:00 PM 2335 02-02-2017 03:06 PM 1511 01-26-2017 01:53 PM 1538 01-20-2017 04:37 PM -
Activity Feed for VNguyen
- Posted Time SAS program execution on SAS Programming. 04-27-2017 01:24 PM
- Posted Re: Mainframe SAS: error while reading cport file on SAS Programming. 02-22-2017 09:25 AM
- Posted Re: Mainframe SAS: error while reading cport file on SAS Programming. 02-21-2017 01:51 PM
- Posted Re: Mainframe SAS: error while reading cport file on SAS Programming. 02-08-2017 10:26 AM
- Posted Re: Mainframe SAS: error while reading cport file on SAS Programming. 02-02-2017 05:06 PM
- Posted Re: Mainframe SAS: error while reading cport file on SAS Programming. 02-02-2017 04:26 PM
- Posted Re: Mainframe SAS: error while reading cport file on SAS Programming. 02-02-2017 04:00 PM
- Posted Mainframe SAS: error while reading cport file on SAS Programming. 02-02-2017 03:06 PM
- Posted Re: Mainframe SAS: ERROR 180-322: Statement is not valid or it is used out of proper order. on SAS Programming. 01-26-2017 01:53 PM
- Posted Re: Mainframe SAS: ERROR 180-322: Statement is not valid or it is used out of proper order. on SAS Programming. 01-20-2017 04:37 PM
- Posted Re: Mainframe SAS: ERROR 180-322: Statement is not valid or it is used out of proper order. on SAS Programming. 01-20-2017 04:02 PM
- Posted Mainframe SAS: ERROR 180-322: Statement is not valid or it is used out of proper order. on SAS Programming. 01-20-2017 03:48 PM
04-27-2017
01:24 PM
Hello, I am writing to program to retrieve data from databases (MS SQL, MS Access, etc) using Proc SQL in Base SAS. Since I do not know if the SQL statement may take too long and ends up freezing SAS, I would like to time the excution, i.e have a piece of code directly within the program that tracks how long the query has been running and if it runs for too long (say more than a few minutes) then terminates the execution. Could you please give me some advice? Thank you, Vi
... View more
02-22-2017
09:25 AM
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
02-21-2017
01:51 PM
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
02-08-2017
10:26 AM
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
02-02-2017
05:06 PM
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
02-02-2017
04:26 PM
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
02-02-2017
04:00 PM
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
02-02-2017
03:06 PM
Hello, I created a transport file using Proc Cport and the file is stored in mainframe. I then trasfer the file to my local machine using ftp. When I tried to read the fun using proc cimport in Mainframe SAS, I ran into the following errors. Please kindly help. Thank you, Vi | 1 filename test 'C:\Users\NGUYEVE\Test.xpt';
| ERROR: Invalid file, C:\USERS\NGUYEVE\TEST.XPT.
| ERROR: Error in the FILENAME statement.
| 2 libname dest 'C:\Users\NGUYEVE';
| ERROR: Invalid physical name for library DEST.
| ERROR: Error in the LIBNAME statement.
*------------------------------------------------------------------------------
3 proc cimport infile=test library=dest;
4 run;
ERROR: Library DEST is not assigned.
... View more
01-26-2017
01:53 PM
Thank you. I believe this is the answer. Essentially I need to submit the job the right way.
... View more
01-20-2017
04:37 PM
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
01-20-2017
04:02 PM
Hello, Please see the log in the attachment. Thank you
... View more
01-20-2017
03:48 PM
Hello, I am new to SAS and have been trying to run a test code on TSO (the code below). I recevied the Error 180-322 under Lines 1 and 10 and could not find out what was wrong with them. This is quite an urgent matter and it is greatly appreciated if I can receive some help soon. 00001 //NGUYEVE1 JOB (XXXX),'XXXX',MSGCLASS=X,CLASS=E, 00002 // PRTY=3,NOTIFY=XXXX,TIME=NOLIMIT 00003 //STEP00 EXEC PAPCRMS,TYPRUN='P' 00004 //DANFILE EXEC SAS 00005 //WORK DD UNIT=(DISK,4),SPACE=(CYL,(2000,1000),RLSE) 00006 //SASAUTOS DD DSN=UCLN23.FSDU.XTRACMAC,DISP=SHR 00009 //NONP1612 DD DSN=RIRU.SONGK3.TDFS.NONPRIME.LON.V1612,DISP=SHR 00010 //SYSIN DD * 00011 DATA NONPRIME; 00012 SET NONP1612.RBVFCL; 00013 PROC PRINT DATA=NONPRIME (obs=10); 00014 RUN;
... View more