f



Re: Read a variable from Right to Left #5 1551917

Richie,

Are you trying to squeeze everything in the end part to fit into six
characters? I am guessing this based on the sample output. If these are all
really addresses then you may not always have apartment numbers. Assuming
your question is more general, here is a solution.

data _null_ ;
  length string1 $100 type $6 ;
  infile cards truncover ;
  input @1 string1 $char100. ;
  type = substr(compress(string1),length(compress(string1))-5) ;
  put string1 = type = ;
  cards ;
114, Mills Rd, Apt 202
345 Morris Drive, Apt 345
Chestnut Avenue Apt # 987
run ;

Venky Chakravarthy

On Tue, 21 Mar 2006 14:53:59 -0800, Richie <gsingh24@GMAIL.COM> wrote:

>Hi All,
>
>I want help to substring a variable from right to left, for eg: I have
>a SAS data set which has a variable Address like.
>
>Address
>
>114, Mills Rd, Apt 202
>345 Morris Drive, Apt 345
>Chestnut Avenue Apt # 987
>
>Is there a way I can create a variable say Type like
>
>Type
>
>Apt202
>Apt345
>pt#987
>
>Thanks,
>Richie
0
swovcc (579)
3/21/2006 11:47:46 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
287 Views

Similar Articles

[PageSpeed] 15

Reply:

Similar Artilces:

Re: Read a variable from Right to Left
On Tue, 21 Mar 2006 14:53:59 -0800, Richie <gsingh24@GMAIL.COM> wrote: >Hi All, > >I want help to substring a variable from right to left, for eg: I have >a SAS data set which has a variable Address like. > >Address > >114, Mills Rd, Apt 202 >345 Morris Drive, Apt 345 >Chestnut Avenue Apt # 987 > >Is there a way I can create a variable say Type like > >Type > >Apt202 >Apt345 >pt#987 > >Thanks, >Richie The simple answer is to provide a negative value for the second parameter of the scan() function. data demo ; string = '345 Morris Drive, Apt 345' ; last_word = scan( string, -1 ) ; second_last = scan( string, -2 ) ; put (_all_)(=) ; run; The log shows string=345 Morris Drive, Apt 345 last_word=345 second_last=Apt See the online doc for optional third parameter which allows you to specify what punctuation to (dis)allow, like that '#' Peter ...

Re: Read a variable from Right to Left #4
Richie: Try the following. I assume there is a comma before "Apt # 987" in your third address. Output follows the code. data temp; input; Type=scan(_infile_,-1,","); datalines; 114, Mills Rd, Apt 202 345 Morris Drive, Apt 345 Chestnut Avenue, Apt # 987 ; run; proc print; run; ***** Output ***** The SAS System 15:09 Tuesday, March 21, 2006 2 Obs Type 1 Apt 202 2 Apt 345 3 Apt # 987 J S Huang 1-515-557-3987 fax 1-515-557-2422 >>> Richie <gsingh24@GMAIL.COM> 3/21/2006 4:53:59 PM >>> Hi All, I want help to substring a variable from right to left, for eg: I have a SAS data set which has a variable Address like. Address 114, Mills Rd, Apt 202 345 Morris Drive, Apt 345 Chestnut Avenue Apt # 987 Is there a way I can create a variable say Type like Type Apt202 Apt345 pt#987 Thanks, Richie ...

Re: Assign variables to a new variable based on variable names in SAS #5
Hi Chang & V - I'm confused as usual - did you mean this? 142 data one; 143 a_1995q3 = 1; 144 a_1995q4 = 2; 145 a_1997q1 = 3; 146 a_2003q4 = 5; 147 n = "2003q4"; 148 run; NOTE: The data set WORK.ONE has 1 observations and 5 variables. NOTE: DATA statement used: real time 0.01 seconds cpu time 0.01 seconds 149 150 data two; 151 set one; 152 call symput('n', n); 153 new_a = 'a_'||resolve(n); 154 put new_a=; 155 run; new_a=a_2003q4 NOTE: There were 1 observations read from the data set WORK.ONE...

