f



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
0
NordlDJ (920)
11/5/2008 5:24:33 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

3 Replies
552 Views

Similar Articles

[PageSpeed] 53

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

0
11/5/2008 6:20:47 PM
Andre's code works for the example you gave ....



On Nov 5, 1:20=A0pm, olivesec...@gmail.com wrote:
> Here is my code:
>
> =A0 =A0data data;
> =A0 =A0 infile 'data.txt' delimiter=3D',' dsd firstobs=3D2;
> =A0 =A0 =A0input 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=3D 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=3D',' dsd firstobs=3D2, but was told inv=
alid
> > > 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. =A0Seeing the lo=
g 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 =A098504-5204- Hide quoted text -
>
> - Show quoted text -

0
11/5/2008 6:57:27 PM
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.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 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- Hide quoted text -
>
> > - Show quoted text -

0
11/5/2008 7:36:20 PM
Reply:

Similar Artilces:

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: 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 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 #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: 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: Deleting SAS Data from a SAS DATASET #2
Chandra - this isn't my expertise area - I'm sure others may have better ideas but I'll make three comments. If your datasets have a large number of variables, in your datastep method a WHERE clause will be more efficient - the IF statement causes each record to be fully read before it can be selected for deletion. A WHERE clause would only read the single variable in the case of records that meet the criteria for deletion. Data prod.Master_date; set prod.master_date; where snap_dt ne "&end_dt"d; run; You probably would be better off changing your data model though - my first thought would to be to store your data as separate yearly or monthly files and then access them with a view of the past two years or 24 months. With each month or year you would delete the oldest file and change the view one time period forward. *set up the data; data time1 time2 time3 time4; do i = 1 to 100; do t = 1 to 4; if t=1 then output time1; if t=2 then output time2; if t=3 then output time3; if t=4 then output time4; end; end; run; *three successive example views; data filet1 / view=filet1; set time1 time2; run; data filet2 / view=filet2; set time2 time3; run; data filet3 / view=filet3; set time3 time4; run; One more thought - since the data are appended - if the file is not reordered and you have the record counts from each append - then you can use firsto...

help with reading ASCII data into SAS
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! Can anyone help me? On Nov 5, 10:45 am, olivesec...@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! imort the data as comma separated values. If it does not read the values properly, copy the log into the program window and edited it accordingly On Nov 5, 11:09=A0am, olivesec...@gmail.com wrote: > Can anyone help me? > > On Nov 5, 10:45 am, olivesec...@gmail.com wrote: > > > > > I will appreciate for any suggestions. The data is a txt file. The > > first two observations of the data is: > > > "=3DSite","ID","PID","IT","DD",&...

Re: Is it possible to read a sas dataset NOT using sas? #2
I think SPSS and DBMSCopy can read SAS datasets. Also for sure WPS. Gerhard On Tue, 18 Mar 2008 06:43:44 -0700, RolandRB <rolandberry@HOTMAIL.COM> wrote: >Is it possible to read a sas dataset NOT using sas and have >observations and variables etc. rather than having meaningless chunks >of text? ...

Re: search SAS data set from SAS code #2
Rose, The answer to your question depends on your operating system. In Windows, there's the Search tool. In Unix/Linux, you can use grep Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com Rose <myr_rose@YAHOO.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 04/19/2005 11:13 AM Please respond to myr_rose To: SAS-L@LISTSERV.UGA.EDU cc: Subject: search SAS data set from SAS code Hi All, Suppose I have a sas permanent data set which was created early, I know the library path but I couldn't remember in which s...

Re: SAS Reading Cognos Data #2
I have worked at two sites that used both SAS and Cognos, at both we dumped data from Cognos PowerPlay (an OLAP / multidimensional tool) into CSV (comma separated value) text files, if we wanted to analyse it in SAS. If we wanted to go the other way we did the same thing - dump it into a delimited text file. I doubt that you could use ODBC since it is tightly bound to SQL and relational-like structures. (I'm fairly sure there isn't an ODBC driver for Cognos PowerPlay.) SAS does provide the "SAS Access Interface to OLE DB" and both SAS and Cognos PowerPlay can be OLE DB co...

Re: read Access data in SAS #2
On Thu, 11 Oct 2007 08:46:26 -0500, Bruce J <chimanbj@GMAIL.COM> wrote: >If you have Access to PC File Formats, you can use the syntax: for SAS V. 9+ clarification: "Access" above refers to SAS/Access;"access" below refers to MS Access > >Libname mdb access "PATH\file.mdb"; > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Little >T >Sent: Thursday, October 11, 2007 8:14 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: read Access data in SAS > >Guys, I was given a Access data ...

