f



Re: Need help reading raw data file with semi colon delimiter - #2

On Wed, 28 Mar 2007 19:40:17 -0400, Huong Halpin <huongnhalpin@YAHOO.COM> wrote:

>I have a data file with semi colon delimeter.  I used the infile statement
>as below:
>
>    infile ‘file' DLM = ';' DSD MISSOVER lrecl=206;
> input var1 $3
>  var2 3
>  var3 $8;
>
>The output shows:
>xxx ;56 7;yyyyyy
>
>It looks like the DLM = ';' was not executed.  Can anyone tell me what's
>wrong here?
>
>TIA
>Huong

I cannot explain the output because you do not show the input data or the
code used to generate the output.

I notice that you are using column style input and I am pretty sure you did
not want to do that, since it ignores delimiters.
0
nospam1405 (4666)
3/29/2007 1:13:02 AM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
308 Views

Similar Articles

[PageSpeed] 17

Reply:

Similar Artilces:

Re: Need help reading raw data file with semi colon delimiter -
It worked when I used informat and format. ...

Re: Importing data from Semi Colon delimited file
Ab, Just a suggestion: Something that I do with the Census data that I download as text files and copied SQL server results, I first import into Excel and use the Import Wizard to control delimiters and variable type (character versus numeric to keep leading zeroes). Then I use the Excel engine in a libname statement to read in the data from the Excel spreadsheet. I find this a lot easier than coding the infile/input data step or using the SAS import wizard. The big thing with using Excel like this is you can see the data as it's pasted into the tab and make fixes as needed - remove titles, mark bad cells, etc. So I'd take your log file, paste into an Excel tab, use the Import Wizard (when you paste, you're given that small pop-up option to use the text import wizard) and set it for ';' as delimiter, monitor the columns to make sure nothing is off, import. Do you have titles? It's easier to remove titles and footnotes before using SAS to read the file. Do you have variable names? If not, then you will need to assign those once the data is in SAS. Save the file. Then use a version of this SAS code: Libname logfile excel "<path>\logfile.xls" ver=2002 header=yes mixed=yes; /**Haven't tested Excel 2007 yet**/ /**Header=yes tells SAS that the first row are variable names. If you don't have variable names, then set this to Header=no or remove the option (default is 'no')**/ /**Mixed=yes tells SAS that the data for any one c...

Re: Importing data from Semi Colon delimited file #3
AB,=20 You should have noted that in your initial post. Do the files have a simple naming schema or are they randomly named :-). The import into excel won't be that useful for over 700 files, that's for sure. =20 If all the files are set up the same (same column names and structure) then you'll need to write at least one data step infile/input and loop it 700 times or so. =20 Are your variable names in some file or other? You could build a lookup table of variable names that could be used to population the input line via macro code. John Gerstle MS Applied Neuroscience, MS Applied Statistics Biostatistician Northrop Grumman CDC Information Technological Support Contract (CITS) NCHSTP \DHAP \HICSB \Research and Dissemination Team Centers for Disease Control and Prevention Phone: 404-639-3980 Fax: 404-639-2980 yzg9 at cdc dot gov=20 ________________________________ From: abshakes [mailto:ab_shakes@yahoo.com.sg]=20 Sent: Wednesday, November 26, 2008 9:57 AM To: Gerstle, John (CDC/CCID/NCHHSTP) (CTR) Subject: RE: Importing data from Semi Colon delimited file =20 Thanks John, I thought about the excel route, I use the same when files are not huge, in this case they are arround 100MBs, also there are about 700 odd files, so I was thinking if i write a script in SAS to do all the heavy lifting, I could automate the whole thing. Thanks again... "Gerstle, John (CDC/CCID/NCHHSTP) (CTR)" <yzg9@cdc.gov> wrote: Ab, Just a suggestion: Something that...

Re: Importing data from Semi Colon delimited file #4
Jane, The error suggests that the tab in the LOGFILE.xls does not have the name 'LOGFILE'. Change either the tab name in the file or change the data step (change 'logfile$'n to the name of the tab, 'tabname$'n ). Was that your question? John Gerstle MS Applied Neuroscience, MS Applied Statistics Biostatistician Northrop Grumman CDC Information Technological Support Contract (CITS) NCHSTP \DHAP \HICSB \Research and Dissemination Team Centers for Disease Control and Prevention Phone: 404-639-3980 Fax: 404-639-2980 yzg9 at cdc dot gov >>-----Original Message----- >>From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] >>On Behalf Of jane >>Sent: Wednesday, November 26, 2008 7:42 PM >>To: sas-l@uga.edu >>Subject: Re: Importing data from Semi Colon delimited file >> >>doesn't work here >> >>Libname logfile excel "e:\temp\logfile.xls" ver=2002 header=yes >>mixed=yes; >> >>Data logfile; >> Set logfile."logfile$"n ; >> >> >> Libname logfile excel "e:\temp\logfile.xls" ver=2002 header=yes >>6 mixed=yes; >>NOTE: Libref LOGFILE was successfully assigned as follows: >> Engine: EXCEL >> Physical Name: e:\temp\logfile.xls >> >>NOTE: The SAS System stopped processing this step because of errors. >>WARNING: The data set WORK.LOGFILE may be incomp...

Re: Help needed to convert text file to SAS file #3
Thanks for answering my question, that has been solved. Thanks! Nancy "Terjeson, Mark (IM&R)" <Mterjeson@russell.com> wrote: Hi, I'm not sure what all converting or parsing you want to do but here is a method of fetching the parts and pieces. If you need more help, hollar again... * read flat file varying length ; data thedata(drop=pline); length pline $2000 name_part $100 value_part $1000; infile 'c:\temp\myfile.txt' length=lenvar; input @1 pline $varying. lenvar; if pline eq '' then delete; name_part = trim(left(scan(pline,1,':'))); value...

Re: Need help with SAS Data step
Mehdi, There is no way for SAS to know when the variables begin and end if the data is both free-form and lacks a delimiter. Prior to reading the file into SAS, is it possible to save the file in some type of delimited format, e.g. comma or tab, or fixed form? What is the original source / file type of your data? If you have no way of changing your data prior to reading it into SAS, it seems you would have to read the entire observation into a single variable and then use logic to parse the data. Regards, Scott -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mehdi Satter Sent: Saturday, June 21, 2008 5:23 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Need help with SAS Data step Hello, I'm a new SAS learner. I become interested in SAS when I took a Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for statistical data analyses. Basically I'm a spinal cord injured graduate student in computer science. After taking that SAS class I started learning SAS and planning to develop my career in SAS programming. Because other computer programming languages involve writing many many lines of codes. For my physical limitation I find SAS needs only few lines of codes and makes my life little easier. Anyway, I'm always having trouble reading data at SAS data step using 'INPUT' statement. I fail to read character variables with embedded spaces. Here is a part of a data set I was using to practice SA...

Re: help read this file into a sas dataset
I think, that's quite simple, but hard to say with that example. You seem to have special delimiters from your operating system (which one? There are several on the market!). What you can do to find out what are the delimiters, try to dump a few records with: data _null_; infile "xxxxx.log"; input; list; if _n_=10 then stop; run; You will get the records in char and hex. So you can find out, what's between your records / variables. It seems that the special delimiters are not between records, but between variables. So read the whole records in a long variable or use the input- buffer _infile_, then SCAN with the found out special delimiters in that records until nothing is left and write the result in some variables of your choice. a untestetd peace of code: length var $100 c1-c11 $50; infile "xxx.log"; input; array contents(*) $ c1-c11; i=0; do until (var=" "); i+1; var=scan(_infile_,i,"34"x); c(i)=var; end; .... Gerhard On Wed, 17 Oct 2007 06:27:14 -0700, adac1121@GMAIL.COM wrote: >Input file is a systems log- was generated by the operating systems- >xxx.log > >system bootBᡲun-level 33SB᡼ >rc2s2QB᡼ >shutdown~B᭳ystem boot >B᭏run-level 33SB᭸ >rc2s2TB᭸ >rc2s2B᭲c3s3+B� >rc3s3B� >sacscIB᭴ty >oncoJBᭌOGINcoconsoleJB� >zsmonPM10LB� >OGINdtconsoleNB᭺0LOGINdtconsole >B᭺0NLOGINdtconsoleQB᭺0 > >I can't get the same data as the above input file- >my output &...

Re: help with reading ASCII data into SAS
Secret... here a start try data a; informat dd dtc dtm anydtdtm17. ; infile cards dlm=',' dsd firstobs=2; input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ; cards; "Site","ID","PID","IT","DD","ITD","RTD","LinkID","SP","FC","DTC","DTM","U" 1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 13:10:20,"obd" ; run; proc print data=a; format dd dtc dtm datetime17.; run; but the limits are the length of the variables and those types as i have only one line of data and no other specification HTH Andre olivesecret@GMAIL.COM a �crit : > I will appreciate for any suggestions. The data is a txt file. The > first two observations of the data is: > > "=Site","ID","PID","IT","DD","ITD","RTD","Lin=kID","SP","FC","DTC","DTM","U" > 1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 > =13:10:20,"obd" > > Thanks a lot! > > -- Andr� WIELKI INED (Institut National d'Etudes D�mographiques) Service Informatique 133 Boulevard Davout 75980 Paris Cedex 20 m�l : wielki@ined.fr t�l : 33 (0) 1 56 06 21 54 ...

Need help reading data from a .txt file
Hello, I am trying to average a value from a column in a .txt file I have. It has a LOT of data (values for 20 different variables every 50 ms or so for a 90 second trial) and I need to specify the time points when one of these variables should be averaged. I am interested in this value's change when a stimulus is presented and of course the stimulus is only presented at certain time frames of these 90 seconds. So basically, after I have calculated the time frames in which I'm interested, how do I let matlab know to calculate the average value of that one variable during those specif...

Re: Create SAS file from raw data
Julie: Try this: data Temp; input A $ 1-5; input Test $ 1 @@; do while (Test eq ' '); input B C:$2. D:$8. E:$5. F G H / I J:$3. K:$3. L:$3.; output; input Test $ 1 @@; end; cards; HTH J S Huang >>> "Li,Qian [Ontario]" <Qian.Li@EC.GC.CA> 12/8/2005 12:12:14 PM >>> Hi all, I have to create a SAS file from a raw data formatted as following: 60101 9.44240 O3 P CNSAPR02 12002 1 1 20020501.00000000 20020501.01000000 001 001 001 2.72953 O3 P CNSAPR02 12002 2 2 20020501.00000000 20020501.02000000 001...

Re: help needed with reading .xpt files
Yes you can. Grab the viewer here: http://www.sas.com/apps/demosdownloads/sassystemviewer_PROD_9.1.3_sysdep.jsp ?packageID=000313&jmpflag=N If you download the SAS viewer for 9.1 you can read a transport file and output the file to a CSV format. You can select "EDIT|FILTER" from the menu and output n number of records. If you want to export all of them, you will have to wrestle with how you want to split them up using notepad, Excel or some other application. I just opened a 500 record .xpt file format with the 9.1 viewer (don't use the universal viewer) and using the EDIT|FILTER menu selections wrote 100 records. Philip Rack MineQuest, LLC SAS & WPS Consulting and WPS Reseller Tel: (614) 457-3714 Web: www.MineQuest.com Blog: www.MineQuest.com/WordPress From: Roland Rashleigh-Berry [mailto:rolandberry@hotmail.com] Sent: 01/01/2009 12:09 PM To: philrack@minequest.com Subject: RE: help needed with reading .xpt files No because I am stuck with the 1500 obs limit > From: PhilRack@minequest.com > To: rolandberry@HOTMAIL.COM > Subject: RE: help needed with reading .xpt files > Date: Thu, 1 Jan 2009 11:55:01 -0500 > > Can you use the SAS Viewer to read a transport file and then output it to a > csv file? > > Philip Rack > MineQuest, LLC > SAS & WPS Consulting and WPS Reseller > Tel: (614) 457-3714 > Web: www.MineQuest.com > Blog: www.MineQuest.com/WordPress > > > -----Original Messag...

Importing data from Semi Colon delimited file
Hello, I have a huge log file which has in excess of 250 variables with varying lengths and types. The file is ";" delimited. I was wondering if there is an easier way to import the file may be through import wizard or something. Or the only option is to code it the hard way specifying input types and lengths etc? I will really appreciate your expert advice on this... Many Thanks, Ab "I am not arrogant ... only better thaaaan yyyyou !!" ...

Need some help regarding reading in data files
The DAQ software that I use exports data in a csv file. I've managed to read in the data file and have done my post-processing on it. However... There have been times where I have run DAQ sessions where there are 100,000+ samples taken and when the DAQ software exports the data, there are at least 15 columns of data. Depending on what type of post-processing I do, I only need a few columns. What I would like to be able to include in my code is: 1. For the user to select the csv that they wish to import. 2. Read in the first 10 lines of the csv and display the column headings and a fe...

Re: help with reading ASCII data into SAS #6
I'm only reposting my suggestion, with changes (suggested by Andre offline), that are obviously needed for the code to work correctly. Specifically, I had moved the formats and informats to the end of the code (so as not to change the order in the PDF) but, as a result, made then ineffective. As such, my suggested code should have read: data a; informat dd dtc dtm anydtdtm19. ; format dd dtc dtm datetime21.; informat u $10.; format u $10.; infile "data.txt" dlm=',' dsd firstobs=2 lrecl=200; input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $; run; Art -------- On Wed, 5 Nov 2008 20:38:24 -0500, Arthur Tabachneck <art297@NETSCAPE.NET> wrote: >Olive, > >Try: > >data a; > infile "data.txt" dlm=',' dsd firstobs=2 lrecl=200; > input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $; > informat dd dtc dtm anydtdtm19. ; > format dd dtc dtm datetime21.; > informat u $10.; > format u $10.; >run; > >HTH, >Art >-------- >On Wed, 5 Nov 2008 11:36:20 -0800, olivesecret@GMAIL.COM wrote: > >>I tried Andre's code, that is, do not import data from the hard disc >>by infile statement, but copy all the data directly to sas using >>datalines. You know what? Now it works. So it means there is something >>wrong when I use infile statement to import data from the hard disc. >>Any suggestions? >>Thanks a lot! >> >> &g...

Re: help with reading ASCII data into SAS #5
Olive, Try: data a; infile "data.txt" dlm=',' dsd firstobs=2 lrecl=200; input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $; informat dd dtc dtm anydtdtm19. ; format dd dtc dtm datetime21.; informat u $10.; format u $10.; run; HTH, Art -------- On Wed, 5 Nov 2008 11:36:20 -0800, olivesecret@GMAIL.COM wrote: >I tried Andre's code, that is, do not import data from the hard disc >by infile statement, but copy all the data directly to sas using >datalines. You know what? Now it works. So it means there is something >wrong when I use infile statement to import data from the hard disc. >Any suggestions? >Thanks a lot! > > > >On Nov 5, 1:57 pm, bigD <diaphanos...@gmail.com> wrote: >> Andre's code works for the example you gave .... >> >> On Nov 5, 1:20 pm, olivesec...@gmail.com wrote: >> >> > Here is my code: >> >> > data data; >> > infile 'data.txt' delimiter=',' dsd firstobs=2; >> > input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ; >> > run; >> >> > Here is one more obs: >> >> > 1,4,1004,"JS",9/27/2008 0:00:00,1,1,57,11,10,10/3/2008 >> > 11:31:17,10/3/2008= 11:31:17,"AVRC\psuggett" >> >> > Other obs are similar. >> >> > Thank you very much! >> >> > On Nov 5, 12:24 pm, Nord...@DSHS....

Re: HELP: File XX is not a sas data set
Hi, Then show us some code examples that don't work anymore, including LOG file excerpts. A .CSV file never is a SAS dataset. What exactly did you do manually? And how did you do it otherwise? You had the SAS GUI open and it hang? What detailed info did the blue screen give? Driver name, etc.? Everything is possible. On Thu, 16 Oct 2008 03:44:07 -0700, help4SASnewbie <shopaholic777@GMAIL.COM> wrote: >All, > >I have a set of codes which i've been running for many times and >haven't had any problem. The codes include importing many CSV files. >Today all of a sudden, SAS couldn't import some of the CSV file. The >message is : File XX is not a SAS data set. > >Have tried importing manually and SAS still couldn't import. > >Yesterday after a few hours of running codes, SAS hang twice, and not >long after, Windows showed blue screen saying it's cleaning memory. > >Could this errors be affected by it? > >Thanks in advance. When i mean i import it manually, i use the File , import data, and the file type is CSV. The blue screen says Windows have to shut down. And it's cleaning the memory. At that time, I was halfway running my sas codes. I thing it was still the part where it's importing these csv files. Thanks ...

Re: help with reading ASCII data into SAS #3
ok, in that case u was too short: data a; infile "c:\daten\test.dat" dlm="," truncover dsd firstobs=2; input site : 8. id : 8. pid : 8. it : $5. dd : ANYDTDTM20. itd : 8. rtd : 8. linkid : 8. sp : 8. fc : 8. dtc : ANYDTDTM20. dtm : ANYDTDTM20. u : $15. ; u = compress(u,'""'); it = compress(it,'""'); format dtm dtc dd datetime20.; run; Gerhard On Wed, 5 Nov 2008 10:20:47 -0800, olivesecret@GMAIL.COM wrote: >Here is my code: > > data data; > infile 'data.txt' delimiter=',' dsd firstobs=2; > input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ; >run; > >Here is one more obs: > >1,4,1004,"JS",9/27/2008 0:00:00,1,1,57,11,10,10/3/2008 >11:31:17,10/3/2008= 11:31:17,"AVRC\psuggett" > >Other obs are similar. > >Thank you very much! > > > >On Nov 5, 12:24 pm, Nord...@DSHS.WA.GOV ("Nordlund, Dan (DSHS/RDA)") >wrote: >> > -----Original Message----- >> > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On >> > Behalf Of olivesec...@GMAIL.COM >> > Sent: Wednesday, November 05, 2008 8:50 AM >> > To: SA...@LISTSERV.UGA.EDU >> > Subject: Re: help with reading ASCII data into SAS >> >> > Yes, I did it with delimiter=',' dsd firstobs=2, but was told invalid >> > data for each vari...

Re: Need help with SAS Data step #3
in SAS you can get all which has a structure, following certain rules. A simple rule is: all data-fields are seperated by a delimiter. That seems to be not the case at your data. Ok, also that data must have a certain structure, if you are able to read it and understand it. So the easiest way might be to ask, "how do I understand that data?" "Which rules do I follow?". Ok, one of that rules might be: I know that the country is the first word. That after the country up to the first number is the capital. That are rules you could implement in SAS. If it is more complicated, e.g. there are also countries like 'Sri Lanca' you might have a list with all that countries (like that in your head - something in your brain must tell you, that the country is not Sri and the capital is not Lanca) to get them. Gerhard On Mon, 23 Jun 2008 06:05:20 -0700, Lou <lpogoda@HOTMAIL.COM> wrote: >On Jun 21, 5:23 pm, mehdisat...@GMAIL.COM (Mehdi Satter) wrote: >> Hello, >> >> I'm a new SAS learner. I become interested in SAS when I took a >> Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for >> statistical data analyses. Basically I'm a spinal cord injured graduate >> student in computer science. After taking that SAS class I started learning >> SAS and planning to develop my career in SAS programming. Because other >> computer programming languages involve writing many many lin...

Re: Data reading Error. Help needed ASAP
Now I have a very weird problem,I want to import a txt data whose formate l= ikes this:zip_code phone_number date_of_birth109017741|8453684588|10201966 100246445|2125950041|05231952=A0I used the following code to read the data = data a;infile 'C:\Documents and Settings\Desktop\data.txt' DLM=3D'|' dsd mi= ssover truncover;format Zip_Code $30.Client_Home_Phone $40.Client_Date_Of_B= irth mmddyy10.;informat Zip_Code $30.Client_Home_Phone $40.Client_Date_Of_B= irth mmddyy10.;length Client_Home_Phone $40;input zip_code $Client_Home_Pho= ne $Client_Date_Of_Birth mmddyy10.;run;=A0Log shows no error, but he the fi= rst row of SAS data, the Client_Date_Of_Birth is always missing.Just like t= hat =A0109017741 8453684588 .100246445 2125950041 05/23/1952.=A0Could anybo= dy help me? Thanks very much.=A0=A0=A0 =0A=0A=0A ...

Re: Need help with SAS Data step #5
Summary: Make guesses and add information to check work. #iw-value=1 Mehdi, As a computer science student you must be aware that any field has to be defined in some way if one is to have an automated way to read the fields. Let's look at your worst case. > Antigua and Barbuda St. John's 65644 171 Central America 1981 Where does country end and capital begin? An English speaking human might say, "Well, the word 'and' cannot begin a capital name." You could of course build this feature into your program, but then there are probably some other examples with other words. As a computer science student you are probably aware of regular expressions, so you might take a look at the PRX functions and try to parse each line into separate fields. This probably would have the biggest payoff in your career, but since you are a beginning SAS student I have chosen to show you some of the more traditional SAS tricks. First we observe that it is easy to recognize the three number fields. The rest follows by assuming that a country name is usually one word. You will have to look up features in on line documentation or the help facility. Hopefully the comments are enough to follow the code below. You might copy it and then try executing it. data country ( drop = rest x ) check ; /* assumptions name - first word captal - everthing up to numbers population - first number area - second number ...

Re: help with reading ASCII data into SAS #4
its not much information about your problem. Did you try it with something like: data a; infile "c:\daten\test.dat" dlm="," truncover; if _n_=1 then do input; delete; end; else input site : 8. id : 8. pid : 8. it : $5. dd : ANYDTDTM20. itd : 8. rtd : 8. linkid : 8. sp : 8. fc : 8. dtc : ANYDTDTM20. dtm : ANYDTDTM20. u : $5. ; u = compress(u,'""'); it = compress(it,'""'); format dtm dtc dd datetime20.; run; That seems to work for your example. Gerhard On Wed, 5 Nov 2008 07:45:07 -0800, olivesecret@GMAIL.COM wrote: >I will appreciate for any suggestions. The data is a txt file. The >first two observations of the data is: > >"=Site","ID","PID","IT","DD","ITD","RTD","Lin=kID","SP","FC","DTC","DTM"," U" >1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 >=13:10:20,"obd" > >Thanks a lot! ...

Re: Help plz... Reading dates from raw files
Data One ; infile Cards ; Input Date DDMMYY10. ; Cards ; 26/09/2005 31/12/2005 ; Run ; Proc Print Data = One ; Format Date Date9. ; Run ; Toby Dunn To sensible men, every day is a day of reckoning. ~John W. Gardner The important thing is this: To be able at any moment to sacrifice that which we are for what we could become. ~Charles DuBois Don't get your knickers in a knot. Nothing is solved and it just makes you walk funny. ~Kathryn Carpenter From: Alex S <alex4sas@YAHOO.CO.IN> Reply-To: Alex S <alex4sas@YAHOO.CO.IN> To: SAS-L@LISTSERV.UGA.EDU Subject: Help plz... Reading dates from raw files Date: Mon, 18 Dec 2006 00:21:30 +0000 26/09/2005 31/12/2005 _________________________________________________________________ Share your latest news with your friends with the Windows Live Spaces friends module. http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mk ...

Re: Need help with SAS Data step #4
Thank you all for being so nice and helpful. Have a good one. -Mehdi On Mon, Jun 23, 2008 at 9:29 AM, Gerhard Hellriegel < gerhard.hellriegel@t-online.de> wrote: > in SAS you can get all which has a structure, following certain rules. A > simple rule is: all data-fields are seperated by a delimiter. > That seems to be not the case at your data. Ok, also that data must have a > certain structure, if you are able to read it and understand it. So the > easiest way might be to ask, "how do I understand that data?" "Which rules > do I follow?". > Ok, one of that rules might be: I know that the country is the first word. > That after the country up to the first number is the capital. That are > rules you could implement in SAS. > If it is more complicated, e.g. there are also countries like 'Sri Lanca' > you might have a list with all that countries (like that in your head - > something in your brain must tell you, that the country is not Sri and the > capital is not Lanca) to get them. > Gerhard > > > > > On Mon, 23 Jun 2008 06:05:20 -0700, Lou <lpogoda@HOTMAIL.COM> wrote: > > >On Jun 21, 5:23 pm, mehdisat...@GMAIL.COM (Mehdi Satter) wrote: > >> Hello, > >> > >> I'm a new SAS learner. I become interested in SAS when I took a > >> Biostatistics class. Then I took a SAS/Stat class and learned how to > SAS for > >> statistical...

Re: reading in txt file to sas data set
On Mon, 6 Dec 2004 16:33:59 -0800, bw <bcwache@GMAIL.COM> wrote: >Hi, All. > >I'm trying to read in a .txt file that is structured like this: > >Az: .0000 12.00 24.00 >CEA >.00 .4645 1.742 15 >90. .4052 1.035 16 >CIE >.00 .0000 .2742 26 >.90 .0000 .2576 27 > >I'd like the resulting sas data set to have 4 variables and 6 >observations like this: > >az in CEA CIE >.0000 .00 .4645 .0000 >12.00 .00 1.742 .2742 >24.00 .00 15 26 >.0000 90. .4052 .0000 >12.00 90. 1.035 .2576 >24.00 ...

Need help to read/write tab-delimited files
Currently we are running RD AP-PRO 6.0 and PIC-LAN 2.0.0.36 and I am using the PLDOS-IMPORT and PLDOS-EXPORT commands to import and export flat, tab-delimited files from the PICK box to a Novell server using a DOS Services Gateway. We are looking into the possibility of converting over to Universe 10.0 running on RedHat 8.0 Linux operating system. Question: How do I go about reading and writing these flat tab files from Universe to Novell and back again? Any help would be greatly appreciated. -- Posted via http://dbforums.com You need a program. There are no built in utilities to do that. I recommend hiring a competent programmer who is familiar with AP and Universe to review your file layouts and write conversion programs for you. -- Jeffrey Kaufman Key Data Systems Group www.keydata.us 559-432-3832 559-432-4657 fax Western Pacific Supply www.westpacsupply.com 888-WestPac "polkster13" <member35818@dbforums.com> wrote in message news:3348827.1063129070@dbforums.com... > > Currently we are running RD AP-PRO 6.0 and PIC-LAN 2.0.0.36 and I am > using the PLDOS-IMPORT and PLDOS-EXPORT commands to import and export > flat, tab-delimited files from the PICK box to a Novell server using a > DOS Services Gateway. > > > > We are looking into the possibility of converting over to Universe 10.0 > running on RedHat 8.0 Linux operating system. > > > > Questio...

Web resources about - Re: Need help reading raw data file with semi colon delimiter - #2 - comp.soft-sys.sas

Delimiter - Wikipedia, the free encyclopedia
An example of a delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values . Delimiters represent ...

Cancel - Delimiter
news A number of commentators and politicians have questioned a claim by Shadow Communications Minister Malcolm Turnbull that the Coalition would ...


End of the dot com winter: How Australia's tech startup scene bloomed again - Delimiter 2.0 End of the ...
The long winter after the failure of the dot com boom a decade ago is finally over: Australia's startup spring is here, and its energy is infectious. ...

Abc - Delimiter
[ad] Ever wondered what technology underpins Watson, the artificial intelligence system that IBM built to conquer the Jeopardy quiz show? Click ...

Jenneth Orantia - Delimiter
[ad] Ever wondered what technology underpins Watson, the artificial intelligence system that IBM built to conquer the Jeopardy quiz show? Click ...

Display - Delimiter
[ad] Ever wondered what technology underpins Watson, the artificial intelligence system that IBM built to conquer the Jeopardy quiz show? Click ...

Coalition - Delimiter
[ad] Ever wondered what technology underpins Watson, the artificial intelligence system that IBM built to conquer the Jeopardy quiz show? Click ...

Joe Hockey - Delimiter
[ad] Ever wondered what technology underpins Watson, the artificial intelligence system that IBM built to conquer the Jeopardy quiz show? Click ...

Asus - Delimiter
[ad] Ever wondered what technology underpins Watson, the artificial intelligence system that IBM built to conquer the Jeopardy quiz show? Click ...

Resources last updated: 3/18/2016 2:11:47 AM