f



Re: How to get rid of warning message from proc dataset #3

On Mon, 1 Oct 2007 10:59:47 -0700, Mindy <master2005_sas@YAHOO.COM> wrote:

>Hey, guys,
>
>I submitted the followin codes, and get warning message as "Warning:
>No matching members in directory". I cheked some papers, SAS gave such
>message when library is not specified. But in my case, the library is
>defined.
>And the warning still exists the second time I run the code. Does any
>one know how to get rid of the warning? (note: try is a sas dataset) .
>Many thanks.
>
>libname temp 'C:\Documents and Settings\Desktop\test';
>libname t2path 'C:\Documents and settings\Desktop\test\sub_m';
>
>proc datasets;
>  copy in=temp out=t2path;
>  select try;
>quit;
>Mindy

Try removing IN=TEMP from the COPY statement and instead code LIBRARY=TEMP
in the PROC statement. It actually seems to work either way, but using 9.1.3
I do see that spurious warning.

   libname temp   'c:\temp\a';
   libname t2path 'c:\temp\aa';

   data temp.try;
   run;

   proc datasets;
   copy in=temp out=t2path;
   select try;
   quit;

   proc datasets library=temp;
   copy out=t2path;
   select try;
   quit;
0
nospam1405 (4666)
10/2/2007 6:01:17 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
375 Views

Similar Articles

[PageSpeed] 23

Reply:

Similar Artilces:

