f



Re: Reading RTF files with SAS #2

Jake,

I've never looked at the macro, but take a look at:

www2.sas.com/proceedings/sugi31/066-31.pdf

Art
--------
On Wed, 18 Mar 2009 18:32:33 -0400, Jake <johbee@GMAIL.COM> wrote:

>Does anyone know if SAS can read RTF files?  The reason I need
>to do this is to get a list of Titles from all the output in a bundled rtf
>vs. doing it manually.
>
>Thanks, for any information (publications, etc)
>
>Jake
0
art297 (4213)
3/18/2009 10:37:06 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
433 Views

Similar Articles

[PageSpeed] 35

Reply:

Similar Artilces:

Re: Unable to read Unicode file into SAS file
Another possibility is that proc import isn't correctly getting the right formats and informats. If you already know what those formats and informats should be, you can always copy, paste and edit (from the log) the data step that resulted from the proc import run, adjusting any incorrect formats and informats and then just run it as a data step. Also, while I don't think it would make any difference, your proc import contains two "datafile=chr" statements. Art -------- On Tue, 19 Jan 2010 21:06:11 +0530, Cherish K <c4cherish@GMAIL.COM> wrote: >From MS SQL, I ext...

Re: How to convert a RTF file into a PDF file with SAS statements? #2
If you have Word and Acrobat, use DDE to drive Word. On Mon, 23 May 2005 06:15:33 -0700, Lei Zhang <lzhang9830@YAHOO.COM> wrote: >Hi All, > Does anyone know how to convert a RTf file into a PDF file by using >SAS statements, or within SAS system? Any suggestion will be very >welcome. Thanks. > >LZ ...

Re: Autoexec.sas file Dm"pgm;zoom;"; doesnot wrk in SAS 9.2 #2
Hi Ace, The PGM is the editor window up through v6.12 but also still exists today. For the Enhanced Editor you can use: dm editor 'zoom' wedit ; Hope this is helpful. Mark Terjeson Investment Business Intelligence Investment Management & Research Russell Investments 253-439-2367 Russell Global Leaders in Multi-Manager Investing -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ace Sent: Wednesday, October 14, 2009 5:49 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Autoexec.sas file Dm"pgm;zoom;"; doesnot wrk in SAS...

Re: Reading RTF files with SAS
Arthur, It works great! Thanks! I'm up and running now. Jake On Wed, Mar 18, 2009 at 6:37 PM, Arthur Tabachneck <art297@netscape.net>wrote: > Jake, > > I've never looked at the macro, but take a look at: > > www2.sas.com/proceedings/sugi31/066-31.pdf > > Art > -------- > On Wed, 18 Mar 2009 18:32:33 -0400, Jake <johbee@GMAIL.COM> wrote: > > >Does anyone know if SAS can read RTF files? The reason I need > >to do this is to get a list of Titles from all the output in a bundled rtf > >vs. doing it manually. > > > >Thanks, for any information (publications, etc) > > > >Jake > ...

Re: how to read this file into sas #2
Read the file in its orginal form and Proc Transpose is one alternative... On Thu, 14 Sep 2006 17:09:52 -0700, liuyuanpku@GMAIL.COM wrote: >Hi, I just got a problem to read a txt file into sas. The structure of >the data in txt file is: > >family member >1 3809 3810 3811 3812 >2 3814 3815 3816 >3 3817 3818 3819 3820 > >When I read it into sas, I want it in the following structure: >family member >1 3809 >1 3810 >1 3811 >1 3812 >2 3814 >2 3815 >2 3816 >3 3817 >3 3818 >3 3819 >3 3820 > >How can I get this sas data? >Thank...

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: Reading PDF Files into SAS #2
Mona You have received several responses that speak of using some external tool to do a pdf to text conversion and then, presumably, you would parse the text with SAS. These responses depend on the PDF having been produced by a pdf writer and not by the file being a scanned image. In the later case, you would need to use an OCR reader to convert the pictures to text. Do you need to do only a few conversions or many and will this be an ongoing task? If you are only going to do an occasional conversion, I would use the Save As Text which is found in Adobe Acrobat Reader 7.0 and maybe earlier. However, if this is a larger project, I would (and have) used an external program to do the conversions. I have a paper from several years ago posted at http://www.vasug.org/Proceedings/2003-02/Presentations/EXTRACTING%20DATA%20FROM%20PDF%20FILES.doc This describes how I used a tool that converted one pdf at a time and controlled this from within the SAS program. Since that time, I have had a similar project and was not able to get the pdf converter that I used earlier to work. However, I found one available on line that converted all of the pdfs in a folder in one pass I was able to eliminate all of the SAS calls that ran the external process. I ran that particular job from home since there are restrictions on using unapproved tools here at work and I do not recall the name of the converter. Good luck. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Ca...

