f



Re: Problem with dictionary.tables #2

proc sql noprint;
         select 'Perm.'||memname into :dsn separated by " "
         from dictionary.tables where libname = "PERM";
quit;

data result;
set &dsn ;
run;





Toby Dunn





From: "antje.schuele@googlemail.com" <antje.schuele@GOOGLEMAIL.COM>
Reply-To: "antje.schuele@googlemail.com" <antje.schuele@GOOGLEMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Problem with dictionary.tables
Date: Mon, 26 Jun 2006 08:09:13 -0700

Dear Newsgroup,

I'd like to set a few tables together. That's why I read out my needed
tables with the help of dictionary.tables:

Here's my code:

proc sql noprint;
         select memname into :dsn separated by " "
         from dictionary.tables where libname = "PERM";
quit;

data result;
         set perm.&dsn;
run;

Now my problem: The data set result only takes the first table from the
library perm, the other tables are taken from the work library. Is
there a possibility to tell SAS that all tables that are set in result
are in the library "perm"?

Thank for any help.

Antje
0
tobydunn (6020)
6/26/2006 3:13:19 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
593 Views

Similar Articles

[PageSpeed] 54

Reply:

Similar Artilces:

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: FTP problem in SAS v9.2 #2
The problem may be with Windows Firewall/McAfee/Other Antivirus programs blocking all but some programs from using FTP. > Our program run on z/OS, but the same problem occurs on windows. > There is no problem accessing the same ftp server from a native ftp client, and ping works as well. > > I have opened an issue with SAS. > > Gadi > > > ...

Re: SAS time problem and formula problem #2
Please re-post your second question and present the formula in-line, as part of the message. SAS-L does not allow attachments. Also make it a separate posting, with its own subject. When a person has two or more unrelated questions, there is no reason to bundle them in one posting. It's not as if one has to pay for postage. Making a separate posting for each question, with appropriate subjects, makes it much easier to carry on and follow the discussions. On Mon, 3 Nov 2003 11:51:14 +0000, Vijay Reddi <Vijay.Reddi@SSL- INTERNATIONAL.COM> wrote: >Hi All, > >I have two probl...

