Re: Data reading Error. Help needed ASAP #2
you already define the informat and format for each variable, I don't see the reason you still need them in your input statement, after remove the informats from the input statement, it seems to read in correctly. input zip_code Client_Home_Phone Client_Date_Of_Birth ; HTH Yu On Tue, Jan 6, 2009 at 1:05 PM, cherub <cherub2life@yahoo.com> wrote: > Now I have a very weird problem,I want to import a txt data whose formate > likes this:zip_code phone_number date_of_birth109017741|8453684588|10201966 > 100246445|2125950041|05231952 I used the following code to read the data > data a;infile 'C:\Documents and Settings\Desktop\data.txt' DLM='|' dsd > missover truncover;format Zip_Code $30.Client_Home_Phone > $40.Client_Date_Of_Birth mmddyy10.;informat Zip_Code $30.Client_Home_Phone > $40.Client_Date_Of_Birth mmddyy10.;length Client_Home_Phone $40;input > zip_code $Client_Home_Phone $Client_Date_Of_Birth mmddyy10.;run; Log shows > no error, but he the first row of SAS data, the Client_Date_Of_Birth is > always missing.Just like that 109017741 8453684588 .100246445 2125950041 > 05/23/1952. Could anybody help me? Thanks very much. > > > > ...

Re: Data reading Error. Help needed ASAP #3
Hi, But which field is the one in trouble? Regards, Murphy Choy Certified Base SAS Programmer for SAS V9 Certified Advanced SAS Programmer for SAS V9 Datashaping Certified SAS Professional -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of cherub Sent: Wednesday, January 07, 2009 3:25 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Data reading Error. Help needed ASAP Now I have a very weird problem,I want to import a txt data whose formate likes this:zip_code phone_number date_of_birth109017741|8453684588|10201966 100246445|2125950041|05231952 I used the following code to read the data data a;infile 'C:\Documents and Settings\Desktop\data.txt' DLM='|' dsd missover truncover;format Zip_Code $30.Client_Home_Phone $40.Client_Date_Of_Birth mmddyy10.;informat Zip_Code $30.Client_Home_Phone $40.Client_Date_Of_Birth mmddyy10.;length Client_Home_Phone $40;input zip_code $Client_Home_Phone $Client_Date_Of_Birth mmddyy10.;run; Log shows no error, but he the first row of SAS data, the Client_Date_Of_Birth is always missing.Just like that 109017741 8453684588 .100246445 2125950041 05/23/1952. Could anybody help me? Thanks very much. ...

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: 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 ...

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 #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 o...

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 with reading ASCII data into SAS #2
> -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On > Behalf Of olivesecret@GMAIL.COM > Sent: Wednesday, November 05, 2008 8:50 AM > To: SAS-L@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 variable. > Any more suggestions? Thanks a lot! > > You will need to show us the actual code you are using to read the file if you want more than just a guess as to what went wrong. Seeing the log file with actual error message would be helpful as well. Dan Daniel J. Nordlund Washington State Department of Social and Health Services Planning, Performance, and Accountability Research and Data Analysis Division Olympia, WA 98504-5204 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...@...

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 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: Need help reading raw data file with semi colon delimiter -
It worked when I used informat and format. ...

Re: Need help reading raw data file with semi colon delimiter
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...

Re: HELP! SAS Error re: Linesize #2
Chris, Take the lesson from this sample which go over 256 positions data list; v1 =repeat('A', 260); v2 =repeat('Z', 260); run; options linesize =120; proc report data=list nowd spacing=5 ; column v1 v2; define v1 / width =30 flow "v1-----"; define v2 / width =30 flow "v2-----"; run; %let pwd=%sysfunc(pathname(WORK)); ods listing close; ods html file="&pwd\linesize.htm"; proc report data=list nowd spacing=5 ; column v1 v2; define v1 / flow "v1-----"; define v2 / flow "v2-----"; run; ods html close...

Error Code :17410 Error State :null Error Message :No more data to read from socket Stack Trace : java.sql.SQLException: No more data to read from socket
Hi, I see the following errors in the logs: Error Code :17410 Error State :null Error Message :No more data to read from socket Stack Trace : java.sql.SQLException: No more data to read from socket at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:803) at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:731) at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:690) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:372) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232) at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353) at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1807) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:332) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:376) I tried starting the DB Service and the application but did not help. Looking forward for solutions. Thanks, Divs All posts should include at least a platform, and a version, bot...

Re: Old SAS Guy needs help with some of these new fangled SAS
Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sleepless afternoons. > >I know that I can import just about any file imaginable into SAS using the import function using SAS Windows 9.1.3. >However, when trying to get comma seperated values moved all at once into the new SAS file, >I can (or only know how to get) the data for one variable moved at a time. I would like to do a mass >move of all the data from the input file into the new SAS file. Is there a way to do this? Because once > I have imported the file into a new SAS file, established variable names, established formats, informats, >variable lengths, etc. I would like to be able to save the settings for the next like file that I want to import into what I have >already slaved over doing, defining, etc., without repeating the process. > >Is there a way to do this? > >Waiting with bad breath on the sidelines. > >The Old SYS/390 guy >"SAS was originally invented for computer performance and capacity planning for the SYS/3x0 IBM machines... >they sure have taken it into new features that are amazing&...

Re: Help- How to change transaction data to individual level data in SAS
Here's more info on this very interest request... ________________________________ Bruce A. Johnson bjohnson@solucient.com -----Original Message----- From: Tulikaa Khunnah [mailto:tulikaa@yahoo.com] Sent: Tuesday, May 11, 2004 3:39 PM To: Bruce Johnson Subject: Help- How to change transaction data to individual level data in SAS Dear Bruce, I have web visit data for individuals with the duration, date, pages viewed, etc. I wanted to create one record per individual to run a logit first and then a dynamic program. I need to create a lot of lagged variables (last web portal visited -...