Re: How to get rid of warning message from proc dataset
Mindy, Do you still get the warning if you use double quotes {") rather than single quotes (') in the libname statements? Art ------ On Mon, 1 Oct 2007 10:59:47 -0700, Mindy <master2005_sas@YAHOO.COM> wrote: >Hey, guys, > >I submitted the followin codes, and get warning message as "Warning: >No matching members in directory". I cheked some papers, SAS gave such >message when library is not specified. But in my case, the library is >defined. >And the warning still exists the second time I run the code. Does any >one know how to get rid of the warning? (note: try is a sas dataset) . >Many thanks. > >libname temp 'C:\Documents and Settings\Desktop\test'; >libname t2path 'C:\Documents and settings\Desktop\test\sub_m'; > >proc datasets; > copy in=temp out=t2path; > select try; >quit; >Mindy On Oct 1, 11:32 am, art...@NETSCAPE.NET (Arthur Tabachneck) wrote: > Mindy, > > Do you still get the warning if you use double quotes {") rather than > single quotes (') in the libname statements? > > Art > ------ > > > > On Mon, 1 Oct 2007 10:59:47 -0700, Mindy <master2005_...@YAHOO.COM> wrote: > >Hey, guys, > > >I submitted the followin codes, and get warning message as "Warning: > >No matching members in directory". I cheked some papers, SAS gave such > >message when library is not specified. But in my case, ...

Re: How to get rid of warning message from proc dataset #2
Mindy, Your code works, on my system, as originally written. Thus, two more questions: (1) does try exist in libname temp? and (2) is try a SAS dataset of the same version as the version of SAS you a running? Art ------- On Mon, 1 Oct 2007 20:43:44 -0000, Mindy <master2005_sas@YAHOO.COM> wrote: >On Oct 1, 11:32 am, art...@NETSCAPE.NET (Arthur Tabachneck) wrote: >> Mindy, >> >> Do you still get the warning if you use double quotes {") rather than >> single quotes (') in the libname statements? >> >> Art >> ------ >> >> >> >> On Mon, 1 Oct 2007 10:59:47 -0700, Mindy <master2005_...@YAHOO.COM> wrote: >> >Hey, guys, >> >> >I submitted the followin codes, and get warning message as "Warning: >> >No matching members in directory". I cheked some papers, SAS gave such >> >message when library is not specified. But in my case, the library is >> >defined. >> >And the warning still exists the second time I run the code. Does any >> >one know how to get rid of the warning? (note: try is a sas dataset) . >> >Many thanks. >> >> >libname temp 'C:\Documents and Settings\Desktop\test'; >> >libname t2path 'C:\Documents and settings\Desktop\test\sub_m'; >> >> >proc datasets; >> > copy in=temp out=t2path; >> > select try; >> >quit; &g...

Re: How to get rid of warning message from proc dataset #4
Coding NOLIST also works. 52 proc datasets nolist; 53 copy in=temp out=t2path; 54 select try; 55 quit; NOTE: Copying TEMP.TRY to T2PATH.TRY (memtype=DATA). NOTE: There were 1 observations read from the data set TEMP.TRY. NOTE: The data set T2PATH.TRY has 1 observations and 0 variables. NOTE: PROCEDURE DATASETS used (Total process time): real time 0.01 seconds cpu time 0.00 seconds I think RROC DATASET is try applying the SELECT to the list of library members it prints by default. With no LIBRARY= option it defaults to WORK, but TRY does not exist. I had to see your example to understand the question. On 10/2/07, Howard Schreier <hs AT dc-sug DOT org> <nospam@howles.com> wrote: > On Mon, 1 Oct 2007 10:59:47 -0700, Mindy <master2005_sas@YAHOO.COM> wrote: > > >Hey, guys, > > > >I submitted the followin codes, and get warning message as "Warning: > >No matching members in directory". I cheked some papers, SAS gave such > >message when library is not specified. But in my case, the library is > >defined. > >And the warning still exists the second time I run the code. Does any > >one know how to get rid of the warning? (note: try is a sas dataset) . > >Many thanks. > > > >libname temp 'C:\Documents and Settings\Desktop\test'; > >libname t2path 'C:\Documents and settings\Desktop\test\sub_m'; > > > &g...

How to get rid of warning message from proc dataset
Hey, guys, I submitted the followin codes, and get warning message as "Warning: No matching members in directory". I cheked some papers, SAS gave such message when library is not specified. But in my case, the library is defined. And the warning still exists the second time I run the code. Does any one know how to get rid of the warning? (note: try is a sas dataset) . Many thanks. libname temp 'C:\Documents and Settings\Desktop\test'; libname t2path 'C:\Documents and settings\Desktop\test\sub_m'; proc datasets; copy in=temp out=t2path; select try; quit; Mindy ...

How to get rid of warning message from proc dataset #2
Hey, guys, I submitted the followin codes, and get warning message as "Warning: No matching members in directory". I cheked some papers, SAS gave such message when library is not specified. But in my case, the library is defined. And the warning still exists the second time I run the code. Does any one know how to get rid of the warning? (note: try is a sas dataset) . Many thanks. libname temp 'C:\Documents and Settings\Desktop\test'; libname t2path 'C:\Documents and settings\Desktop\test\sub_m'; proc datasets; copy in=temp out=t2path; select try; quit; Mindy ...

Re: combine n SAS datasets in to one SAS dataset. #3
Here's another option using julian dates: %macro julday(year); %do i=1 %to 365; data _null_; day=datejul(&year*1000+&i); date=put(day,yymmddn8.); call symput("yymmdd",date); put day= date=; run; %put yymmdd=&yymmdd; proc append base=file_history new=file&yymmdd.;run; %end; %mend; %julday(2007); At 11:44 AM 1/18/2008, Howard Schreier <hs AT dc-sug DOT org> wrote: >On Thu, 17 Jan 2008 12:06:01 -0800, stulkem@YAHOO.COM wrote: > > >Thanks for your help in advance! > > > >I have hundreds of SAS datasets that I want to combine into one SAS > >dataset. > > > >For example, I want to set file20070101.sas7bdat - > >file20071231.sas7bdat (365 total files) into > >file_history.sas7bdat. > > > >How can I write this into a macro or array or whatever will work so I > >don't have to write each individual file name?? > > > >Thanks again! > > > >Mark > >You must provide some rule or process which SAS can use to discover the >names of the data sets to be processed. > >Here is how I might deal with the example (one file for each day of a >calendar year): > > data _null_; > call execute('proc datasets library=mylib nolist;'); > call execute('delete file_history;'); > call execute('run;'); > do day = '01jan2007'd to '31dec2007'd; > call execute('ap...

Re: Proc Format from SAS Dataset #3
On Thu, Feb 19, 2009 at 8:29 PM, Abc Unha <abcunha@yahoo.com> wrote: > I have a SAS dataset that contains Start value and end value. I would like > to create format using that SAS Dataset. I want create format only using > proc format (with out manipulating sas dataset) > Are you looking for something like this? data have; input Start:$16. Description &$64.; datalines; UGA University of Georgia GTECH Georgia Tech ; run; proc sql noprint; select ("'" || strip(start) || "'") into :startlist separated by '|' from have; select ("'" || strip(description) || "'") into :descriptionlist separated by '|' from have; select count(*) into :num_vals from have; quit; %let num_vals = %cmpres(&num_vals); %put &num_vals &startlist &descriptionlist; options mprint; %macro buildformats(); proc format; value $myfmt %do i = 1 %to &num_vals; %scan(&startlist, &i, |) = %scan(&descriptionlist, &i, |) %end; ; run; %mend buildformats; %buildformats() Regards, Anindya ...

Re: how to get rid of square symbol in my sas dataset
Patrick, Thanks a lot. Ascii worked like a magic. I was using a default ftp before. Thanks. On Thu, 7 Aug 2008 14:14:19 -0700, Patrick <patrick.matter@GMX.CH> wrote: >Hi Hari >Have a look at the tread "removing hidden characters" from today. >Regards >Patrick > >P.S: Are you ftp'ing BIN or ASCII? Try ASCII and have a look if this >square still exists. ...

Re: Output the Results of a Proc Freq To A SAS Dataset #3
Here's an example; note that this produces the **wrong** results if the data set indicated to send ODS output is not deleted or initialized = before using. I taught computer programming for 5 years, and thus = initialization is one of the things I drilled into my students, and thus is drilled into = myself. =20 data test; infile cards missover; input disease rs10 rs20; cards; 0 0 1 0 0 2 0 0 1 0 1 1 0 1 2 0 1 2 0 2 2 0 2 1 0 2 2 0 2 1 0 1 1 0 1 2 0 1 2 0 2 2 1 0 1 1 0 2 1 0 1 1 1 1 1 1 2 1 1 2 1 2 2 ; run; %macro run_logistic(variable_name); ods output OddsRatios=3DOddsRatios_set1 GlobalTests=3DGlobalTests_set; proc logistic data=3Dtest; class &variable_name(param=3Dref ref=3D"0"); model disease(DESC)=3D&variable_name; run; data globaltests_set2; set globaltests_set; variable=3D"&variable_name"; if test=3D'Likelihood Ratio'; run; data allset; set allset globaltests_set2; run; %mend run_logistic; data allset; stop; run; %run_logistic(rs10); %run_logistic(rs20); -Mary ----- Original Message -----=20 From: Mary=20 To: Virtual SUG ; SAS-L@LISTSERV.UGA.EDU=20 Sent: Monday, December 29, 2008 9:21 AM Subject: Re: Re: Output the Results of a Proc Freq To A SAS Dataset VirtualSUG, The reason I specified initialization is that if there is an error in = that procedure, then SAS does not create the ODS output data set. If a data set by = that name already exists, then it will thus not b...

Re: How to put proc glm output in sas dataset #3
Kathleen, You could do this with GLM, though you may find the output from PROC MIXED easier to work with and manipulate as you describe, such as the following revised code illustrates: ODS OUTPUT LSMEANS=lsm DIFFS=dfs solutionF =solfF; ODS exclude lsmeans DIFFS solutionF; proc MIXED data=azmi3 NOitPrint; class x; model y=x / solution; lsmeans x / pdiff=control('4') cl adjust=dunnett; run; quit; proc print data=solfF NOObs; run; proc print data=lsm NOObs; run; proc print data=dfs NOObs; run; The LSMEANS statement with the diff and dunnett option essentially computes the three t-tests you describe making adjustments to the pvalues and confidence intervals when you have multiple comparisons. Doing this 'several' times is another issue, that could perhaps be expanded upon with this code by adding another CLASS variable, rather than running it over and over -- and then look into the features of GLIMMIX. Robin High UNMC Kathleen Santos <flowerpotcat@GMAIL.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 04/20/2009 04:45 PM Please respond to Kathleen Santos <flowerpotcat@GMAIL.COM> To SAS-L@LISTSERV.UGA.EDU cc Subject How to put proc glm output in sas dataset Hi, I'm doing a simple ttest using proc glm. My class variable, x, has four groups. I would like to compare the mean of y for the following categories of x: 4 vs 1 4 vs 2 4 vs 3, where 4 is my reference category. I used this code: * PROC* *GLM *D...

Re: getting results from multiple proc means into single dataset #3
Nguyen Your example shows you comparing New_var1 and Old_var1 and in your note to me, you say that the names of the variables are not the same in the data sets. How can you match the names if they are different? Let me point out that one thing that might make the process easier would be to transpose (SAS term for pivot) the data sets and use the SAS by group processing to do the stats on each variable. Data nguyen; input age height weight ; line+1;* this is needed for the transpose; cards; 22 5.6 140 33 5 120 60 6.5 190 45 6.0 175 Proc transpose out = nguyen; by line; run; * by default, the name of the former variable will be _name_ and the value is col1; Proc sort; by _name_; run; proc Means noprint; output out = newfile min= min mean = mean max=max ; var col1; by _name_; run; Now, if there is some progromatic way to change the variable names so that they correspond to one another in the two data sets and if you name the output variables in your two Proc means something line Min1 and Min2, you could use Data New; merge newfile oldfile; by _name_; I hope this helps. Nat Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Nguyen An Nguyen <nguyenannguyen@G MAIL.COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU ...

Re: How to get Rid of Tab or Eof markers from Excel sheet to SAS #3
On Fri, 29 Feb 2008 13:40:31 -0500, SAS_learner <proccontents@GMAIL.COM> wrote: >Thanks Howard Yes that helped in eliminating the unwanted characters but >also took away the Space . > >Is something Possible with Transward Function or any other similar Function >where I can change the Unprintable character into a Space . Good ways to find out: (1) look at the documentation for character functions and (2) experiment. > >thanks > > >On Fri, Feb 29, 2008 at 1:09 PM, Howard Schreier <hs AT dc-sug DOT org> < >schreier.junk.mail@gmail.com> wrote: > >> On Fri, 29 Feb 2008 12:37:27 -0500, SAS_learner <proccontents@GMAIL.COM> >> wrote: >> >> >Hello guys, >> > >> >I am Importing an Excel file using SAS 9. The excel File I think has lot >> of >> >Tab's or Line feeds or some things resulting in having funny characters >> in >> >the dataset. They are usually at the end of Line (Box's ). How do I can >> get >> >rid of them. >> > >> >For Example a Field in Excel has >> >Day 1 >> >Post-op- No VAS performed >> > >> > >> >I am getting a weired character at the end of the Day 1 >> > >> >thanks >> >> Try (not tested): >> >> Day_1 = compress( Day_1 , ' ' . 'kw' ); >> >> That should preserve all printable ch...

Re: Create a dataset using no IO
Jack - You are correct you cant move anything w/o IO, I guess I really meant that I wanted to move it w/o dealing with a lot of IO being copied to the buffer. For eg Oracle's data pump allows for direct path load which does not go through the main buffer. (I think) Anyway, your suggestion to use the native file commands are exactly what I was looking for! Thanks for the suggestion, I have to move a lot of data from a staging library to a live library and if I created a batch file in Windows to run that, I would use the least amount of IO which is my goal! Does anyone know how to make a SAS dataset read only? I did some reading and was a little confused. Say I had the below. data A; set B; run; now what can I do to A to get it read only? Thanks so much! On Sun, Oct 19, 2008 at 4:12 PM, Jack Hamilton <jfh@alumni.stanford.org>wrote: > Why do you think that Oracle Data Pump uses no I/O? How would data get > from one place to another if no I/O is involved? > > No, you can't move data without doing I/O in some form. > > If you are moving a SAS data file from one location to another on the same > platform, you might be able to use native file commands to reduce the number > of I/O operations; copying a file directly is probably more efficient than > doing it in SAS. > > The method you propose below is perhaps the least efficient possible > method. If you use a SAS proc intended for data movement, such as PROC COPY > o...

Re: Get meta data of XPT file without converting to SAS dataset #3
Thanks Sig, I was aware of this. But this means that I have to get the list of file names from the folder (probably with pipe), then loop through the list to 'unpack' the files individually. I think the key here is that for XPORT optioned libname, it has to be followed by a file name, NOT a folder name. Ya -----Original Message----- From: Sigurd Hermansen [mailto:HERMANS1@WESTAT.com] Sent: Thursday, October 15, 2009 11:42 AM To: Huang, Ya; SAS-L@LISTSERV.UGA.EDU Subject: RE: Get meta data of XPT file without converting to SAS dataset first? Ya: I haven't work with XPORT engine...

Re: Deleting SAS Data from a SAS DATASET #3
The disadvantages of using SQL delete are (1) NOBS= is no longer accurate, and (2) POINT= may behave unexpectedly. If those are not issues, then the delete would be faster, with or without an index, than recreating the data set (especially if the data set has indexes that would need to be rebuilt). -- Jack Hamilton jfh@alumni.stanford.org On Aug 15, 2008, at 11:17 am, Mary wrote: > One thing you might do is to add an index on the snap_dt to the > dataset; if that's there then you should be able to delete the > records in place: > > proc sql; > delete from prod.master_date; > where snap_dt = "&end_dt"d; > quit; > run; > > In both the ways you are trying now you are creating new data sets > rather than deleting records from the current data set; it would > seem to me that a SQL delete statement would be faster than creating > new datasets even if there isn't an index on the date. > > -Mary > ----- Original Message ----- > From: SUBSCRIBE SAS-L Chandra Gadde > To: SAS-L@LISTSERV.UGA.EDU > Sent: Friday, August 15, 2008 12:14 PM > Subject: Deleting SAS Data from a SAS DATASET > > > Hi All > > I have several SAS datasets that are very very big. (50GB of size). > Every > month, the data is being appended to these datasets. I need to > deleted the > data which is greater than 24 months. What is the best method to do > this? > Please help me. > ...

Re: How to transfer .net dataset to sas dataset #3
Hello I believe you have a few things to consider ... performance and simplicity. From my experience, XML is a great format but the overhead you wish to impose with the tag structure for 30 000 - 90 000 records can create an XML file with a huge amount of overhead meta information. If you just wish to dump your data into SAS from the .net application, then a self-describing file format such as XML may not be the most simple answer. To get things moving on your end, I would suggest you try looking att creating a comma separated file and dumping into SAS. If that works, you can then start movi...

Re: SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)
A question in return: is your table from windows? compressed from another system? and specially with personnel formats hard coded inside? Andre msiddu2000 a �crit : > SAS System Viewer 9.1 was able to open datasets that were created by > V8 engine (SAS 8.2), but is unable to open datasets that are created > with V9 engine (SAS 9.1.3). > > Does this need SAS System Viewer to be upgraded ? > or > Something else needs to be done ? > > -- 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: 9.1.3 Proc sql Message => WARNING: This CREATE TABLE statement recursively references the target
One wonders why the equivalent DATA step data CardData; merge CardData LimitData; by Acc_No; run; does not generate the same warning. Iin either case, it's not a recursive reference. It's simply a process which replaces a pre-existing dataset, just as PROC SORT does when the OUT= option is not coded. On Fri, 3 Dec 2004 02:22:37 -0800, Xavier Autret <xav_x@NOOS.FR> wrote: >Hi, > >I've got the same message in 9.1.3 > >Can I turn on an option for switching this off? >Thks > >Xavier > >************************************************...

Re: Difference Between PC SAS and UNIX SAS but getting off topic #3
Mary I was at NCSU and left in 1973. One of the young stat profs, Ron Gallant, if memory serves, came up with the Ames story. And I, too, do not recall the days of punched cards at all fondly. 1) you had to wait for a job to be read in. 2) cards became damaged on the edges from wear and had to be replaced regularly 3) you could drop the deck and scramble it. There were ways around this but they were imperfect 4) I had one experience with a new card reader which, upon encountering a damaged card, made you think that it was a different card that was the problem and one or more of your cards from that was read through the reader was/were never seen by the system. 5) try inserting new characters between columns on a punch card. There are more of these but I would rather not remember them. Nat vironmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Mary <mlhoward@AVALON. NET> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Difference Between PC SAS and UNIX SAS but getting off topic 06/...