does PHP read left to right or right to left?
I've two functions. currentHeadline looks in $_GET for a variable called 'image' and prints what it finds. showThumbnail takes an image for a parameter and resizes it before sending it to the screen. But when I do this: <?php showThumbnail(currentImage(), 20, 20); ?> showThumbnail is telling me that it is not being given a file name, and currentImage is printing the file name to the screen. How is that possible? What is the right way to do this? lawrence k wrote: > I've two functions. currentHeadline looks in $_GET for a variable > called 'image' and pr...

Re: Converting from SAS 5 to SAS 9 #5
Mikeey I did try V8 before I sent the posting just to be sure that V5toV6 was not available and I too, found it not there. I see that Dale did not find it in a V6.12 installation. I just ran a mainframe 6.09E job and the proc is there. I find it odd that it would not be available in 6.12 since this is a V6 proc. The spelling is V5TOV6 Nat Michael Raithel <michaelraithel@W To: SAS-L@LISTSERV.UGA.EDU ESTAT.COM> cc: Sent by: "SAS(r) Subject: Re: Converting...

Re: read variable into macro #5
On Wed, 23 Jul 2008 23:35:22 -0400, Arthur Tabachneck <art297@NETSCAPE.NET> wrote: >In the present case you don't have to. Try: > >%macro test; >%do i = 1 %to 10; > %put &i. ; >%end; >%mend test; >data _null_; >%test; >run; Actually, the do-nothing DATA step is useless, as is the null statement coded after the macro call. So %macro test; %do i = 1 %to 10; %put &i. ; %end; %mend test; %test works just as well. > >HTH, >Art >-------- >On Wed, 23 Jul 2008 18:45:16 -0700, learner <cnfengshuang@GMAIL.COM> wrote: > >>Hi, >> >>I wanted to run the following code to get >> >>1 >>2 >>3 >>4 >>5 >>. >>. >>10 >> >> >> >>%macro test; >>%do i = 1 %to 10; >>%let num= i; >> put &num ; >>%end; >>%mend test; >>data _null_; >>%test; >>run; >> >>Here is what i got from the log: >> >>2048 %macro test; >>2049 %do i = 1 %to 10; >>2050 %let num= i; >>2051 put &num ; >>2052 %end; >>2053 %mend test; >>2054 data _null_; >>2055 %test; >>MPRINT(TEST): put i ; >>MPRINT(TEST): put i ; >>MPRINT(TEST): put i ; >>MPRINT(TEST): put i ; >>MPRINT(TEST): put i ; >>MPRINT(TEST): put i ; >>MPRINT(TEST): put i ; >>M...

Re: sas datastep and variable #5
michael.gruner@GMAIL.COM wrote: > >Hello, > >tried to find a solution to my problem round there but wasn't very >successful yet. Maybe can point me to some best practice how to create >sas code to solve my problem. > >I have two sets. Set one consists of 2 columns (key and value). Set >two consists of a variable number of columns but one column consists >of the key of set one. I now want to go through all rows of set one >and create a new set that consists of the observations of set two that >have the key-variable-value of the current observation of set one. >This new set should be named after the the value-variable-value of set >one. > >Tryed to play around with some macro programming, however I found it >not possible to use a macro variable that I created with call symput >in the same datastep. I would like to suggest two things: [1] use PROC SQL to pull the relevant records with matching keys, or use a hash in a data step; and [2] consider not using macro programming at all, but pull the entire set of matching records as one data set. That data set can then be used handily with WHERE clauses and/or by-processing, which will be much more efficient than trying to work with hundreds of separated data sets. >Here is what I programmed yet: > >%macro createSet (sourceSet, key, >keyvalue); > data >&keyvalue; > set >&sourceSet; > if &key = >&keyvalue; > >ru...