Re: read excel files into SAS #2
A quick way to solve it is to use DDE, which you can specify the first row to be read as data and specify the informat as well. HTH. On 8/8/05, Joan Zhao <jlin104@hotmail.com> wrote: > I found a problem when I read a excel file into SAS. The initial seceral > rows(more than 8 rows) of one of the column in this file are blank and then > follwed by numeric numbers. In this column, most cells are empty. When SAS > read in this file by no matter what approach(SAS/ACCESS--import procedure > or OLEDB), nothing in this column is read in. The generated SAS dataset is > empty....

Re: Unix SAS: How to save log file while in SAS session? #2
On Wed, 18 Aug 2004 12:18:03 -0500, Duck-Hye Yang <dyang@CHAPINHALL.ORG> wrote: >Hello, > >I am using SAS Unix Display manager. >I put together single small sas programming files in one giant sas programming file. >I need to save log and output files AFTER each single small programming file. >The problem is that I do not know how to save log and output while in SAS session. > >Below is the outline of what I'd like to do: > > >DM 'clear log'; >DM 'clear output'; >SAS 1 programming start here >end here >x 'file "SAS...

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: 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: Creating SAS datasets from reading a file #2
Chandra, Couldn't you accomplish what you want by using Proc SQL to crete two macro variables and then use those variables in a data step? E.g., proc sql noprint; select distinct "dwproject_"||state, "if state eq '"||state||"' then output"|| " dwproject_"||state||";" into :data_st separated by ' ', :if_st separated by ' ' from stlist.del ; quit; data &data_st.; set del; &if_st.;; run; HTH, Art ------- On Fri, 11 Jul 2008 15:08:19 -0400, SUBSCRIBE SAS-L Chandra Gadde...

Re: read files on mainframe from pc sas #2
you don't say what version of SAS is in use on either the mainframe or the pc. if you license SAS/Connect, you can connect to the mf and xfer the data. If you do now, you can save the data in transport format (xport/cport), download to the pc and read it. On the mf, ignore any conventions your systems folks have told you about optimal blocking and use lrecl=80, blksize=8000 and recfm=fb. ---- Original message ---- >Date: Sat, 8 Jan 2005 16:38:46 -0600 >From: kukda <mkukda@COX.NET> >Subject: read files on mainframe from pc sas >To: SAS-L@LISTSERV.UGA.EDU > >Is t...

Re: reading multiple excel files into SAS #2
************************************************* * READ ALL EXCEL FILES WITH SAME STRUCTURE * * FROM A FOLDER INTO SAS USING MACRO * * DATE: SEP-29, 2005 * *************************************************; %macro ReadXls(dir =3D , out =3D ); ************************************************* * MACRO PARAMETERS: * * DIR: FOLDER WHERE DATA IS STORED * * OUT: NAME OF OUTPUT DATA TABLE * *************************************************; /* DELETE TABLE WITH SAME NAME AS OUTPUT DATA */ proc datasets; delete &out; run; quit; /* MANIPULATION THE STRING OF FOLDER PATH */ data _null_; dir1 =3D...

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 can I read old SAS system file? #2
Duck-Hye Yang <dyang@CHAPINHALL.ORG> wrote: > How can I read this old file named "crnlink.ssd01"? > The following code did not work: > ---------------------------------------- > libname master '/match/peoplematch/'; > proc print data=master.crnlink (obs=100);run; That's a SAS V6 data set. You should have looked at the log and seen what the error was. Try this variant of your own code: libname master v6 '/match/peoplematch/'; proc print data=master.crnlink (obs=100);run; However, you may not have the path to the directory specified quite ...