Re: AW: Re: Proc FCMP
See also: SASHELP.VFUNC (SAS 9.2) -Randy -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Robin R High Sent: Friday, February 27, 2009 2:10 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: AW: Re: Proc FCMP - how to override SAS own functions Carina, What appears to be a "complete" listing of function names for version 9.2 is available at: http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000245860.htm Though there are many functions to choose from, the capability to write one's own is a real plus. Robin High UNMC "Ortseifen, Carina" <carina.ortseifen@URZ.UNI-HEIDELBERG.DE> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 02/26/2009 05:01 AM Please respond to "Ortseifen, Carina" <carina.ortseifen@URZ.UNI-HEIDELBERG.DE> To SAS-L@LISTSERV.UGA.EDU cc Subject AW: Re: Proc FCMP - how to override SAS own functions Dear Gerhard, Obviously it is easier to use another name. But what about the fact that I don't know that there is a function with name XY and wondering why the own function don't run. Mit freundlichen Gr��en Carina -- Dr. Carina Ortseifen Abteilung Anwendungen Tel. (06221) 54-45 41, Fax (06221) 54-55 81 carina.ortseifen@urz.uni-heidelberg.de Ruprecht-Karls-Universit�t Heidelberg Universit�tsrechenzentrum (URZ) Im Neuenheimer Feld 293, 69120 Heidelberg http://www.urz.uni-heidelberg.de -- 13. KSFE 2009 in Ha...