Re: A Problem with sas variables #5
Rathindronath , Okay simple enough : BPS = compress( scan( BPS , 1 , ' ' ) , ':,') ; Toby Dunn From: Rathindronath <mehedisas@YAHOO.COM> To: SAS-L@LISTSERV.UGA.EDU, Toby Dunn <tobydunn@HOTMAIL.COM> CC: Md Alam <mehedisas@YAHOO.COM> Subject: Re: A Problem with sas variables Date: Tue, 30 May 2006 11:13:56 -0400 Sorry, It was a bit messy data. I should have send you the complete. Please find it as follows Variable(BPS) BPS ------- Acute Coronary Article Fibrillant Other: Coronary Other: Stroke Other: Sympton Other, Agina Post OTHER I need to get...

Re: SAS variable limit #5
For V9 that seems to be unlimited... On Wed, 8 Aug 2007 11:18:28 -0400, Sridhar, Nagakumar <nagakumar.sridhar@SPCORP.COM> wrote: >V8 has 32767 variables that can be defined. > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of >nytovo@GMAIL.COM >Sent: Wednesday, August 08, 2007 9:27 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: SAS variable limit > > >Hi all, > >My question is simple : How many variables can I put on SAS table? Is >there any limit? > >Thanks, > >GTBF >********************************************************************* >This message and any attachments are solely for the >intended recipient. If you are not the intended recipient, >disclosure, copying, use or distribution of the information >included in this message is prohibited -- Please >immediately and permanently delete. ...

Re: Sum variables in SAS #5
Muthia, Note that by coding this way, you are not utilizing the intrinsic functionality of the DoW-loop which aligns the boundaries of the implied and explicit loops thus letting the DATA step automatic action to do the clean-up of the summary variables before each next BY-group. Instead, consider: data need ; do until (last.id) ; set given ; by id ; sum_milk = sum (sum_milk, milk) ; sum_fat = sum (sum_fat, fat ) ; end ; run ; Kind regards ------------ Paul Dorfman Jax, FL ------------ On Tue, 3 Jun 2008 17:58:17 -0400, Muthia Kachirayan <muthia.kachirayan@GMAIL.COM> wrote: >On Tue, Jun 3, 2008 at 5:26 PM, Brad Heins <hein0106@umn.edu> wrote: > >> I have a data that I want to sum variables in SAS and I am not quite sure >> how to do it. I have an example of the dataset below and I want to sum >> milk >> and fat for 3 days for each ID. >> >> Also, how would I sum the data for milk for just 2 days instead of 3 days. >> Can I do this with some sort of "do" loop? >> Any help would be greatly appreicated. >> >> Brad H. >> >> >> ID Days Milk Fat >> 1 1 20 2 >> 1 2 30 3 >> 1 3 23 2.5 >> 2 1 40 2.1 >> 2 2 40 3.1 >> 2 3 43 2.5 >> > >Using DoW-loop you can get. The data set, given , is to be pre-sorted by ID. > >data given; >inp...

Re: Reading Web logs with SAS #5
Alan, Refusal to use cookies is simply treated as measurement error which can be calculated because we can count the number of cookieless records. I forgot to mention that this SAS Component Language program can also be used to do Web Analytics in real time. Just pipe the web logs to the program as they are generated. Since everything is done without sorting, web analytics can be done "on the fly". Joe. On Tue, Mar 31, 2009 at 6:24 PM, Savian <savian.net@gmail.com> wrote: > On Mar 31, 3:45 pm, joewhitehu...@GMAIL.COM (Joe Whitehurst) wrote: > > Alan, > > You must have forgotten the challenge I issued to all the MMMMs out the= re > in > > SAS-L land a few years ago. I have a SAS Component Language program th= at > > parses TBs of web logs from multiple servers all intermixed and > determines > > individual session information in one pass without sorting the data. I > > challenged the MMMs to come up with a SAS macro language program that > could > > do the same thing. Of course all the efforts by the MMMMs failed. You > can > > refresh your memory by rereading: > > > > Macro Mavens and Innocent Bystanders, > > > > I fear the Macro Mavens' challenge might have gotten lost in the clutte= r > of > > a thread grown too long, so I will start a new thread and summarize the > > challenge in one place. > > > > THE CHALLENGE > > > >...