Re: Newbie SAS Array problem (take 2) #2
Hi Machelle, Nice, good. But you should also declare your arrays dxnum and diagnum as being of character type. And I would even completely avoid this kind of solution. I would use a format instead (with some arrays or some macro code). Create a format for your 46 diagnose codes, like: PROC FORMAT; VALUE $DiagFmt '4270' = 'Paroxysmal supraventricular tachycardia' .............and so on............. ; RUN; And if it is just for presentation then never create a variable with the textual diagnoses, but use the code variables (dx#) instead with the format. If you really n...

Re: TABLES TABLES TABLES #2
OHHH went there, did that, got the t-shirt, even. I tried everything in the book. This person is extremely LITERAL and looking for the letter of the law, or something........maybe my trying so hard just egged him on, or his stubbornness that kept his feet in concrete, but I don't think so. He truly believes that. -----Original Message----- From: David L Cassell <davidlcassell@MSN.COM> To: SAS-L@LISTSERV.UGA.EDU Sent: Sun, 27 Nov 2005 11:55:12 -0800 Subject: Re: TABLES TABLES TABLES sasbum@AOL.COM wrote: >How would you best describe to a retiscent SAS student that the concept...

Re: problem when installing SAS. windows x64 does not support SAS? #2
Elodie, Take a look at: http://support.sas.com/kb/16/568.html HTH, Art --------- On Wed, 14 May 2008 07:54:57 -0700, elodie.gillain@GMAIL.COM wrote: >Hi everyone > >I am trying to install SAS on a Vista machine. > >The setup wizard says that Windows x64 does not support the SAS >version I am trying to install. > >What can I do? > >I greatly appreciate your help. ...

Re: SAS 9.2 Update on problem re Help files
On Mon, 25 Aug 2008 09:25:35 -0400, "Peter Flom" <peterflomconsulting@MINDSPRING.COM> said: > Hi again > > A week ago, I asked this list about a problem with 9.2: When you click > "help" it runs an index, but it doesn't save the index when you quite > SAS, so, each time you quit SAS, you lose the index. > > Replies received here did not work, so I wrote to SAS. > > They said, essentially, that it's a known bug, and they are working on > it. So you're responsible for the item in today's Tech Support Notes. Congratulations! That's almost as good as having a disease that gets you mentioned in the MMWR. > > Peter > > Peter L. Flom, PhD > Statistical Consultant > www DOT peterflom DOT com -- Jack Hamilton Sacramento, California jfh@alumni.stanford.org <== Use this, not jfh@stanfordalumni.org ...

Re: SAS 9.2 Update on problem re Help files #3
Yes, I encountered the same problem, although I hadn't got around to contacting SAS. AnnMaria DeMars, Ph.D. Senior Statistical Consultant University of Southern California Customer Support Center Information Technology Services ademars@usc.edu (213) 740-2840 On Aug 25, 2008, at 6:25 AM, Peter Flom wrote: > Hi again > > A week ago, I asked this list about a problem with 9.2: When you > click "help" it runs an index, but it doesn't save the index when > you quite SAS, so, each time you quit SAS, you lose the index. > > Replies received here did not work, so I wrote to SAS. > > They said, essentially, that it's a known bug, and they are working > on it. > > Peter > > Peter L. Flom, PhD > Statistical Consultant > www DOT peterflom DOT com ...

Re: Re[2]: (wx-users) Re: problems with wxMSW 2.8.0
VZ wrote on 25-JAN-2007 12:42:40.23 >JJ> In the application the bitmap (and also lines, text etc..) are generated by a >JJ> a procedure that is called from another language than c++ (i.e. C or F90) > > Why should it matter? > >JJ> By doing so the EVT_PAINT is not activated and the class of "canvas" is not >JJ> known. > > I don't understand this, sorry. The problem is that some c++ objects are not properly defined. One would like to call routines bbbb::ccccc. But that is not always allowed. >>JJ> So you need at least a way to force the EVT_PAINT (how do I do this?). >>JJ> However, I prefer the code as it is (and works in wxGTK) so that I can >>JJ> "draw directly" to the window, without manualy calling the event-handler. > > This is wrong if only because your window won't be repainted correctly if >the user covers it with another one or minimizes and then restores it. Not when these are temporary drawings like "counters". Ofcourse I also wrote the bitmap at repaint-time. To have everyting in the EVT_PAINT routine requires a lot of book-keeping of the program about what was drawn and what was erased etc. Cannot this be automated? In X-windows I normally switch on the Backingstore option, which keeps an image of the window in memory at the server side. Can this also be done in wxWidgets? >JJ> What would be the reason for w...

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: SAS Problem. #2
sas__l@HOTMAIL.COM expertly replied: >Hello, use SAS dates for computing time intervals and such.. >BUT >what is this? Has these two id's been hospitalized 5 times >in this short period? Poor fellas! >Is "enter" .. well, entering .. and "disc" a folowing visit, or? >Please explain if this doesn't get you going. > >data t1; > input enter : ddmmyy10. disc : ddmmyy10. x $ 23 id 25; > interval=intck( 'days', enter, disc); > . . . . . Yes. I agree. Good points all. And, since SAS dates are just the number of days since 1/...

Re: Problem with dictionary.tables
Antje, Try following code see if it works: proc sql noprint; select "perm."||memname into :dsn separated by " " from dictionary.tables where libname = "PERM"; quit; data result; set perm.&dsn; run; YU On 6/26/06, antje.schuele@googlemail.com <antje.schuele@googlemail.com> wrote: > > Dear Newsgroup, > > I'd like to set a few tables together. That's why I read out my needed > tables with the help of dictionary.tables: > > Here's my code: > > proc sql noprint; > select memname into :dsn separated by " " > from dictionary.tables where libname = "PERM"; > quit; > > data result; > set perm.&dsn; > run; > > Now my problem: The data set result only takes the first table from the > library perm, the other tables are taken from the work library. Is > there a possibility to tell SAS that all tables that are set in result > are in the library "perm"? > > Thank for any help. > > Antje > ...

Re: Dictionary problem #2
Hi, Antonmuhin, Alex and Batista, as I can use only Python 2.1 dict() is not allowed I guess. The .copy() trick works on the simple example I gave. Thanks a lot for your hints. But my real problem is more complex (nested dicts) like this: p_settings = {} for item in items : p = myList # a list for i in range(10) : for setting in p[i] : p_settings['anotherString']['aString'] = myString object_dict = {'id':'anotherString', 'settings':p_settings} object_perms_list.append(object_dict) here the copy()-trick does not work. How ...

Re: DICTIONARY.TABLES #2
libnames are stored in UPPERCASE in dictionary.tables. On 10/25/07, SAS-FU <lee.rozzelle@gmail.com> wrote: > Any ideas why this simple code to access dictionary metadata is > returning 0 observations? I do this all the time, and Im at a new > contract site and I feel like im taking crazy pills. > > Thanks in advance. > > > libname q 'R:\AD-HOC\MAX_Data\DEMO'; > > proc sql; > create table aaa as > select memname > from dictionary.tables > where libname = 'q'; > quit; > ...

SAS/Warehouse Administrator Problem?? or SAS/ACCESS problem?? #2
hello, I've built a process in SAS/Warehouse Administrator, where i'm trying to extract distinct cities from the 3 tables(source schema) in Oracle into a new table (target schema) called CITY and again into UniqueCity (target schema) bcos of some redundancy. The process looks like this. Unique City | | mapping | | CITY ...

Re: SAS evaluation problems #2
But you should know that SAS-L prefers to help people with programs rather than do work for people. What is=20 your first-pass solution to these problems and where are you having trouble? -Mary ----- Original Message -----=20 From: John Burton=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Monday, February 23, 2009 1:04 PM Subject: SAS evaluation problems Hi all, I am filling out a SAS skills evaluation from a potential client. The instructions state that it is not to necesarily test one's knowlegde, but how they can use available resources to help solve problems. and would like to use you as a technical reference if you don't mind. (it is allowed per the instructions) "In order to complete the evaluation, the SAS Developer will require access to the SAS System and optionally online access for research purposes. All the data required is available within SAS by default or is described in the task itself. ... Developers may also need to place tickets with SAS to answer some of these questions. This evaluation is not to find out how much a Developer knows but test their resourcefulness in solving problems using the tools that are generally available to SAS Developers. If you do not have an answer to a question, describe what you would do in that situation. You can't ignore the question but what would you do if the situation occurred in real life where brushing in under the carpet is not a solution." Doing ...

Re: SAS install problem #2
Joe, I know time is well against you now on this, and this advice may come too late. I searched the MSDN blogs and came up with this entry: http://blogs.msdn.com/ie/archive/2006/06/29/650098.aspx Interestingly, it concerns a Lenovo machine, issues with the System Migration Assistant and use of IE7. I also observe that I haven't seen a note from SAS yet withdrawing their advice that SAS 9.1.3 is not compatible with IE7. I hope you find, or have found a solution. Kind regards David "Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit..." -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of F. J. Kelley Sent: Friday, 25 May 2007 1:28 AM To: SAS-L@LISTSERV.UGA.EDU Subject: SAS install problem Checking on the collective wisdom of the group ... A faculty member is installing SAS V9.1.3 on a Lenovo T60p, running Windows XP Professional with Service Pack 2; Core 2 Duo processor (T7400 @2.16 GHz), 994 mHz, 2 GB RAM. new machine, never had SAS on it. Gets to "SAS shared components CD". chokes asking for location for the SMAsetup.msi file Install says it is looking in C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\_isF6\SMAsetup.msi and claims it can't find it there. some searching suggests this may be an old ms install file (and checking the CDs our software distribution folks are using shows them to be circa "29 Sept 2004"), but this is the very first time I h...

Re: SAS concatenation problem #2
Llyod, The reason you are getting a variable with the length of one is more than likely the fact that the first data set you bring in the data step has a missing value for that variable (the first data set is setting the length of your variables for all the datasets you are brining in.). The easiest way to solve the problem is to use a length statement and set the variable(s) to the length you desire. HTH Toby Dunn -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Lloyd Dollins Sent: Thursday, September 16, 2004 2:19 PM To: SAS-L@LISTSERV.UGA.EDU...

Re: Problem Notes for SAS #2
On Mon, 9 Jun 2008 13:41:22 -0400, Mike Rhoads <RHOADSM1@WESTAT.COM> wrote: >Chang, > >I have occasionally thought about subscribing to this particular list, >but have never gotten around to it. > >One reason is potential volume -- about how many messages does this >subscription generate in an average day or week? > >Mike Rhoads >Westat >RhoadsM1@Westat.com hi, Mike, Since March, my reader got about 500 notes. It is a rss feed, so you can easily set your reader to keep only a certain number of most recent ones, too. hope this helps. cheers, chang ...

Re: SAS Table help #2
Monti, Either Ian, I, or both of us have misunderstood what you might be looking for. If your data show the number of missing data elements, by product type, then I think you want something like the following: data have; input Product $ ItemA ItemB ItemC ItemD ItemF; cards; A 1 . 2 9 . B 2 2 0 3 9 C 6 5 9 . 8 D 5 . 5 7 8 E 5 . 2 8 . F . 2 3 6 7 G . 8 2 . 5 H 5 . . 8 1 ; data temp; set have ; nmiss = sum (of item: ) ; run; proc sql; create table want as select product,nmiss,100*nmiss/sum(nmiss) as pct_of_total from temp; quit; HTH, Art --------- On Mon, 2 Feb 2009 13:14:41 -0800, Mahbub Khandoker <mk_sas1@YAHOO.CA> wrote: >Hi there, >I am very new to SAS. I want to create a table from SAS database which includes statistics for all the missing data elements by product type. >The database looks like as follows, >� >Product����������� ItemA�� ItemB ItemC ItemD ItemF >A�������������������� 1��������� ����������� 2��������� 9��������� >B��������������������� 2��������� 2��������� 0��������� 3��������� 9 >C�������������������� 6��������� 5��������� ����������� 9.�������� 8 >D�������������������� 5��������� ����������� 5��������� 7��������� 8 >E��������������������� 5��������� ����������� 2��������� 8��������� >F��������������������� ����������� 2��������� 3�...

Re: Problem with dictionary.tables #4
Antje; Proc sql noPrint ; Select catT( LibName , '.' , MemName ) into :datasets separated by " " from dictionary.Tables where ( LibName eq 'PERM' ) ; Quit ; Data result ; Set &datasets ; Run ; Ed Edward Heaton, SAS Senior Systems Analyst, Westat (An Employee-Owned Research Corporation), 1600 Research Boulevard, RW-4541, Rockville, MD 20850-3195 Voice: (301) 610-4818 Fax: (301) 294-3879 mailto:EdHeaton@Westat.com http://www.Westat.com -----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of antje.schuele@googlemail.com Sent: Monday, June 26, 2006 11:09 AM To: sas-l@uga.edu Subject: Problem with dictionary.tables Dear Newsgroup, I'd like to set a few tables together. That's why I read out my needed tables with the help of dictionary.tables: Here's my code: proc sql noprint; select memname into :dsn separated by " " from dictionary.tables where libname = "PERM"; quit; data result; set perm.&dsn; run; Now my problem: The data set result only takes the first table from the library perm, the other tables are taken from the work library. Is there a possibility to tell SAS that all tables that are set in result are in the library "perm"? Thank for any help. Antje ...

Re: SAS chess problem :-) #2
On Mon, 17 Nov 2008 09:43:10 -0800, Adriano Rodrigues <adriano@GPP.COM.BR> wrote: >Hi all, > > >Small joke, but my data from games I played is something like this: > > >data chess; > >input white $10. elowhite black $10. eloblack resw resb; > >datalines; > >Rodrigues 2305 Rocha 2105 1 0 > >Rodrigues 2305 Lima 2455 0.5 0.5 > >Watanabe 2400 Rodrigues 2305 0.5 0.5 > >Asfora 2270 Rodrigues 2305 0 1 > >Rodrigues 2305 Sunye 2485 0 1 > >; > >run; > > >proc print; > >run; > > >I want sort and print all games in this order: > > >Rodrigues 2305 Lima 2455 0.5 0.5 > >Rodrigues 2305 Rocha 2105 1 0 > >Rodrigues 2305 Sunye 2485 0 1 > >Asfora 2270 Rodrigues 2305 0 1 > >Watanabe 2400 Rodrigues 2305 0.5 0.5 > > >(all me with white first, then all me with black) > > >Is there a way in proc sort to order by white but telling to procedure I am >the first one? > > >What I did until today is to change my name to AAARodrigues and then use >one format to put my name back� > > >Thanks, > >Adriano > >Adriano Rodrigues > >Estat�stico Respons�vel > >Instituto GPP > >(21) 21091857 > > Try SQL, like proc sql; select * from chess order by (black = 'Rodrigues'), black, white; quit; ...