Re: Storing SAS-programs and -macros in SAS-datasets on a HOST-platform #3
Hi. Howard is correct (no surprise). You can use the catalog access method on the FILENAME statement to write entries to a catalog, then use %INCLUDE to use the entries. There's a lot of info in the on-line help (using SAS on a PC)... FILENAME fileref CATALOG 'catalog' <catalog-options>; The CATALOG access method in the FILENAME statement enables you to reference a SAS catalog as an external file. You can then use any SAS commands, statements, or procedures that can access external files to access a SAS catalog. etc. Then, CPORT and CIMPORT can be used to exchange the...

Re: How to get the location of SAS code in the same SAS code thru #3 685847
> From: Alok > I am facing a problem in which I need to get the > location/path of a SAS code in a macro variable. I need to > use the macro variable in the same SAS code. Is there any SAS > option available which can do this for me? Or is there a code > snippet which can achieve the same purpose? - - - MyMacro.sas - - - %macro MyMacro(path=); %*...; %Mend; - - - MyProgram.sas - - - %Let Path2MyMacro = c:\temp\MyMacro.sas; %Include "&Path2MyMacro."; %MyMacro(path = &Path2MyMacro.); Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov ...

Re: SAS community.org and good questions (was Re: where is proc #3 687085
Thanks Diane. www.sasCommunity.org is built primarily using Mediawiki software (the same software that wikipedia uses). Down the left hand side under 'getting started' we had a link called 'Using a Wiki' that brought you to a feature list that had lots of links to pages with details on using a wiki as well as editing wiki pages. We have now updated that so 'Using a Wiki' now brings you to an article (the wiki term for a page) that has a number of useful links that could be found by a careful reading of the features page. We hope that adding these select few links will...

Re: Excel2007 & SAS 9.1.3 (PROC Export or Import) #3
Reeza, I wanted to test out my data management tool and what better than a way to convert an Excel 2007 file to a SAS dataset from the command line. The utility can be found here: http://utilities.savian.net/ #24 The utility installs to Program Files/Savian/ConvertExcelToSas. Execute the ConvertExcelToSas with a /? Command to see the usage. You also need the Sas OleDb tool and the SAS Local Provider to make it all happen. All free. I also updated the demo on sascommunity.org of my Savian Data Management tool to illustrate how to do this in code. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Reeza Sent: Tuesday, October 09, 2007 10:35 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Excel2007 & SAS 9.1.3 (PROC Export or Import) On Oct 9, 5:20 pm, savian...@GMAIL.COM (Alan Churchill) wrote: > Caveat time. > > I only do exporting and not importing into SAS. Excel 2007 uses a completely > different file format (zipped XML) than Excel 2003. Hence, in order to > import Excel 2007 into SAS you would need to save it as an Excel 2003 format > first or save it as something else (tab-delimited). You could probably also > set up an OleDb or ODBC connection to it since SAS shouldn't care. > > Excel 2007, IMO, is worth the hassle. It is an incredible tool and certainly > is a strong BI platform. > > Alan > > Alan Churchill > Savianwww.savia...

Web resources about - Re: How to get rid of warning message from proc dataset #3 - comp.soft-sys.sas

Ballistic Missile Early Warning System - Wikipedia, the free encyclopedia
Site I- A United States Air Force facility at Thule Air Base , Greenland , ( 76°34′08″N 68°19′05″W  /  76.569°N 68.318°W  / 76.569; -68.318 ...

WARNING: Zeus Trojan Using Facebook Login Pages As Bait To Target Credit-Card Info
The Zeus Trojan is on the prowl again, hungry for credit-card information and other personal data, and Facebook is being used as the bait. continued… ...

Police ignored warnings about planned violent rampage
Victoria Police ignored credible warnings that a violent rampage was planned for Melbourne's CBD on Saturday night, despite holding recent discussions ...

Severe thunderstorm warning issued for east of Canberra
... storm is expected to pass to the north and east of the ACT on Monday afternoon. The Bureau of Meteorology has issued a severe storm warning, ...

Nishiazabu sounds ominous warning for Easter
TALENTED South Australian jumper Nishiazabu stamped himself as a serious contender for the upcoming Oakbank Easter Carnival after an impressive ...

I'm A Celebrity ignored warnings from animal welfare groups when using lion cubs
Ten producers were warned the cubs they were using were being commercially trafficked, but network says it did nothing wrong.

Police ignored 'st' Triple-0 warning just hours before CBD rampage they now say was 'surprise'
Credible warning that violent rampage in Melbourne's CBD was brewing was brushed off by senior Victoria Police officers just hours before Saturday ...

South China Sea: US warning 'might makes right' imposed on Asia
A resurgent trend of "might makes right" has settled over vulnerable waters in the South China Sea, the commander of the US Pacific fleet has ...

Samsung talks up Galaxy S7 preorders while warning that phone biz is in trouble
There were mixed messages out of South Korea on Friday as Samsung , the world's top smartphone vendor by shipment volume, officially launched ...

Valeant Plunges Most Ever on Forecast Cut, Warning Over Debt
Valeant Pharmaceuticals International Inc. shares plunged Tuesday in their worst day ever, falling 51 percent after the company cut its 2016 ...

Resources last updated: 3/17/2016 6:58:37 PM