Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- About BenTN
03-14-2024
BenTN
Fluorite | Level 6
Member since
11-15-2017
- 6 Posts
- 0 Likes Given
- 0 Solutions
- 1 Likes Received
-
Latest posts by BenTN
Subject Views Posted 697 03-13-2024 03:31 PM 790 03-12-2024 04:11 PM 987 03-13-2022 09:40 PM 1041 03-11-2022 06:29 PM 1043 03-11-2022 06:24 PM 1076 03-11-2022 05:22 PM -
Activity Feed for BenTN
- Posted Re: Input of a fixed width file where a single variable exists accross nonconsective variables. on SAS Programming. 03-13-2024 03:31 PM
- Posted Input of a fixed width file where a single variable exists accross nonconsective variables. on SAS Programming. 03-12-2024 04:11 PM
- Posted Re: An weirdness when trying to dynamically change device type for INFILE statement on SAS Programming. 03-13-2022 09:40 PM
- Posted Re: An weirdness when trying to dynamically change device type for INFILE statement on SAS Programming. 03-11-2022 06:29 PM
- Posted Re: An weirdness when trying to dynamically change device type for INFILE statement on SAS Programming. 03-11-2022 06:24 PM
- Got a Like for An weirdness when trying to dynamically change device type for INFILE statement. 03-11-2022 05:26 PM
- Posted An weirdness when trying to dynamically change device type for INFILE statement on SAS Programming. 03-11-2022 05:22 PM
-
My Liked Posts
Subject Likes Posted 1 03-11-2022 05:22 PM
03-13-2024
03:31 PM
Thank you. I had hoped with the versatility in the input statement of adjusting the read pointer in a lot of ways I was hoping there was a way of doing so within the read of a single variable. But its good to know there is not a way of doing so. Thank you to you and the several others who discussed other ways of addressing soundex's and dates. While the specific example I created was more to clarify the question. These comments are quite helpful as we continue to undertake this project of cleaning up our internal library of code.
... View more
03-12-2024
04:11 PM
As the name suggests I have fixed width files where a variable exists across non-consective positions. here is an example: JOHN______DOE____________0000101000312241920 First Name: John (positions 1-10) Last Name: Doe (positions 11-25) Soundex of last name: D000 (position 11, and 26-28) Date of birth: 01/01/1900 (positions 29-34, but the century comes position 41-42) Date of death: 03/12/2024 (position 35-40, but century comes from 43-44) Currently I am addressing this problem by doing something like the code below, but is there a way to get the input statement to read a single variable across nonconsecutive positions? Something like the second example. CURRENT SOLUTION DATA example;
INFILE cards;
Length FirstName $10.
LastName $15.
Soundex $4.
DOB 8.
DOD 8.;
INPUT @1 FirstName $10.
@11 LastName $15.
@26 Soundex $3.
@29 DOBMO $2.
@31 DOBDAY $2.
@41 DOBCC $2.
@33 DOBYY $2.
@35 DODMO $2.
@37 DODDAY $2.
@43 DODCC $2.
@39 DODYY $2.
;
SOUNDEX = SUBSTR(LASTNAME,1,1)||SOUNDEX;
DOB = MDY(DOBMO,DOBDAY,DOBCC||DOBYY);
DOD = MDY(DODMO,DODDAY,DODCC||DODYY);
FORMAT DOB DOD MMDDYY10.;
KEEP FIRSTNAME LASTNAME SOUNDEX DOB DOD;
DATALINES;
JOHN DOE 0000101000312241920
; AIMED FOR SOLUTION DATA example;
INFILE cards;
INPUT FirstName $ 1-10
LastName $ 11-25
Soundex $ 11, 26-28
DOB mmddyy10. 29-32,41-42,33-34
DOD mmddyy10. 35-38,43-44,39-40
;
DATALINES;
JOHN DOE 0000101000312241920
;
... View more
03-13-2022
09:40 PM
Hi Tom, When I run list in order to check for BOM against all of the relevant files, I'm not visually seeing the value (but given its nature Im not super surprised.) The added code which checks for it seems to work. So presumably that was the issue. Do programs like WinZIP or other typically append this character in zip files? Anyhoo. Thanks.
... View more
03-11-2022
06:29 PM
Oops missed one. Here is the log when I switched the names of the INFILE placeholder file reference NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26
27 DATA d_old;
28 LENGTH inputtype $1.
29 FN $500.
30 FN2 $250.;
31 INFILE DATALINES DSD delimiter='|';
32 INPUT inputtype $ FN $ FN2 $;
33
34 SELECT (inputtype);
35 WHEN ('N') INFILE foo filevar=fn memvar=fn2 LRECL=603 end=done TRUNCOVER;
36 WHEN ('Z') INFILE bar ZIP filevar=fn memvar=fn2 LRECL=603 end=done TRUNCOVER;
37 OTHERWISE;
38 END;
39
40
41 DO while (not done);
42 INPUT &datain.;
43 OUTPUT;
44 END;
45
46 DROP inputtype;
47
48 DATALINES;
ERROR: Invalid record format.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
49 N|XXXX|2011.
101 txt
inputtype=N FN=XXXX FN2=2011.txt done=0
DeathPlaceStateCode= CertNumber= DecNameLast= DecNameFirst= DecNameMI= DecNameGenID= Soundex= AliasCode= Sex= DeathDateMo=
DeathDateDay= DeathDateCC= DeathDateYY= DecSSN= DecAgeUnit= DecAgeNumber= DecAgeMonths= DecAgeDays= DecAgeHours=
DecAgeMin= DecDOBMo= DecDOBDay= DecDOBCC= DecDOBYY= DecBirthPlaceStateCountryCode= DecInfCertNumTNBirth=
2 The SAS System 14:45 Friday, March 11, 2022
DecInfCertNumOOSBirth= DeathPlaceCode= DeathPlaceType= DeathPlaceCityCode= DeathPlaceCountyCode= DecMaritalStatus=
DecResStateCode= DecRaceSexWNU= DecRaceSexWBOU= DecResCity= DecResAddress= DecResCityLimitsInd= DecResZip= ResStateInd=
DecResCountyStateCode= DecResCityCode= ResCensusTract= DecHispanicOriginCode= DecRace= DecEducationYrs= DadNameLast=
DadNameFirst= MomNameMaidenLast= MomNameFirst= FuneralHomeCode= FuneralHomeCountyAbbrev= FuneralHome= FuneralHomeAddInfo=
RegistrarRecDateMo= RegistrarRecDay= RegistrarRecDateCC= RegistrarRecDateYY= CertifierType= CertifierLicenseNum=
MedExamLicenseNum= CertifierSignDateMo= CertifierSignDateDay= CertifierSignDateCC= CertifierSignDateYY= Autopsy=
AutopsyUsedForUCD= DeathManner= WorkInjury= CODQryCode= UCD= UCDGroupCode= CODEntAxis01= CODEntAxis02= CODEntAxis03=
CODEntAxis04= CODEntAxis05= CODEntAxis06= CODEntAxis07= CODEntAxis08= CODEntAxis09= CODEntAxis10= CODEntAxis11=
CODEntAxis12= CODEntAxis13= CODEntAxis14= CODEntAxis15= CODEntAxis16= CODEntAxis17= CODEntAxis18= CODEntAxis19=
CODEntAxis20= CODRecAxis01= CODRecAxis02= CODRecAxis03= CODRecAxis04= CODRecAxis05= CODRecAxis06= CODRecAxis07=
CODRecAxis08= CODRecAxis09= CODRecAxis10= CODRecAxis11= CODRecAxis12= CODRecAxis13= CODRecAxis14= CODRecAxis15=
CODRecAxis16= CODRecAxis17= CODRecAxis18= CODRecAxis19= CODRecAxis20= SystemDateMo= SystemDateDay= SystemDateYY=
DecInArmedForces= _ERROR_=1 _N_=1
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.D_OLD may be incomplete. When this step was stopped there were 0 observations and 116 variables.
WARNING: Data set WORK.D_OLD was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.14 seconds
cpu time 0.03 seconds
... View more
03-11-2022
06:24 PM
Sure: Here is the log when I run it for a second time: NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26
27 DATA d_old;
28 LENGTH inputtype $1.
29 FN $500.
30 FN2 $250.;
31 INFILE DATALINES DSD delimiter='|';
32 INPUT inputtype $ FN $ FN2 $;
33
34 SELECT (inputtype);
35 WHEN ('N') INFILE foo filevar=fn memvar=fn2 LRECL=603 end=done TRUNCOVER;
36 WHEN ('Z') INFILE foo ZIP filevar=fn memvar=fn2 LRECL=603 end=done TRUNCOVER;
37 OTHERWISE;
38 END;
39
40
41 DO while (not done);
42 INPUT &datain.;
43 OUTPUT;
44 END;
45
46 DROP inputtype;
47
48 DATALINES;
ERROR: Invalid record format.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
49 N|XXXXX|2011.
101 txt
inputtype=N FN=XXXXX FN2=2011.txt done=0
DeathPlaceStateCode= CertNumber= DecNameLast= DecNameFirst= DecNameMI= DecNameGenID= Soundex= AliasCode= Sex= DeathDateMo=
DeathDateDay= DeathDateCC= DeathDateYY= DecSSN= DecAgeUnit= DecAgeNumber= DecAgeMonths= DecAgeDays= DecAgeHours=
DecAgeMin= DecDOBMo= DecDOBDay= DecDOBCC= DecDOBYY= DecBirthPlaceStateCountryCode= DecInfCertNumTNBirth=
DecInfCertNumOOSBirth= DeathPlaceCode= DeathPlaceType= DeathPlaceCityCode= DeathPlaceCountyCode= DecMaritalStatus=
DecResStateCode= DecRaceSexWNU= DecRaceSexWBOU= DecResCity= DecResAddress= DecResCityLimitsInd= DecResZip= ResStateInd=
DecResCountyStateCode= DecResCityCode= ResCensusTract= DecHispanicOriginCode= DecRace= DecEducationYrs= DadNameLast=
DadNameFirst= MomNameMaidenLast= MomNameFirst= FuneralHomeCode= FuneralHomeCountyAbbrev= FuneralHome= FuneralHomeAddInfo=
RegistrarRecDateMo= RegistrarRecDay= RegistrarRecDateCC= RegistrarRecDateYY= CertifierType= CertifierLicenseNum=
MedExamLicenseNum= CertifierSignDateMo= CertifierSignDateDay= CertifierSignDateCC= CertifierSignDateYY= Autopsy=
AutopsyUsedForUCD= DeathManner= WorkInjury= CODQryCode= UCD= UCDGroupCode= CODEntAxis01= CODEntAxis02= CODEntAxis03=
CODEntAxis04= CODEntAxis05= CODEntAxis06= CODEntAxis07= CODEntAxis08= CODEntAxis09= CODEntAxis10= CODEntAxis11=
CODEntAxis12= CODEntAxis13= CODEntAxis14= CODEntAxis15= CODEntAxis16= CODEntAxis17= CODEntAxis18= CODEntAxis19=
CODEntAxis20= CODRecAxis01= CODRecAxis02= CODRecAxis03= CODRecAxis04= CODRecAxis05= CODRecAxis06= CODRecAxis07=
CODRecAxis08= CODRecAxis09= CODRecAxis10= CODRecAxis11= CODRecAxis12= CODRecAxis13= CODRecAxis14= CODRecAxis15=
CODRecAxis16= CODRecAxis17= CODRecAxis18= CODRecAxis19= CODRecAxis20= SystemDateMo= SystemDateDay= SystemDateYY=
DecInArmedForces= _ERROR_=1 _N_=1
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.D_OLD may be incomplete. When this step was stopped there were 0 observations and 116 variables.
WARNING: Data set WORK.D_OLD was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.45 seconds
cpu time 0.04 seconds
Here is the log when I placed the ZIP infile ahead of the non-Zipped Infile: NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26
27
28 DATA d_old;
29 LENGTH inputtype $1.
30 FN $500.
31 FN2 $250.;
32 INFILE DATALINES DSD delimiter='|';
33 INPUT inputtype $ FN $ FN2 $;
34
35 SELECT (inputtype);
36 WHEN ('Z') INFILE foo ZIP filevar=fn memvar=fn2 LRECL=603 end=done TRUNCOVER;
37 WHEN ('N') INFILE foo filevar=fn memvar=fn2 LRECL=603 end=done TRUNCOVER;
38 OTHERWISE;
39 END;
40
41
42 DO while (not done);
43 INPUT &datain.;
44 OUTPUT;
45 END;
46
47 DROP inputtype;
48
49 DATALINES;
ERROR: Invalid record format.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
50 N|XXXXX|2011.
101 txt
inputtype=N FN=XXXXX FN2=2011.txt done=0
DeathPlaceStateCode= CertNumber= DecNameLast= DecNameFirst= DecNameMI= DecNameGenID= Soundex= AliasCode= Sex= DeathDateMo=
DeathDateDay= DeathDateCC= DeathDateYY= DecSSN= DecAgeUnit= DecAgeNumber= DecAgeMonths= DecAgeDays= DecAgeHours=
2 The SAS System 14:45 Friday, March 11, 2022
DecAgeMin= DecDOBMo= DecDOBDay= DecDOBCC= DecDOBYY= DecBirthPlaceStateCountryCode= DecInfCertNumTNBirth=
DecInfCertNumOOSBirth= DeathPlaceCode= DeathPlaceType= DeathPlaceCityCode= DeathPlaceCountyCode= DecMaritalStatus=
DecResStateCode= DecRaceSexWNU= DecRaceSexWBOU= DecResCity= DecResAddress= DecResCityLimitsInd= DecResZip= ResStateInd=
DecResCountyStateCode= DecResCityCode= ResCensusTract= DecHispanicOriginCode= DecRace= DecEducationYrs= DadNameLast=
DadNameFirst= MomNameMaidenLast= MomNameFirst= FuneralHomeCode= FuneralHomeCountyAbbrev= FuneralHome= FuneralHomeAddInfo=
RegistrarRecDateMo= RegistrarRecDay= RegistrarRecDateCC= RegistrarRecDateYY= CertifierType= CertifierLicenseNum=
MedExamLicenseNum= CertifierSignDateMo= CertifierSignDateDay= CertifierSignDateCC= CertifierSignDateYY= Autopsy=
AutopsyUsedForUCD= DeathManner= WorkInjury= CODQryCode= UCD= UCDGroupCode= CODEntAxis01= CODEntAxis02= CODEntAxis03=
CODEntAxis04= CODEntAxis05= CODEntAxis06= CODEntAxis07= CODEntAxis08= CODEntAxis09= CODEntAxis10= CODEntAxis11=
CODEntAxis12= CODEntAxis13= CODEntAxis14= CODEntAxis15= CODEntAxis16= CODEntAxis17= CODEntAxis18= CODEntAxis19=
CODEntAxis20= CODRecAxis01= CODRecAxis02= CODRecAxis03= CODRecAxis04= CODRecAxis05= CODRecAxis06= CODRecAxis07=
CODRecAxis08= CODRecAxis09= CODRecAxis10= CODRecAxis11= CODRecAxis12= CODRecAxis13= CODRecAxis14= CODRecAxis15=
CODRecAxis16= CODRecAxis17= CODRecAxis18= CODRecAxis19= CODRecAxis20= SystemDateMo= SystemDateDay= SystemDateYY=
DecInArmedForces= _ERROR_=1 _N_=1
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.D_OLD may be incomplete. When this step was stopped there were 0 observations and 116 variables.
WARNING: Data set WORK.D_OLD was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.28 seconds
cpu time 0.03 seconds Here it is when I place the ZIP files ahead of the non-zipped datalines. NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26
27 DATA d_old;
28 LENGTH inputtype $1.
29 FN $500.
30 FN2 $250.;
31 INFILE DATALINES DSD delimiter='|';
32 INPUT inputtype $ FN $ FN2 $;
33
34 SELECT (inputtype);
35 WHEN ('N') INFILE foo filevar=fn memvar=fn2 LRECL=603 end=done TRUNCOVER;
36 WHEN ('Z') INFILE foo ZIP filevar=fn memvar=fn2 LRECL=603 end=done TRUNCOVER;
37 OTHERWISE;
38 END;
39
40
41 DO while (not done);
42 INPUT &datain.;
43 OUTPUT;
44 END;
45
46 DROP inputtype;
47
48 DATALINES;
NOTE: The infile library FOO is:
Directory=N:\XXXXX\2000_2009.zip
NOTE: The infile FOO(2009.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2009.txt
NOTE: The infile FOO(2008.txt) is:
2 The SAS System 14:45 Friday, March 11, 2022
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2008.txt
NOTE: The infile FOO(2007.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2007.txt
NOTE: The infile FOO(2006.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2006.txt
NOTE: The infile FOO(2005.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2005.txt
NOTE: The infile FOO(2004.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2004.txt
NOTE: The infile FOO(2003.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2003.txt
NOTE: The infile FOO(2002.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2002.txt
NOTE: The infile FOO(2001.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2001.txt
NOTE: The infile FOO(2000.txt) is:
Filename=N:\XXXXX\2000_2009.zip,
Member Name=2000.txt
ERROR: Invalid record format.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
59 N|XXXX|2011.
101 txt
inputtype=N FN=XXXX FN2=2011.txt done=1
DeathPlaceStateCode= CertNumber= DecNameLast= DecNameFirst= DecNameMI= DecNameGenID= Soundex= AliasCode= Sex= DeathDateMo=
DeathDateDay= DeathDateCC= DeathDateYY= DecSSN= DecAgeUnit= DecAgeNumber= DecAgeMonths= DecAgeDays= DecAgeHours=
DecAgeMin= DecDOBMo= DecDOBDay= DecDOBCC= DecDOBYY= DecBirthPlaceStateCountryCode= DecInfCertNumTNBirth=
DecInfCertNumOOSBirth= DeathPlaceCode= DeathPlaceType= DeathPlaceCityCode= DeathPlaceCountyCode= DecMaritalStatus=
DecResStateCode= DecRaceSexWNU= DecRaceSexWBOU= DecResCity= DecResAddress= DecResCityLimitsInd= DecResZip= ResStateInd=
DecResCountyStateCode= DecResCityCode= ResCensusTract= DecHispanicOriginCode= DecRace= DecEducationYrs= DadNameLast=
DadNameFirst= MomNameMaidenLast= MomNameFirst= FuneralHomeCode= FuneralHomeCountyAbbrev= FuneralHome= FuneralHomeAddInfo=
RegistrarRecDateMo= RegistrarRecDay= RegistrarRecDateCC= RegistrarRecDateYY= CertifierType= CertifierLicenseNum=
MedExamLicenseNum= CertifierSignDateMo= CertifierSignDateDay= CertifierSignDateCC= CertifierSignDateYY= Autopsy=
AutopsyUsedForUCD= DeathManner= WorkInjury= CODQryCode= UCD= UCDGroupCode= CODEntAxis01= CODEntAxis02= CODEntAxis03=
CODEntAxis04= CODEntAxis05= CODEntAxis06= CODEntAxis07= CODEntAxis08= CODEntAxis09= CODEntAxis10= CODEntAxis11=
CODEntAxis12= CODEntAxis13= CODEntAxis14= CODEntAxis15= CODEntAxis16= CODEntAxis17= CODEntAxis18= CODEntAxis19=
CODEntAxis20= CODRecAxis01= CODRecAxis02= CODRecAxis03= CODRecAxis04= CODRecAxis05= CODRecAxis06= CODRecAxis07=
CODRecAxis08= CODRecAxis09= CODRecAxis10= CODRecAxis11= CODRecAxis12= CODRecAxis13= CODRecAxis14= CODRecAxis15=
CODRecAxis16= CODRecAxis17= CODRecAxis18= CODRecAxis19= CODRecAxis20= SystemDateMo= SystemDateDay= SystemDateYY=
DecInArmedForces= _ERROR_=1 _N_=11
NOTE: A total of 609274 records were read from the infile library FOO.
The minimum record length was 601.
3 The SAS System 14:45 Friday, March 11, 2022
The maximum record length was 602.
NOTE: 62147 records were read from the infile FOO(2009.txt).
The minimum record length was 602.
The maximum record length was 602.
NOTE: 62729 records were read from the infile FOO(2008.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: 61067 records were read from the infile FOO(2007.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: 60820 records were read from the infile FOO(2006.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: 61422 records were read from the infile FOO(2005.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: 59796 records were read from the infile FOO(2004.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: 61421 records were read from the infile FOO(2003.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: 60851 records were read from the infile FOO(2002.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: 59459 records were read from the infile FOO(2001.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: 59562 records were read from the infile FOO(2000.txt).
The minimum record length was 601.
The maximum record length was 601.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.D_OLD may be incomplete. When this step was stopped there were 609274 observations and 116 variables.
WARNING: Data set WORK.D_OLD was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 8.57 seconds
cpu time 3.92 seconds As side note &datain. is a macro variable detailing the 116 variables, it was been well tested to conform to the formatting of all years of the data listed here.
... View more
03-11-2022
05:22 PM
1 Like
Hi, Im not quite sure how to approach this question, because the code below works... sometimes. I guess Im trying to understand what the underlying issue\bug(?) is and if there is either a way to catch the error, or alternatively if there is an elegant way to approach this problem. Anyhoo, here is the code: DATA d;
LENGTH inputtype $1. FN $500.
FN2 $250.;
INFILE DATALINES DSD delimiter='|';
INPUT inputtype $ FN $ FN2 $;
SELECT (inputtype);
WHEN ('N') INFILE foo filevar=fn memvar=fn2 LRECL=500 end=done TRUNCOVER;
WHEN ('Z') INFILE foo ZIP filevar=fn memvar=fn2 LRECL=500 end=done TRUNCOVER;
OTHERWISE;
END;
DO while (not done);
INPUT &datain.;
OUTPUT;
END;
DROP inputtype;
DATALINES;
N|N:\...\data|2011.txt
N|N:\...\data|2010.txt
Z|N:\...\dataarchive\2000_2009.zip|2009.txt
Z|N:\...\dataarchive\2000_2009.zip|2008.txt
... Z|N:\...\dataarchive\2000_2009.zip|2000.txt
; The problem the code is trying to solve is that my group has annual data stored in fixed width text files. However, at some point the files get archived into ZIP folders. However, since the formatting has not changed I want to pull all the data in to a single data set. So I started looking for a way to change between the normal read and the ZIP read engines. Again the code above does this. -- Sometimes. But there are a lot of subtle changes, that cuase it to fail, that have no bussiness being an issue. However, if I switch the WHEN statements around so that it reads: SELECT (inputtype);
WHEN ('Z') INFILE foo ZIP filevar=fn memvar=fn2 LRECL=500 end=done TRUNCOVER;
WHEN ('N') INFILE foo filevar=fn memvar=fn2 LRECL=500 end=done TRUNCOVER;
OTHERWISE;
END; I get a ERROR: INVALID RECORD FORMAT on the first line, of the first data set. Or if I switch the data in DATALINES around so that Zip Files come before the non-ZIP files. I get an INVALID RECORD FORMAT at the start of the non-ZIP lines. Really if the ZIP device-type on INVALUE in any way comes before the non-ZIPPED version errors get thrown. The issue persists so that if I take the code that works. Then I run it a second time. I get an ERROR:INVALID RECORD FORMAT. on the first line of the data. (But if I do run it again, then it runs fine). Additionally, If I change the placeholder file refernce on one of the infile statements so I have something like: WHEN ('Z') INFILE foo ZIP filevar=fn memvar=fn2 LRECL=500 end=done TRUNCOVER;
WHEN ('N') INFILE bar filevar=fn memvar=fn2 LRECL=500 end=done TRUNCOVER;
I get the INVALID RECORD FORMAT error. Thoughts as to whats going on? Is there a way of dynamically change what read engine SAS is using that is a bit less fickle, or at least get around the error that is triggered by a rerun? Anyhoo if it helps Im running SAS 9.04.01M3 On Enterprise Guide 7.15 HF9
... View more