Re: Lookup Table in SAS #2
On Fri, 29 Aug 2008 20:42:06 -0400, Nat Wooding <Nathaniel.Wooding@DOM.COM> wrote: >Jerry > >There are a couple ways to do this in SAS. One is to create a "user defined >format" and use a put statement to create a new variable based on the value >of an existing variable and the format that you created. See the SAS >documentation on Proc Format and the Put function. Note that the values >that are used in building this format may be manually typed or may be read >from a SAS data set. > >A second way is to merge the two tables and, based on whether there are >matches between the two tables, the flag may be set with program >statements. The following illustrates this approach. > >Data a; >input values $1. ; >cards; >a >b >c >d >e >; > > >Data b; >informat data2 $10.; > >input values $1. data1 data2 ; >cards; >b 1 something >x 2 random >k 3 new >proc sort; > by values;* this solution requires that the two data sets be sorted. >The format solution does not require sorting; >run; > >Data final; > merge b (in = in1 ) a (in=in2); > by values; > if in1;* select only datalines that exist in b; > if in2 then flag = 1; > else flag = 0;* see sas data set options discussion; >proc print; >run; > >Nat Wooding >Env...

Re: Problem with dictionary.tables #3
Antje, I see you have been given a couple of approaches to solving your problem. Let me offer a suggestion that will help you understand what is going on. I almost always display the value of the SQL generated macro variable in the log, particularly during development, so I can check my assumptions (and shaky SQL) against what SAS is really doing. Add this line of code between the PROC SQL and DATA steps: %put #### dsn=&dsn; This will show you what is in &dsn. You will see that &dsn does indeed list the data set names but not the librefs. So if you had data sets PERM.A, PERM.B, PERM.C, then &dsn has the value "A B C". HTH, Clint -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of antje.schuele@googlemail.com Sent: Monday, June 26, 2006 11:09 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Problem with dictionary.tables Dear Newsgroup, I'd like to set a few tables together. That's why I read out my needed tables with the help of dictionary.tables: Here's my code: proc sql noprint; select memname into :dsn separated by " " from dictionary.tables where libname = "PERM"; quit; data result; set perm.&dsn; run; Now my problem: The data set result only takes the first table from the library perm, the other tables are taken from the work library. Is there a possibility to tell SAS that all tables that are set in result are in the library "perm&...