Re: How to read a period in a variable from a file to SAS dataset #2
On Mon, 28 Jul 2008 02:01:10 -0700, =?ISO-8859-1?Q?Rune_Runnest=F8?= <rune@FASTLANE.NO> wrote: >/* >This is the file with the fileref MYFILE: > >--------------------------------------- >DOKTITTEL: this is the first record >--------------------------------------- >DOKTITTEL: . >--------------------------------------- >DOKTITTEL: this is the third record >--------------------------------------- >*/ > >/* >I want the second record to be '.', not ' '. >How can I obtain that? > >Rune >*/ >filename myfile "d:\tem...

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: PC SAS 9.1
Hi Jon, If you run SAS in batch mode the dir the .sas file is in will by default be the dir where the .log and .lst files will be left. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld My computer remains home while I will attend PhUSE 2006 in Dublin. On Tue, 12 Sep 2006 09:23:15 -0400, Jon Hayward <jhayward1@BABSON.EDU> wrote: >Hi - > >Is there a setting in PC SAS so that whichever directory I save my .sas >file to, SAS will automatically go there when I want to save my .log >and .lst files? > >Currently...

Re: Reading multiple .RPT files from a Folder into SAS dataset #2
It should not be hard, if 1. You have a reliable technique for reading *one* of the files. 2. The 30 files have a common structure. Focus on #1 first. You are getting ahead of yourself if you don't have a good answer. On Sat, 24 Jun 2006 08:01:04 -0700, SAS-1 <emailto.nishant@GMAIL.COM> wrote: >Hi >I have a folder containg around 30 .RPT ASCII text files and I need to >read all of them into a single SAS dataset. The .rpt files are huge and >doing the Import individually might be a time consuming effort. Is >there a method of reading files from a folder one by one ...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #2
Sounds like R is the SAS equivalent of Linux .. who are incidentally in all sorts of a copy left/right mess at the moment. On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote: >I use both SAS and R; I"ve used SAS for 10 or 15 years, R for about 6 >months - 1 year. > >Each has strengths and weaknesses; I'd not like to give up either. > >Strengths of SAS (esp. compared to R) > >Tech support - I have SAS tech support's phone number and our license >number memorized. They're great. > >SAS-L - There's also an R-help list...

Re: How to read data from stata file(.dta) in SAS 9.0 #2
by the way: if you still get errors, install a actual SAS version. The below is for 9.1.3 Gerhard On Mon, 28 Sep 2009 10:04:31 -0400, Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE> wrote: >try the following (adapt your dataset names): > >proc import out= hsb2 datafile = "c:\data\hsb2.dta"; >run; >proc contents data=hsb2; >run; > >Gerhard > > > > >On Mon, 28 Sep 2009 00:25:37 -0700, kondal <kondal717@GMAIL.COM> wrote: > >>Hi friends >> >>I used following code to read data from stata file ( SAS 9.0) bu...

Re: Reading MS Word ".doc" files into SAS #2
Maybe you can download a shareware (there are many out there), then batch convert them to txt files. A data step to read in all the txt files, and keep only the first few lines would very easy to write. DDE is another option of course, but need a bit more coding. On Fri, 18 Apr 2008 14:35:30 -0400, Jake Bee <johbee@GMAIL.COM> wrote: >These are acutally .doc (not .rtf) -- Thanks again for any information. > >On 4/18/08, Brian <brian100200@yahoo.com> wrote: >> >> On Apr 18, 1:43 pm, joh...@GMAIL.COM (Jake Bee) wrote: >> > Dear SAS-L: >> > >...

Re: Trouble using DDE to read text from a Word file into SAS #2
Paul As far as I know, SAS reads tables when doing DDE. I'm not sure what happens with straight text. Can you run your job by manually opening the DOC and then issuing the DDE commands. If they work at this point, then I would guess that you are not opening your doc properly. Nat Wooding -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Paul Miller Sent: Wednesday, September 02, 2009 2:04 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Trouble using DDE to read text from a Word file into SAS Hello fellow DDE users, I want to read text from a word...

Web resources about - Re: Reading RTF files with 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 9:45:06 AM