Re: reading variables enclosed in quotes #5
hi ... if all you need is a COMMA delimiter, add one to the data as it's read... search for a double-quote followed by a space and use TRANWRD to change those two characters to a double-quote followed by a comma ... DSD then reads comma-limited records ... (I think someone may already have suggested this) ... data x; infile datalines dsd firstobs=2; input @; _infile_ = tranwrd(_infile_,'" ','",'); input name : $20. age state : $2. ; datalines; "Name" "Age" "State" "Smith AA" "22" "NJ" "Tom BB" "44" "CT" "Shake CC" "34" "CA" ; run; ps if there are any occurrences of stuff like " MIKE " (an extra space between the quotes and real data), this won't work ... if it's a quote-blank-any character you might encounter, you could write (I can't) a Perl expression to get rid of that blank prior to using TRANWRD ... there is probably some way of doing all the tweaking with Perl functions prior to the real INPUT statement with the variable names -- Mike Zdeb U@Albany School of Public Health One University Place Rensselaer, New York 12144-3456 P/518-402-6479 F/630-604-1475 > Hi All, > > thanks very much for your sugestions. unfortunately the data is bit > messy with varying amount of space occuring between variables (also > there is no comm...

Re: how to read gzip file in SAS #5
filename hhafixed pipe '"C:\Program Files\GnuWin32\bin\gunzip" -c C:\SEERMEDICARE\disk1\hhasaf91.txt.gz'; Path contains a space, need to be double quoted for Winders. I added double quotes around the path above. See if that works. On 11/1/07, wraong <wrong.wang@gmail.com> wrote: > Hi, > I changed filename command as: > > > filename hhafixed pipe 'C:\Program Files\GnuWin32\bin\gunzip -c > C:\SEERMEDICARE\disk1\hhasaf91.txt.gz'; /*reading in a > zipped file*/ > > Then SAS said > 'C:\Program' is not recognized as an internal or external command, operable > program or batch file. > > I tried Start-Run-C:\Program Files\GnuWin32\bin\gunzip , the file can be > open by gzip.exe. > > What else should I do? > > Thanks. > > > > > > > > On 11/1/07, data _null_, <datanull@gmail.com> wrote: > > I think Howard was saying to debug your CALL to Gzip. I expect you > > just need to call it with the full path. C:\your file path\gunzip > > > > open a DOS box to test > > > > On 11/1/07, wraong <wrong.wang@gmail.com> wrote: > > > Hi, Howard, > > > > > > How to debug gunzip? > > > > > > Install *GNU Tar* and *GNU GZip* for Windows. Added "C:\Program > > > Files\GnuWin32\bin" to my Path System variable by going to Control > Panel--> > > > System Propert...

Re: A SAS macro variable question #5
SAS (r) Proprietary Software Release 9.2 TS1M0 proc options group = macro; proc options define value option = MINDELIMITER; run; Option Value Information For SAS Option MINDELIMITER Option Value: Option Scope: Default How option value set: Shipped Default Option Definition Information for SAS Option MINDELIMITER Group= MACRO Group Description: SAS macro language settings Description: Identifies the character to use as the delimiter of the macro IN operator Type: The option value is of type CHARACTER Maximum Number of Characters: 1 > -----Original Message----- > From: owner-sas-l@listserv.uga.edu > [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of Jim Groeneveld > Sent: Thursday, November 13, 2008 5:19 AM > To: SAS-L@LISTSERV.UGA.EDU; Xian.Lv@GMAIL.COM > Subject: Re: A SAS macro variable question > > Hi Xian, > > No, there is no macro equivalent for the IN operator, so your > statement will > not work or yield wrong results. Instead use my %IN macro (that I will > update soon): > http://home.hccnet.nl/jim.groeneveld/software/SASmacro/IN.zip > > Regards - Jim. > -- > Jim Groeneveld, Netherlands > Statistician, SAS consultant > home.hccnet.nl/jim.groeneveld > > > On Wed, 12 Nov 2008 13:20:38 -0800, Xian.Lv@GMAIL.COM wrote: > > >Thanks. > > > >I have experiencing the same problem that A.B. had. And it seems that > >we MUST NOT use the quotati...

Re: How could SAS read numbers in pictures? #5
ben.powell@CLA.CO.UK replied: > >Unconstrained OCR of free text is generally very poor, although success >rates with constrained text where each character is entered into a field >are much higher, so you can have some variation there - which is why they >say "don't write over the lines"... These constrained entries also need OMR >marks to locate the reader software over the correct area. > >*declares no vested interest* Teleform from Cardiff software >(Verity/Autonomy) outputs by default to - I think - an SQL Server Express >database although can be ...

Re: SAS Global Macro Variables #5
> From: Bucher Scott > Commands in autoexec.sas are read whenever SAS is started.You can put > this in the root directory or elsewhere if you specify its location in > the SAS startup command. > > However, if you need to change these often or you want to make it more > evident to people reading you programs that these macros are being > created, perhaps it may be preferrable to place all these > commnads in a > file you reference with %include at the top of every program. the command to echo -- i.e.: source2 -- the statements in the autoexec is: -echoauto note that this is a command line, or config file -only option - - - MyProgram.bat - - - sas MyProgram -echoauto if you want to do this -every- time, -- which I do not recommend -- then the appropriate place is in SASv9.cfg - - - SASv9.cfg - - - -SASinitialFolder '.' -echoauto What I -do- recommend, for this Q, is: - - - autoexec.sas - - - %Let Libname = Library; %Let Memname = MyData; %Put _global_; Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov ...

Re: question about sas macro variables #5
Amazing! I agree, no use of this comes straight to mind, other than being a nice addition to Art Carpenters "Maximise Your Indespensability" paper, but it is nontheless very cool. I will try to think of a practical use for this :) Thanks 2009/1/16 ./ ADD NAME=Data _null_, <iebupdte@gmail.com>: > On 1/16/09, karma <dorjetarap@googlemail.com> wrote: >> I think this raises another interesting question, can SAS macro create >> macro code that is executable at a later time? As far as I know, Lisp >> allows macro code to create macro code ad infinitum. I don't think SAS >> does allow this, but I would be happy to be proven wrong on this. An >> example: >> >> %let c = %superq(%put 1;); >> %unquote(c); > > This doesn't work because SUPERQ only works on macro variables and the > unquote is missing & for &C. But it can be made to work see lines 1 > and 2 below. The rest is a macro that writes a macro. I can't think > of a use for this today but I think I actually coded something similar > many years ago when I was "macro happy". > > > > 1 %let c = %nrstr(%%put NOTE: &systime;); > 2 %unquote(&c); > NOTE: 09:08 > 3 > 4 > 5 %macro writes1(name=hello); > 6 %let macro = %nrstr(%%)macro &name(called=&sysmacroname) > %nrstr(; %%put NOTE: MY name is &sysmacroname, > 6 ...

Re: Reading PDF Files into SAS #5
I second Nat on this -- I forgot about the 'scanned in' possibility. You will need OCR in that case. -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Nat Wooding Sent: Wednesday, April 01, 2009 11:01 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Reading PDF Files into SAS Mona Are you certain that the pdf was converted from a text or word processing document such as a Word Doc being converted to a PDF. Or, could someone have scanned a paper copy of the document and save this as a PDF. If it is the latter case, you will need to use OCR program to read the image and create a text file. Nat Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Mona <k_monal_99@YAHOO .COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Reading PDF Files into SAS 04/01/2009 11:55 AM Please respond to Mona <k_monal_99@YAHOO .COM> Thanks Matt and Nat. But when I try to save the PDF to text , nothing gets saved , the text file is totally empty. May be I am doing something wrong. Not Sure. Thanks again for the ideas. CONFIDENTIALITY NOT...

Re: How to read negative value variable? #5
I just had a chance to look at this thread. Has anyone suggested the version 9 TRAILSGN informat? Note that I had to add a line to remove the commas. Data neg; filename negs 'c:\park\negs.txt'; infile negs; informat value TRAILSGN. ; input @; _infile_ = compress( _infile_ , ',' ); input @1 value ; /* the values in the file are 123,456 234,567- */ proc print;run; Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you. ...

Re: Reading Excel datetime variable into SAS
Hi Annie, One approach is to add the following expression contained in the sample datastep below into your datastep. data _null_; DateStringFromExcel = '08/01/2008 17:18'; SASDateTime = input(substr(DateStringFromExcel,1,10),mmddyy10.) *86400+input(substr(DateStringFromExcel,12),time.); format SASDateTime datetime19.; put _all_; run; Hope this is helpful. Mark Terjeson Investment Business Intelligence Investment Management & Research Russell Investments 253-439-2367 Russell Global Leaders in Multi-Manager Investing -----Origina...

Re: SAS regression with control variable #5
No, but you can put independent and control variables in together on the right side of the model. Rgression susm of squares will test each variable controlling for all the other varibales. Paul R. Swank, Ph.D. Professor, Developmental Pediatrics Director of Research, Center for Improving the Readiness of Children for Learning and Education (C.I.R.C.L.E.) Medical School UT Health Science Center at Houston -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kijoeng Nam Sent: Monday, April 03, 2006 2:56 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS regression with control variable So you mean without any regarding of control variables, I can put dependent variable and control variables in one statement(RHS of model) together. Right? On 4/3/06, Peter Flom <Flom@ndri.org> wrote: > > >>> Kijoeng Nam <kijoeng@GMAIL.COM> 4/3/2006 12:40 pm >>> wrote > <<< > If I have following model, such as > independent variable - a > dependent variable - b > control variables - c d, and data name is abcd > > , then can I just use following code? > > proc reg data = abcd; > model b = a c d ; > run; > >>> > > Sounds right to me. > > Of course, with no context, it's hard to say whether anything is > right, but given what you asked, that's the answer > > Peter > > > > > Peter L. Flom, PhD > Assistant Director, Statis...

Re: How to Right Trim a macro variable? #5
On Wed, 31 Oct 2007 11:59:23 -0500, data _null_, <datanull@GMAIL.COM> wrote: >Does not work... > >1 data test; >2 table = 'This '; >4 proc sql noprint; >5 select trim(table) into :model from test; >6 %put NOTE: <&model>; >NOTE: <This > >7 quit; That's kind of surprising. The DATA step does better. data _null_; set test; call symput('model',table); notetext = quote(symget('model') ); put 'NOTE: ' notetext; call symput('model',trim(table) ); notetext = quote(symget('model') ); put 'NOTE: ' notetext; run; Log shows NOTE: "This " NOTE: "This" > > >On 10/31/07, Howard Schreier <hs AT dc-sug DOT org> <nospam@howles.com> wrote: >> On Wed, 31 Oct 2007 10:58:36 -0500, Mary <mlhoward@AVALON.NET> wrote: >> >> >Hi, >> > >> >Is there a way to right trim a macro variable? >> > >> >I am doing code like this: >> > >> >proc sql; >> > >> >select table into :model >> > >> >from modelset; >> > >> >quit; >> > >> > >> > >> >But then when I do a put on the macro variable &model, it shows that it has >> spaces included (as the original variable is a character variable). I want >> to use it in a...

Re: MSWord, MailMerge, and reading SAS data #5
Scott, I built an example project showing how to use Visual Studios Tools for Office to bring data from SAS into Excel, all automated. I will build one for Word a little later but the principles will be the same. This is fairly new technology but is extremely robust, scalable, and powerful. You essentially have full control over the entire Office object model. You can download the paper that shows step by step how to do this, code, and screenshots at the following page: http://www.savian.net/utilities.aspx This will get you started in understanding the concepts. I will build a Word one next so it will specifically address your needs. Another possible approach can be found here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_wd2003_ ta/html/odc_wd11xml.asp You would need to export SAS as an XML document. This is easily accomplished using the XML libname engine: libname outdata xml 'c:\temp\outdata.xml' ; Thanks, Alan Savian "Bridging SAS and Microsoft Technologies" http://www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Scott Bass Sent: Wednesday, June 15, 2005 3:54 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: MSWord, MailMerge, and reading SAS data Hi Alan and David, Thanks for the replies, much appreciated. More details may be helpful: the end users are medical writers. They don't have SAS, don't know SAS, don't want to know SAS. Right now they cu...

Re: Drop Variable without Reading Data? #5
hi ... you might already know this, but just in case ... if you do end up read/write (which I think you'll have to), change the style of data step you provided from ... * read all the variables, write all except var1-var3; data a (drop=var1 var2 var3); set a; run; to ... * read all the variables except var1-var3, write all that are left; data a; set a (drop=var1 var2 var3); run; no reason to read data you do not want to keep ps PROC DATASETS cannot change the data portion of your data set, only the descriptor portion (variable attributes such as names, formats, labels) -- Mike Zdeb U@Albany School of Public Health One University Place Rensselaer, New York 12144-3456 P/518-402-6479 F/630-604-1475 > I have a permanent SAS data set with several million records and want to > drop three of the variables. Is there an efficient way to do this without > reading in all the data, which of course will be time consuming given the > number of records? > > If I were to do it with: > > data a (drop=var1 var2 var3); > set a; > run; > > I think it would take at least 2 or 3 hours. Would dropping the vars be > faster with SQL? Proc datasets maybe? > > thanks, > Dave > > ...

Web resources about - Re: Read a variable from Right to Left #5 1551917 - comp.soft-sys.sas

Variable - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Westpac interest rate rise is one of many variable loan rate rises
WESTPAC is not alone in hitting its owner-occupier customers with a surprise interest rate rise, as dozens of other variable rate home loans ...

Airbnb upgrades variable pricing tool for hosts
Online home rental group Airbnb is rolling out an upgraded variable pricing tool that automatically raises or cuts room rates based on supply ...

Commonwealth Bank raises variable home loan rates
Home owners' mortgage costs are set to rise by hundreds of dollars a year, after the Commonwealth Bank became the latest bank to hike interest ...

CBA lifts variable home loan rates to offset costs associated with stricter capital requirements
The Commonwealth Bank to lift its home loan interest rates independently of the Reserve Bank to partially offset costs associated with stricter ...

Washington Square Signs Spielbergs, Choi Joins Variable and More
... films and an episode of the HBO comedy series "Girls," on which he plays the role of Ray Ploshansky. New York-based creative collective Variable ...

Mozilla moves Firefox to variable release schedule
... schedule process "carefully" and learning "a lot" from it in the past years, Mozilla has announced that Firefox is now moving to a variable ...

"You have to ignore many variables to think women are paid less than men. California is happy to try." ...
Writes Sarah Ketterer in The Wall Street Journal in "The ‘Wage Gap’ Myth That Won’t Die" (which you can get to without subscribing if you Google ...

Staley: 'A lot of different variables...been a hard year'
... 41° Navigation Home Giants A's Sharks Warriors Kings 49ers Raiders Quakes Insiders More Tickets Shop Watch Staley: 'A lot of different variables...been ...

When your environment variables are showing
There are embarrassing moments in life. There is the teacher calling you out as a child in class as you stare out the window wistfully imagining ...

Resources last updated: 3/18/2016 2:17:07 PM