topic Re: blank records in my output table in SAS Programming

blank records in my output table

Rixile106 — Wed, 22 Sep 2021 18:01:06 GMT

Good day expects.

i am a beginner when it comes to SAS.

i have copied a dataset from one library to the other using the below script.

PROC COPY IN=VNC OUT=WORK;

SELECT ACT30;

RUN;



proc export data=work.ACT30
outfile="/SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/09_Flat_Files/ACT30"
dbms=tab;
run;

again i create infile name because of the global variable:

filename ACT30 "/SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/09_Flat_Files/ACT30"
RECFM=F;
RUN;

then i do the import


data I_SOURCE.ACT30 (Drop = BMST_HD_REC_TYPE BMST_HD_XTRACT_TIMESTAMP BMST_HD_COPYBOOK BMST_TR_REC_TYPE BMST_TR_REC_CNT)
I_SOURCE.ACT30_HD_FT
I_SOURCE.ACT30_ECT (keep=REFACT_ACCT_NO)
I_SOURCE.ACT30_HEADER (keep= BMST_HD_REC_TYPE BMST_HD_XTRACT_TIMESTAMP BMST_HD_COPYBOOK)
I_SOURCE.ACT30_TRAILER (keep= BMST_TR_REC_TYPE BMST_TR_REC_CNT)
;
INFILE ACT30 PAD MISSOVER LRECL=40 END=LAST;
input
@1 BMST_HD_REC_TYPE $EBCDIC3.
@4 BMST_HD_XTRACT_TIMESTAMP $EBCDIC26.
@30 BMST_HD_COPYBOOK $EBCDIC8.@@
;

if BMST_HD_REC_TYPE = "HDR" then
output I_SOURCE.ACT30_HEADER;
input
@1 BMST_TR_REC_TYPE $EBCDIC3.
@4 BMST_TR_REC_CNT S370FZD9.0@@

;

if BMST_TR_REC_TYPE = "TRL" then
output I_SOURCE.ACT30_TRAILER;
INPUT
@1 REFACT_ACCT_NO S370FF12.
;

if not last and _n_ > 1 then
output I_SOURCE.ACT30 I_SOURCE.ACT30_HD_FT I_SOURCE.ACT30_ECT;
RUN;

my output shows that there are no records in my column

Re: blank records in my output table

Reeza — Wed, 22 Sep 2021 18:05:07 GMT

FYI please use code blocks, not spoilers and especially do not nest spoilers in your posts.
I tried to fix it for you but if something is missing you'll need to update it.

Please post your log from the code.

Also, you exported a tab delimited file and are trying to read it as fixed width file with positions? I'm not sure that makes logical sense? Wouldn't you be reading it back by specifying the variables, types and the TAB as the delimiter?

Re: blank records in my output table

Rixile106 — Wed, 22 Sep 2021 18:15:58 GMT

1 The SAS System 18:47 Wednesday, September 22, 2021

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='IMPORT_SOURCE_ACT30';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET
8 ! _SASPROGRAMFILE='C:\Users\a209457\AppData\Local\Temp\1\scp13642\SAS\data\RiskDataManagement\data\NWOW\data\VBM\BRACC\03_S
8 ! cripts\Import_Migration\IMPORT_SOURCE_ACT30.sas';
9 %LET _SASPROGRAMFILEHOST='LSBSA-4HDVQ73';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGSR TEMP;
15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16 STYLE=HtmlBlue
17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
18 NOGTITLE
19 NOGFOOTNOTE
20 GPATH=&sasworklocation
21 ENCODING=UTF8
22 options(rolap="on")
23 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26
27 ****************************************************************************************
28 01. CREATING INFILE NAME BECAUSE OF GLOBAL VARIABLE
29 ****************************************************************************************/;
30 filename ACT30 "/SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/09_Flat_Files/ACT30"
31 RECFM=F;
32 RUN;
33
34 ****************************************************************************************
35 02. IMPORT OF EBCDIC FILE & FORMATING ACCOUNT NUMBER
36 ****************************************************************************************/;