Re: how to read quarterly data in SAS? #2
On Sat, 3 Nov 2007 22:26:04 -0000, Richard <hujian@GMAIL.COM> wrote: >I got the error message when I was using informat yyq. The original >data set is in .txt and delimited by space. > >data sen.sensitive; >infile 'sensitive.txt'; >input time $ yyq6. growth sensitive insensitive differnce recession; >rat=sen/in; >run; > >ERROR 48-59: The informat $YYQ was not found or could not be loaded. > >any thought? It's numeric. Remove the dollar sign ($). Thanks a lot! It works. On Nov 3, 6:27 pm, nos...@HOWLES.COM ("Howard Schreier <hs A...

Re: PLEASE Help with SAS data #2
> From: IHateStatisticalAnalysis Are you in the right career? > Ok. I've been trying to modify a data set using the keep function and > the message I get is that there are 0 observations and 0 variables. > Also that the variables I have named have not been referenced. What am > I doing wrong? This is what I have typed in: data kim; <---<<< unnecessary; libname in "s:\MPH..." <---<<< missing semicolon; data in.kim2; so this does not execute; set in.kim; keep age income sex; run; > Am I not referencing the...

Re: SAS 9.2 Update on problem re Help files #2
SNOTES is an approximately daily email from SAS STech Support listing the new or changed usage notes since the last email. So the item pertaining to you was: 32792 - SAS prompts you to rebuild the index when you press F1 to request help while running a SAS procedure in SAS 9.2 Release(s) Reported: 9.2 Release(s) Fixed: Date Created: 28JUL2008 Date Last Updated: 11AUG2008 http://support.sas.com/kb/32792.html To subscribe, go to http://support.sas.com/techsup/news/snotes.html You'll get an extra email on most workdays, but if you subscribe to SAS-L you'll hardly notice one more. There's also http://support.sas.com/techsup/news/tsnews.html It has news about tech support office hours and a few other things. If you want even more news, and you have an RSS reader, you can go to http://support.sas.com/community/rss/index.html On Mon, 25 Aug 2008 11:10:05 -0400 (GMT-04:00), "Peter Flom" <peterflomconsulting@mindspring.com> said: > Hi Jack > > I don't think I've ever looked at tech support notes ..... where is it? > Is it useful for browsing? > > Peter > > -----Original Message----- > >From: Jack Hamilton <jfh@alumni.stanford.org> > >Sent: Aug 25, 2008 11:08 AM > >To: Peter Flom <peterflomconsulting@mindspring.com>, "sas-l@listserv.uga.edu" <SAS-L@LISTSERV.UGA.EDU> > >Subject: Re: [SAS-L] SAS 9.2 Updat...

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: Read SAS date from log/turning it into SAS datetime value #2
Hi Richard, Rich The datestyle Rich0850 finds, occurs in the log produced by a batch-sas session - and doesn't appear on an interactive-sas session log. Where you can anticipate the use for later parsing of the log, I would reccommend - as Richard (Richard A. DeVenezia <radevenz@IX.NETCOM.COM>) did - insert into the autoexec, a statement to generate a more-easily read datetime. In all my sessions, (keeping altlogs of all interactive sessions has proved very very useful, time and again) I have this statement at the end of the autoexec....... %put starting (contract/project/applicatio...

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: What r the data types in SAS? in Base SAS , and SAS SQL
> From: Amar Mundankar > Sent: Tuesday, July 21, 2009 8:10 AM > To: sas-l@uga.edu > Subject: What r the data types in SAS? in Base SAS , and SAS SQL > > Hi all, > What are the different data types in Base SAS and SAS SQL?? character, lengths from 1 to 32,000+ numeric: lengths from 2 to 8 dates are a subtype of numeric and are identified by their date, datetime, or time formats the new proc TSPL (Table Server Processing Language) supports ANSI data types: bigint, tinyint, etc. http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003 065339.htm http://s...

Re: Reading unstructured data using SAS #2
Dear SAS-L-ers, Ashok posted, in part, the following: <<Ashok's entire original posting can be found beneath the Sig line>> > I want to read an html file using sas. The content of the file is > pasted > below. The sample file is the single record copied from html. <<SNIP!>> > > Can we use SAS to read unstructured data ? I can't answer your exact question, but can point you to a resource that you can use to explore this issue further. Check out the SAS 9.2 Language Reference Dictionary http://support.sas.com/documentation/cdl/en/lrdict/61724...

