[sas-users] Fw: Need help reading in a strange text file

[matthew.e.jans at census.gov]

Glad you found the list. 

Is this Blaise audit trail data? 

-Matt

**********************************************************
The only stupid question is the one you don't ask.
**********************************************************

Matt Jans
Social Science Analyst
5K104B

Center for Survey Measurement
4600 Silver Hill Road
U. S. Census Bureau
Washington, DC  20233

Phone:  301.763.6724
FAX: 301.763.8399



From:
samantha.m.fish at census.gov
To:
sas-users at lists.census.gov
Date:
08/17/2011 09:35 AM
Subject:
[sas-users] Fw: Need help reading in a strange text file
Sent by:
sas-users-bounces at lists.census.gov



Hi all!  Can someone please help?
 
I need to read in a text file to SAS that is a format I've never worked 
with before.  Lines of data are segmented by headers, which specify what 
variables and section of our survey correspond to the data being provided. 
 Below this message is a snippet of the text file.  I substituted 
confidential data with characters I randomly typed in, which you will see 
after each ":".
 
Once this data is read into SAS it is pertinent that each header is it's 
own column in the data set so I know which string of data matches to which 
variable/section of the survey.  Any help would be much appreciated!!
 
Thanks,
Samantha
 
 
Back.BESTIM
20110302090254306367     01:afkljklmvnsdiviweergfbdfgsf
20110302090254306367     02:dskladklsfnvsiweergfbdfgsf
20110306001254380158     01:ergfbdfgsfasdflkjsadlfkjasdlf
20110306001254384308     01:asdflkjsadlfkjasdlfsdfkljsdfawerojv
20110306001254384308     02:sdfklklklklkkkkkkkkkkkkkkkkkkkkkkkk
20110312031254693445     01:aslkjsdkn,fnvliisfdiknsawer
20110312031254693641     01:sdfkljsdfawerojvsoisfklfmssdsdfklwpw
20110329095255484491     01:soisfklfmssdsdfklwpwwsiskljsfmksf
20110329189255511097     01:bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
20110334003255591192     01:ccccccccccccccccccccccccccccccccccccccc
20110334017255614161     01:ddddddddddddddddddddddddddddddddddddddd
20110339093255951505     01:lkjsdlkfjaslvnkaslkdfsalkdfjsdnsfs
20110342063256121490     01:weoriuoqnmdvklsjklsjsfhwpqldkd
20110348191256347396     01:qpsdfillsapppppppppppppppppppppppp
 
Back.CPINFO.CP1ADD1
20110312031254692763     01:qwkljafduiansddddddddddddddddddd
20110326099255306508     01:oiwuerklnvnlsdfffffffffffffffffffff
20110326099255306508     02:ggggggggggggggggsssssssssssgagsgggg
20110335039255655925     01:qowieuonklvknaklsdfjilasifopiwugh
 
Back.CPINFO.CP1EXT
20110312105254764008     01:aiouoenwklnlaksdfjsioadfhffff
20110346067256231437     01:qwoirualnviopuqrlkangpouqwrklng
 
Back.CPINFO.CP1NAME
20110334003255589518     01:qwroiunglksdfklnksfdilsfklsfdsdfd
20110334003255591086     01:qwroiusdfiouskldfnnsdfklsklfsdf
20110334003255592292     01:ufnsfndsdfyfffffffffffffff
20110334003255592292     02:ffffffffffffffffffffffffffffffff
20110334041255643804     01:weroiuiooiuwreiouklwnklnklfsklklsffs
20110336059255740006     01:iouqnkeklfsuiofsjsm,sflsiofuiosfuiosdfuio
20110336059255740006     02:weriouanlksfd890sefnwerkljavs0n 89235
20110336059255740006     03:2903785oane glkasjdfasjdf-08934nsef09usdf
20110342061256120524     01:sdddddddddddddddddddddddddddddddddddddd
20110342061256120524     02:fkjansdiof8n209384sdlkfnfsfneffffffffffffff
20110348005256281638     01:eeeeeeeeeeeeoiausdfnsdfoiuuuudsfojkaslndfuuu
20110348453256431952     01:yyyyyyyyyyyyyyyyyyyyzzzzzzzzzzzzxxxxxxxxxxxxj



Samantha Fish
Special Studies Staff
American Community Survey Office (ACSO)
U.S. Census Bureau
(301)763-7542_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/b129eeab/attachment.html>