37 data I_SOURCE.ACT30 (Drop = BMST_HD_REC_TYPE BMST_HD_XTRACT_TIMESTAMP BMST_HD_COPYBOOK BMST_TR_REC_TYPE BMST_TR_REC_CNT)
38 I_SOURCE.ACT30_HD_FT
39 I_SOURCE.ACT30_ECT (keep=REFACT_ACCT_NO)
40 I_SOURCE.ACT30_HEADER (keep= BMST_HD_REC_TYPE BMST_HD_XTRACT_TIMESTAMP BMST_HD_COPYBOOK)
41 I_SOURCE.ACT30_TRAILER (keep= BMST_TR_REC_TYPE BMST_TR_REC_CNT)
42 ;
43 INFILE ACT30 PAD MISSOVER LRECL=40 END=LAST;
44 input
45 @1 BMST_HD_REC_TYPE $EBCDIC3.
46 @4 BMST_HD_XTRACT_TIMESTAMP $EBCDIC26.
47 @30 BMST_HD_COPYBOOK $EBCDIC8.@@
48 ;
49
50 if BMST_HD_REC_TYPE = "HDR" then
51 output I_SOURCE.ACT30_HEADER;
52 input
53 @1 BMST_TR_REC_TYPE $EBCDIC3.
2 The SAS System 18:47 Wednesday, September 22, 2021

54 @4 BMST_TR_REC_CNT S370FZD9.0@@
55
56 ;
57
58 if BMST_TR_REC_TYPE = "TRL" then
59 output I_SOURCE.ACT30_TRAILER;
60 INPUT
61 @1 REFACT_ACCT_NO S370FF12.
62 ;
63
64 if not last and _n_ > 1 then
65 output I_SOURCE.ACT30 I_SOURCE.ACT30_HD_FT I_SOURCE.ACT30_ECT;
66 RUN;

NOTE: Data file I_SOURCE.ACT30.DATA is in a format that is native to another host, or the file encoding does not match the session
encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
NOTE: Compression was disabled for data set I_SOURCE.ACT30 because compression overhead would increase the size of the data set.
NOTE: Data file I_SOURCE.ACT30_ECT.DATA is in a format that is native to another host, or the file encoding does not match the
session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
NOTE: Compression was disabled for data set I_SOURCE.ACT30_ECT because compression overhead would increase the size of the data set.
NOTE: Data file I_SOURCE.ACT30_HEADER.DATA is in a format that is native to another host, or the file encoding does not match the
session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
NOTE: Data file I_SOURCE.ACT30_TRAILER.DATA is in a format that is native to another host, or the file encoding does not match the
session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
NOTE: Compression was disabled for data set I_SOURCE.ACT30_TRAILER because compression overhead would increase the size of the data
set.
NOTE: The infile ACT30 is:
Filename=/SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/09_Flat_Files/ACT30,
Owner Name=sa000846,Group Name=cfy-za-rdmrw,
Access Permission=-rw-rw-rw-,
Last Modified=22 September 2021 20:11:20,
File Size (bytes)=607476

NOTE: Invalid data for BMST_TR_REC_CNT in line 1 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 1 1-12.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

1 CHAR REFACT_ACCT_NO.86000.256000.302000.57400
ZONE 5444455444554403333303333330333333033333
NUMR 256134F1334FEFA86000A256000A302000A57400
LAST=0 BMST_HD_REC_TYPE=êáã BMST_HD_XTRACT_TIMESTAMP= äè^ ääè^+|Ž˜–Ž•–Ž“ BMST_HD_COPYBOOK=Ž• BMST_TR_REC_TYPE=êáã
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=1
NOTE: Invalid data for BMST_TR_REC_CNT in line 2 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 2 1-12.

2 CHAR 0.582000.639000.663000.701000.744000.779
ZONE 3033333303333330333333033333303333330333
NUMR 0A582000A639000A663000A701000A744000A779
LAST=0 BMST_HD_REC_TYPE=Ž• BMST_HD_XTRACT_TIMESTAMP=˜Ž–“™Ž––“Ž‘ BMST_HD_COPYBOOK=Ž””Ž BMST_TR_REC_TYPE=Ž•
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=2
NOTE: Invalid data for BMST_TR_REC_CNT in line 3 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 3 1-12.
3 The SAS System 18:47 Wednesday, September 22, 2021

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