Re: suggest: improve SAS Deployment Wizard for SAS v9.2, phase 2 #2
> From: A Little Birdie > > I just searched the SAS-L archives (should have done that > first) and found references to these two pages: > > http://www.sascommunity.org/wiki/Category:V9.2_Phase_2 > > http://www.sascommunity.org/wiki/V9.2_Phase_2_install_guide > > Have you seen this page? > ***************************************************** > http://support.sas.com/kb/35/631.html <---<<< NICE! ***************************************************** > It looks like it addresses your needs, and might be something > nice to add to the SASCo...

Re: How to Read PDF/RTF data in to SAS datasets #2
On Tue, 28 Nov 2006 14:50:49 GMT, John I <not@HOTMAIL.COM> wrote: >Frank Poppe wrote: > >> John I schreef: >> >>> Richard A. DeVenezia wrote: >>> >>> > "Susiyanto, Dwi (GE Money)" wrote: >>> >> Hi SAS experts, >>> >> I have data of account list (that is like text file) in PDF/RTF >>> >> format. If i looked in RTF/PDF , it will show the column and account >>> >> list (including header of report), but when i do to copy paste to >>> >> text file (by using edi...

Re: read excel data cell and formula from SAS #2
On Thu, 27 Apr 2006 11:46:23 -0400, Joan Zhao <hongzl@OPTONLINE.NET> wrote: >Hi, everyone: > >Does anybody know that how can I read a specific data cell in a EXCEL file >from SAS through DDE? What's command or function can I use? Any reason you can't do it the usual way, by having the triplet point to just the one cell? >In addition, >how can I read a formula in EXCEL through DDE from SAS? I haven't tried this, but what happens if Excel is told to display the formula rather than the value in the cell being read? Tools:Options:View:Formulas > >I&#...

Re: Trying to read very dirty txt data into sas #2
David, If you read the data as a stream you can load what you want into a single variable and then parse that variable directly. DATA email; INFILE 'email.txt' recfm=n LRECL=32767; INPUT email $char32767.; RUN; data parse; set email; start=index(email,'<MESSAGE>')+9; end=index(email,'</MESSAGE>'); emailp1=substr(email,start,end-start); run; hth Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David Fickbohm Sent: Tuesday, August 1...

Web resources about - Re: help with reading ASCII data into SAS #2 - comp.soft-sys.sas

Reading, Massachusetts - Wikipedia, the free encyclopedia
Coordinates: 42°31′32″N 71°05′45″W  /  42.52556°N 71.09583°W  / 42.52556; -71.09583 Coordinates : 42°31′32″N 71°05′45″W  /  42.52556°N 71.09583°W ...

Crystal Palace v Reading score, result, video highlights, goals - Fox Sports Fox sports
Cabaye opened the scoring from the penalty spot in the 85th minute after Jake Cooper was sent off for fouling Yannick Bolasie. Substitute Campbell ...

Crystal Palace v Reading score, result, video highlights, goals
... goals by Yohan Cabaye and Fraizer Campbell have given Socceroos skipper Mile Jedinak’s Crystal Palace a 2-0 victory at second-tier club Reading ...

Oh, the pure pleasure of reading a newspaper
The weekend papers offer a window to the world, unlike the narrow and bitter offerings served up by online news.

Here's Mitt Romney Reading Mean Tweets by Trump and Trump Supporters
... the best tweet. Simon Dumenco, aka Media Guy, is an Ad Age editor-at-large. You can follow him on Twitter @simondumenco. Continue reading ...

(Late) Weekend Reading: Jeffrey Edleson on Sexual Harassment Here at Berkeley Edition
**Jeffrey Edleson**: [A Dean’s Reflection on Campus Sexual Misconduct Cases](http://blogs.berkeley.edu/2016/03/13/a-deans-reflection-on-camp ...

A brain-wave-reading device designed to improve sleep did wonderful and terrifying things to my dreams ...
The last week has been extremely unusual, to say the least. My dreams have been more colorful, detailed, vivid, and realistic than at any other ...

Students Not Reading Email? That’s Their Problem
A survey at Bowling Green State University shows that its students tend to read and respond to emails from their professors, but ignore emails ...

Melissa McBride Couldn't Speak After Reading The Walking Dead Season 6 Finale
The Walking Dead season six finale is going to be a mighty big, nasty pill to swallow.Several cast [...]

Man Learns About Ex’s Pregnancy & Friends’ Erotic Reading Habits Via Google Play
Sharing your review of an app — for good or bad — can help others decide if they should spend the money to add the service to their smartphone ...

Resources last updated: 3/16/2016 4:48:40 PM