Web resources about - Re: Problem with dictionary.tables #2 - comp.soft-sys.sas

Dictionary - Wikipedia, the free encyclopedia
According to Nielsen (2008) a dictionary may be regarded as a lexicographical product that is characterised by three significant features: (1) ...

Dictionary.com Dictionary & Thesaurus goes 7.0 with interface improvements
In September, Dictionary.com Dictionary & Thesaurus was updated to version 6.0 with a significant redesign that introduced a fresh look and feel ...

Price Drop: Textkraft with German Dictionary
Textkraft with German Dictionary 3.1.3 Device: iOS iPad Only Category: Productivity Price: Free, Version: 3.1.3 ( iTunes ) Description: Das ...

'Rabid Feminist' and Other Sexist Sentences Should Be Excluded From the Oxford Dictionary ASAP
It's a source that's meant to inform and educate but the Oxford English Dictionary recently came under fire for being sexist. Michael Oman-Reagan, ...

'Mx.' instead of 'Mr.' or 'Mrs.?' It's in the dictionary now
Among the words officially added to dictionary.com this week is &quot;Mx.,&quot; pronounced &quot;mix&quot; and defined as &quot;a title of respect ...

'Identity' is Dictionary.com's word of the year - CNN.com
Race, sexuality and gender are the live-wire topics that inspired Dictionary.com to pick "identity" as its word of the year for 2015.

Jimmy Fallon, Nathan Lane play 'Kid Dictionary' on 'The Tonight Show' - EW.com
Jimmy Fallon, Nathan Lane play 'Kid Dictionary' on 'The Tonight Show' - EW.

The Original Hacker's Dictionary For Small Business Owners
A cybersecurity book and glossary for newbies and small business owners.

But That Isn't A Word: Oxford Dictionary Chooses The Face With Tears Of Joy Emoji As Word Of The Year ...
Because even dictionary companies want to feel edgy from time to time, Oxford Dictionaries has announced the 'face with tears of joy' emoji is ...

Athleisure Is Officially In the Dictionary, But What Does It Mean?
Come 2016, the eye roll-inducing label given to fashion's fascination with evolved workout layers will be added to the Merriam-Webster dictionary. ...

Resources last updated: 3/18/2016 10:06:10 AM