3 CHAR 000.1058000.1074000.1090000.1171000.1236
ZONE 3330333333303333333033333330333333303333
NUMR 000A1058000A1074000A1090000A1171000A1236
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž‘•˜Ž‘”Ž‘™Ž‘ BMST_HD_COPYBOOK=‘‘Ž‘ BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=3
NOTE: Invalid data for BMST_TR_REC_CNT in line 4 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 4 1-12.

4 CHAR 000.1252000.1279000.1333000.1406000.1414
ZONE 3330333333303333333033333330333333303333
NUMR 000A1252000A1279000A1333000A1406000A1414
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž‘•Ž‘™Ž‘“““Ž‘ BMST_HD_COPYBOOK=”–Ž‘ BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=4
NOTE: Invalid data for BMST_TR_REC_CNT in line 5 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 5 1-12.

5 CHAR 000.1465000.1473000.1589000.1678000.1732
ZONE 3330333333303333333033333330333333303333
NUMR 000A1465000A1473000A1589000A1678000A1732
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž‘”–•Ž‘”“Ž‘•˜™Ž‘ BMST_HD_COPYBOOK=–˜Ž‘ BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=5
NOTE: Invalid data for BMST_TR_REC_CNT in line 6 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 6 1-12.

6 CHAR 000.1740000.1759000.1783000.1791000.1848
ZONE 3330333333303333333033333330333333303333
NUMR 000A1740000A1759000A1783000A1791000A1848
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž‘”Ž‘•™Ž‘˜“Ž‘ BMST_HD_COPYBOOK=™‘Ž‘ BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=6
NOTE: Invalid data for BMST_TR_REC_CNT in line 7 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 7 1-12.

7 CHAR 000.2003000.2089000.2291000.2410000.2453
ZONE 3330333333303333333033333330333333303333
NUMR 000A2003000A2089000A2291000A2410000A2453
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž“Ž˜™Ž™‘Ž BMST_HD_COPYBOOK=”‘Ž BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=7
NOTE: Invalid data for BMST_TR_REC_CNT in line 8 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 8 1-12.

8 CHAR 000.2461000.2623000.2712000.2755000.2771
ZONE 3330333333303333333033333330333333303333
NUMR 000A2461000A2623000A2712000A2755000A2771
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž”–‘Ž–“Ž‘Ž BMST_HD_COPYBOOK=••Ž BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=8
NOTE: Invalid data for BMST_TR_REC_CNT in line 9 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 9 1-12.

9 CHAR 000.2836000.2844000.2925000.2976000.3050
ZONE 3330333333303333333033333330333333303333
NUMR 000A2836000A2844000A2925000A2976000A3050
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž˜“–Ž˜””Ž™•Ž BMST_HD_COPYBOOK=™–Ž“ BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=9
NOTE: Invalid data for BMST_TR_REC_CNT in line 10 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 10 1-12.
4 The SAS System 18:47 Wednesday, September 22, 2021

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

10 CHAR 000.3220000.3379000.3441000.3468000.3530
ZONE 3330333333303333333033333330333333303333
NUMR 000A3220000A3379000A3441000A3468000A3530
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž“Ž““™Ž“””‘Ž“ BMST_HD_COPYBOOK=”–˜Ž“ BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=10
NOTE: Invalid data for BMST_TR_REC_CNT in line 11 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 11 1-12.

11 CHAR 000.3638000.3700000.3816000.3956000.4006
ZONE 3330333333303333333033333330333333303333
NUMR 000A3638000A3700000A3816000A3956000A4006
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž“–“˜Ž“Ž“˜‘–Ž“ BMST_HD_COPYBOOK=™•–Ž” BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=11
NOTE: Invalid data for BMST_TR_REC_CNT in line 12 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 12 1-12.

12 CHAR 000.4154000.4219000.4243000.4251000.4294
ZONE 3330333333303333333033333330333333303333
NUMR 000A4154000A4219000A4243000A4251000A4294
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž”‘•”Ž”‘™Ž””“Ž” BMST_HD_COPYBOOK=•‘Ž” BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=12
NOTE: Invalid data for BMST_TR_REC_CNT in line 13 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 13 1-12.

13 CHAR 000.4383000.4545000.4588000.4650000.4871
ZONE 3330333333303333333033333330333333303333
NUMR 000A4383000A4545000A4588000A4650000A4871
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž”“˜“Ž”•”•Ž”•˜˜Ž” BMST_HD_COPYBOOK=–•Ž” BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=13
NOTE: Invalid data for BMST_TR_REC_CNT in line 14 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 14 1-12.

