Hello, I have difficulty to import the ASCII file "DRUG19Q4" (October - December 2019) from FAERS database which can be found in the link below: https://fis.fda.gov/extensions/FPD-QDE-FAERS/FPD-QDE-FAERS.html I used the code that was provided for "DEMO19Q1" ASCII file but i got some error. I would appreciate if you can help me to correct it! I used this code: data drug19q4;
infile '/folders/myfolders/sasuser.v94/DRUG19Q4.txt' dlm='$' dsd truncover firstobs=2;
input
primaryid :$10.
caseid :$8.
drug_seq
role_cod :$1.
drugname :$500.
prod_ai :$800.
val_vbm :$1.
route : $8.
dose_vbm :$3.
cum_dose_chr :$40.
cum_dose_unit :$30.
dechal :$20.
rechal :$5.
lot_num :$4.
exp_dt :$3.
nda_num :$1.
dose_amt :$3.
dose_unit :$1.
dose_form :$6.
dose_freq :$5.
;
run; and the error that i got is: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 data drug19q4;
74 infile '/folders/myfolders/sasuser.v94/DRUG19Q4.txt' dlm='$' dsd truncover firstobs=2;
75 input
76 primaryid :$10.
77 caseid :$8.
78 drug_seq
79 role_cod :$1.
80 drugname :$500.
81 prod_ai :$800.
82 val_vbm :$1.
83 route : $8.
84 dose_vbm :$3.
85 cum_dose_chr :$40.
86 cum_dose_unit :$30.
87 dechal :$20.
88 rechal :$5.
89 lot_num :$4.
90 exp_dt :$3.
91 nda_num :$1.
92 dose_amt :$3.
93 dose_unit :$1.
94 dose_form :$6.
95 dose_freq :$5.
96 ;
97 run;
NOTE: The infile '/folders/myfolders/sasuser.v94/DRUG19Q4.txt' is:
Filename=/folders/myfolders/sasuser.v94/DRUG19Q4.txt,
Owner Name=root,Group Name=vboxsf,
Access Permission=-rwxrwx---,
Last Modified=28Feb2020:17:42:18,
File Size (bytes)=162044576
ERROR: Insufficient space in file WORK.DRUG19Q4.DATA.
ERROR: File WORK.DRUG19Q4.DATA is damaged. I/O processing did not complete.
NOTE: 1452912 records were read from the infile '/folders/myfolders/sasuser.v94/DRUG19Q4.txt'.
The minimum record length was 40.
The maximum record length was 411.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DRUG19Q4 may be incomplete. When this step was stopped there were 1452912 observations and 20 variables.
WARNING: Data set WORK.DRUG19Q4 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 11.34 seconds
cpu time 6.79 seconds
98
99 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
111 Thanks a lot for your help!
... View more