Re: Old SAS Guy needs help with some of these new fangled SAS #2
It's been a while since I used the Import Wizard but as I recall, there is a window which asks for a file name where SAS can store the input statments for your future use. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Jim Groeneveld <jim.1stat@YAHOO. COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Old SAS Guy needs help with some of these new fangled SAS 12/02/2008 04:49 9.1.3 gizmos for Windows AM Please respond to Jim Groeneveld <jim.1stat@YAHOO. COM> Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sl...

Re: Reading & Writing SAS data sets without SAS #3
Chang, You're correct in that a number of companies have done it. I believe SPSS can do it, WPS, Stat Transfer, dbmscopy, and perhaps others have also done it. But what I think is unique about this is that Alan is talking about offering plug-ins so you can roll-your-own so to speak. How cool would it be to have some type of driver/plugin for R? Phil Philip Rack MineQuest, LLC SAS & WPS Consulting and WPS Reseller Tel: (614) 457-3714 Web: www.MineQuest.com Blog: www.MineQuest.com/WordPress -----Original Message----- From: Chang Chung [mailto:chang_y_chung@HOTMAIL.COM] Sent: Monday...

Re: Reading SAS data sets on UNIX by non-SAS apps #2
John: Following on Richard's thoughtful suggestions, the Affinium system would likely capture data from csv files. SAS PROC EXPORT produces them quickly, and loading them into external systems works faster for relatively basic data structures and data formats, in my experience, than xml parsing. Sig -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of John Bentley Sent: Monday, October 18, 2004 10:10 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Reading SAS data sets on UNIX by non-SAS apps I have SAS data sets on AIX that we need to read with Unica's Affinium campaign management software, also on a UNIX box. (Let's not get into why we didn't go with the SAS Solution.) SAS Institute doesn't supply an ODBC driver for the UNIX environment, and the Affinium implementors don't want to use the SAS SQL Library for C and or deal with APIs. Other that dumping the SAS data sets as flat files, can anyone suggest a solution? Thanks in advance for the help. ...

Re: help reading data
The following will read the two strings of data. You would, of course, might want to use the same method, but specifically input the variables you are interested in. data want; infile cards scanover; input @"[TSW]" tswstring $20. @"[SIV]" sivstring $51.; cards; [TSW] 10D001048014D0050005 [SIV] 1158357600 16-09-06 00:00 j 60 60 180 115 0 0 BLK G [TSW] 10D001048014D0050009 [SIV] 1158357600 16-09-06 00:00 j 60 60 540 94 0 0 BLK G [TSW] 10D00104844D60200007 [SIV] 1158357600 16-09-06 00:00 j 60 60 300 101 0 0 BLK G ; run; HTH, Art ---------- On Fri, 30 Mar 200...

Re: Need help ASAP
I'd go with a proc sql solution, myself, but if I correctly understand your specs, I'd use something like: data have; input facility $ member; cards; sas 12 sad 34 ret 45 sad 56 sad 56 ; proc sql; select distinct facility,count(*) from (select distinct facility,member from have) group by facility ; quit; Art --------- On Wed, 31 Dec 2008 13:46:41 -0800, sdlenter <sdlentert@AOL.COM> wrote: >I have a dataset >facility member >sas 12 >sad 34 >ret 45 >sad 56 >sad 56 > >I need to have a list of all facilities with a count of unique members >for each: > >sas 1 >sad 2 >ret 1 >Thank you ...

Re: SAS help needed
Data Have ; Infile Cards ; Input sno dt Date9. ; Cards ; 1011 01jan2000 1012 02jan2000 1012 03jan2000 1012 04jan2000 1012 05jan2000 1012 06jan2000 1012 07jan2000 1013 03jan2000 1013 04jan2000 1013 05jan2000 1013 06jan2000 1013 07jan2000 ; Run ; Data Need ( Drop = Cnt ) ; Length NewVar $ 2 ; Set Have ; By Sno ; Retian Newvar ; If First.SNO Then Do ; Cnt + 1 ; NewVar = CatS( 'A' , Cnt ) ; End ; Run ; Proc Print Data = Need ; Format DT Date9. ; Run ; Toby Dunn If anything simply cannot go wrong, it will anyway. Murphys Law #2. The buddy system is essential to your survival;...

Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com
Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com ...

Re: Need help ASAP #4
Proc summary data=3Dfacilitymember; class facitlity member; output out=3Dwhatever sum=3D; =A0 PROC FREQ DATA=3Dwhatever; TABLES facility/NOPRINT OUT=3Dsomething (KEEP=3Dfacility COUNT); RUN; =A0 , Jay Jacob Wind <jay.wind@ATT.NET> wrote: From: Jay Jacob Wind <jay.wind@ATT.NET> Subject: Need help ASAP To: SAS-L@LISTSERV.UGA.EDU Date: Thursday, January 1, 2009, 7:40 PM > Date: Wed, 31 Dec 2008 13:46:41 -0800 > From: sdlenter > Subject: Need help ASAP > > I have a dataset > facility member > sas 12 > sad 34 > ret 45 > sad 56 > sad 56 > > I need to have a list of all facilities with a count of unique members > for each: > > sas 1 > sad 2 > ret 1 PROC FREQ DATA=3Dwhatever; TABLES facility/NOPRINT OUT=3Dsomething (KEEP=3Dfacility COUNT); RUN; -- -- Thank you -- Jay Jacob Wind =0A=0A=0A ...