14 CHAR 000.4936000.5002000.5010000.5029000.5053
ZONE 3330333333303333333033333330333333303333
NUMR 000A4936000A5002000A5010000A5029000A5053
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž”™“–Ž•Ž•‘Ž• BMST_HD_COPYBOOK=™Ž• BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=14
NOTE: Invalid data for BMST_TR_REC_CNT in line 15 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 15 1-12.

15 CHAR 000.5061000.5088000.5096000.5169000.5312
ZONE 3330333333303333333033333330333333303333
NUMR 000A5061000A5088000A5096000A5169000A5312
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž•–‘Ž•˜˜Ž•™–Ž• BMST_HD_COPYBOOK=‘–™Ž• BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=15
NOTE: Invalid data for BMST_TR_REC_CNT in line 16 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 16 1-12.

16 CHAR 000.5339000.5355000.5363000.5398000.5428
ZONE 3330333333303333333033333330333333303333
NUMR 000A5339000A5355000A5363000A5398000A5428
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž•““™Ž•“••Ž•“–“Ž• BMST_HD_COPYBOOK=“™˜Ž• BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=16
NOTE: Invalid data for BMST_TR_REC_CNT in line 17 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 17 1-12.
5 The SAS System 18:47 Wednesday, September 22, 2021

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

17 CHAR 000.5436000.5479000.5541000.5746000.5819
ZONE 3330333333303333333033333330333333303333
NUMR 000A5436000A5479000A5541000A5746000A5819
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž•”“–Ž•”™Ž••”‘Ž• BMST_HD_COPYBOOK=”–Ž• BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=17
NOTE: Invalid data for BMST_TR_REC_CNT in line 18 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 18 1-12.

18 CHAR 000.5886000.5916000.5940000.5991000.6009
ZONE 3330333333303333333033333330333333303333
NUMR 000A5886000A5916000A5940000A5991000A6009
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž•˜˜–Ž•™‘–Ž•™”Ž• BMST_HD_COPYBOOK=™™‘Ž– BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=18
NOTE: Invalid data for BMST_TR_REC_CNT in line 19 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 19 1-12.

19 CHAR 000.6017000.6041000.6076000.6122000.6270
ZONE 3330333333303333333033333330333333303333
NUMR 000A6017000A6041000A6076000A6122000A6270
LAST=0 BMST_HD_REC_TYPE= BMST_HD_XTRACT_TIMESTAMP=Ž–‘Ž–”‘Ž––Ž– BMST_HD_COPYBOOK=‘Ž– BMST_TR_REC_TYPE=
BMST_TR_REC_CNT=. REFACT_ACCT_NO=. _ERROR_=1 _N_=19
NOTE: Invalid data for BMST_TR_REC_CNT in line 20 4-12.
NOTE: Invalid data for REFACT_ACCT_NO in line 20 1-12.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

NOTE: DATA statement used (Total process time):
real time 0.08 seconds
user cpu time 0.05 seconds
system cpu time 0.02 seconds
memory 3785.18k
OS Memory 34216.00k
Timestamp 2021/09/22 08:14:24 PM
Step Count 50 Switch Count 10
Page Faults 0
Page Reclaims 531
Page Swaps 0
Voluntary Context Switches 136
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 0

67
68 GOPTIONS NOACCESSIBLE;
69 %LET _CLIENTTASKLABEL=;
70 %LET _CLIENTPROCESSFLOWNAME=;
71 %LET _CLIENTPROJECTPATH=;
72 %LET _CLIENTPROJECTPATHHOST=;
73 %LET _CLIENTPROJECTNAME=;
74 %LET _SASPROGRAMFILE=;
75 %LET _SASPROGRAMFILEHOST=;
76
77 ;*';*";*/;quit;run;
78 ODS _ALL_ CLOSE;
79
80
81 QUIT; RUN;
82

Re: blank records in my output table

Tom — Wed, 22 Sep 2021 18:20:52 GMT

Your first two steps are making a TAB delimited text file with contents of the VNC.ACT30 dataset.

You then try to read the tab delimited file as if it was a fixed length record file with fixed width fields on each record.

That does not make any sense.

What is it you are trying to do?

Are you starting with a SAS dataset or a text file?

Are you trying to create a text file or a SAS dataset?

Perhaps you are having a trouble with the terms here? I see you are trying to read EBCDIC character strings? On the IBM mainframes people used to refer to text files as "datasets". But such a file has nothing to do with a SAS dataset.

Re: blank records in my output table

Rixile106 — Wed, 22 Sep 2021 18:24:35 GMT

am starting with a text file then create sas dataset

Re: blank records in my output table

Reeza — Wed, 22 Sep 2021 18:45:47 GMT

So your first steps are then unnecessary. You can move your file using the Explorer pane or via FCOPY but not via PROC COPY. What did the log show for that step?

You would then start at your second step of reading in the file. I would also test this step by step to ensure each step works before trying to do it all at once.

Re: blank records in my output table

Tom — Wed, 22 Sep 2021 18:47:34 GMT

So make sure not to run the PROC EXPORT code that was WRITING to a file.

What are the issues with reading the text file?

Did you check if the file actually has the structure you expected?

For example to just get a look at some of the records in the text file you can use the LIST statement.

For example to look at the first 400 bytes (10 records of 40 bytes each) you could run this step.

filename ACT30 "/SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/09_Flat_Files/ACT30";

data _null_;
  infile ACT30 recfm=f lrecl=40 obs=10;
  input;
  list;
run;

Re: blank records in my output table

Rixile106 — Wed, 22 Sep 2021 20:35:46 GMT

I tried using the FCOPY statement and am not winning, see below script and the log. please bear with me am still new in SAS

%LET PATH = /SAS/data/VnC/data/BR6M_SE/05_ME/02_ACTIVATION/01_ETL/01_IMPORT_SOURCE/;
%LET ACT_FILE = ACT30;

data _null_;
	call symput("ACT_DIRECT",compress("&PATH"||"&ACT_FILE."));
run;

%LET PATH = /SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/09_Flat_Files/;
%LET ACTT_FILE = ACT301;

data _null_;
	call symput("ACTT_DIRECT",compress("&PATH"||"&ACTT_FILE."));
run;


filename &ACT_FILE "&PATH" recfm=n;
filename &ACTT_FILE "&PATH" recfm=n;
%let rc = %sysfunc(FCOPY(&ACT_FILE.,&ACTT_FILE.));
%put %sysfunc(SYSMSG());

1                                                          The SAS System                        18:47 Wednesday, September 22, 2021

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Program (2)';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='';
9          %LET _SASPROGRAMFILEHOST='';
10         
11         ODS _ALL_ CLOSE;
12         OPTIONS DEV=PNG;
13         GOPTIONS XPIXELS=0 YPIXELS=0;
14         FILENAME EGSR TEMP;
15         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16             STYLE=HtmlBlue
17             STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
18             NOGTITLE
19             NOGFOOTNOTE
20             GPATH=&sasworklocation
21             ENCODING=UTF8
22             options(rolap="on")
23         ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24         
25         GOPTIONS ACCESSIBLE;
26         filename &ACT_FILE "&PATH" recfm=n;
27         filename &ACTT_FILE "&PATH" recfm=n;
28         %let rc = %sysfunc(FCOPY(&ACT_FILE.,&ACTT_FILE.));
29         %put %sysfunc(SYSMSG());
ERROR: Invalid file, /SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/09_Flat_Files.
30         
31         GOPTIONS NOACCESSIBLE;
32         %LET _CLIENTTASKLABEL=;
33         %LET _CLIENTPROCESSFLOWNAME=;
34         %LET _CLIENTPROJECTPATH=;
35         %LET _CLIENTPROJECTPATHHOST=;
36         %LET _CLIENTPROJECTNAME=;
37         %LET _SASPROGRAMFILE=;
38         %LET _SASPROGRAMFILEHOST=;
39         
40         ;*';*";*/;quit;run;
41         ODS _ALL_ CLOSE;
42         
43         
44         QUIT; RUN;
45

Re: blank records in my output table

Kurt_Bremser — Thu, 23 Sep 2021 04:27:58 GMT

FCOPY works on individual files, not on directories. It looks to me that your &path contains only a directory.