How to identify and delete empty datasets in an elegant manner

sas

    Sponsored Links

    Next

  • 1. proc sylk
    Hi, I am trying proc sylk and find myself puzzled by the error message. It looks like that it does not allow character variables as function arguments. Or am I doing something stupid?! The code and error messages are in the below. Cheers, Chang <sasl:code ver="9.0"> /* this one works! */ proc sylk out=one; ans = comb(9,5); output; function comb(n,k); return (fact(n)/fact(k)*fact(n-k)); endsub; run; proc print data=one; run; /* output Obs ans 1 126 */ /* this one does not work */ proc sylk out=two; ans = TitleCase("abcde"); output; function TitleCase(str); return (upcase(substr(str,1,1))||substr(str,2)); endsub; run; /* log 60 proc sylk out=two; 61 ans = TitleCase("abcde"); 62 output; 63 function TitleCase(str); 64 return (upcase(substr(str,1,1))||substr(str,2)); -- 22 76 NOTE: Numeric value converted to character for argument 1 of 'SUBSTR' operation at line 64 column 30. ERROR 22-322: Syntax error, expecting one of the following: ), *, **, +, - , /, <>, ><. ERROR 76-322: Syntax error, statement will be ignored. 65 endsub; 66 run; NOTE: The data set WORK.TWO has 0 observations and 0 variables. */ </sasl:code>
  • 2. SAS V. 9 Connectivity to ORACLE Data Warehouse
    O wise SAS wizards near and far: I recently installed v. 9 on my XP desktop, and in an attempt to get a connection to our data warehouse got an error message about SASORA being found but not able to be loaded. SAS/Cary TS staff yesterday told me the fix was to upgrade to sqlnet 8.1.7. Sounds easy enough but now I see my client-side oracle choices are: * Oracle 8i Client Release 3 (8.1.7) for Windows NT/95/98/2000 * Oracle 9i Client Release 1 (9.0.1) for Windows 98/2000/NT/XP * Oracle 9i Client Release 2 (9.2.0.1.0) for Windows 98/NT/2000/XP does anyone know if I need 8.1.7 specifically, despite it having no mention of XP (see above), or if one of the oracle 9i releases will solve my connection problem. If one of the 9i releases...which? Or is this the simple...take the latest release available solution? I also called SAS/Cary TS again this a.m. but got a tracking #, so I thought I'd turn to SAS-L and see if anyone has encountered the problem and solved it. Thanks in advance!!! Proc Xmas / merry; Weight gain; Run; Dennis Catley Associate Director - Institutional Research Virginia Tech 128 Smyth Hall Blacksburg, VA. 24060 (540) 231-2623 XXXX@XXXXX.COM
  • 3. double covariate structu or is it?
    Dear All, I have a design/analysis problem that I would appreciate input on. The problem is as follows: I study swimming performance in fish. Maximum swimming speed (also called critical swimming speed) is a function of body length. It is also a function of drag, which is proportional to length squared. Thus, when investigating various treatment effects, I have two potential covariates (and possibly interactions) that both are functions of length. The traditional way of dealing with these questions is to either a) run the analysis twice, once with each covariate, or b) recalculate size to a standard size and then run the analysis on this value. I think quite a lot would be gained by running the analysis on the whole dataset, but the model formulation is not that obvious. A more formal description of the problem is: speed is proportional to a * L ; a>0 /* "propulsion" */ speed is proportional to b * L^2; b<0 /* "drag" */ The question asked would be e.g., "Given the propulsive power and the drag resulting from each individual's length L, is there any difference in terms of maximum swimming speed, V, between the two treatment groups 1 & 2? What is the relative contribution of drag? What is the relative contribution of propulsive power? Thus, any suggestions about how to approach the problem would be greatly appreciated. Best wishes, Lars Pettersson Lund University, Sweden

How to identify and delete empty datasets in an elegant manner

Postby Shelley.Baxter » Sun, 26 Mar 2006 02:58:01 GMT

Would this be a proc sql approach with the vtable?

Shelley S. Baxter, Ph.D.
Boeing Corp.
            509-637-4500

Re: How to identify and delete empty datasets in an elegant manner

Postby Jiann-Shiun.Huang » Sun, 26 Mar 2006 03:47:32 GMT

Shelley:

  If your datasets are "ORDINARY DATASET" as mentioned in Jack's paper,
then the following code should work for you.  You need to change
LibraryName to your libname without any quotation.

%let MyLib=%upcase(LibraryName);  /*Without any quote*/
proc sql noprint;
  select memname into :NameList separated by ' '
  from sashelp.vtable
  where libname="&MyLib" and nobs eq 0;
quit;

%put &NameList;

%macro droptbl(lib,nooblist);
  %let filecnt=%eval(%sysfunc(count(&nooblist,%str( )))+1);
  %put &filecnt;
  proc sql;
    %do i=1 %to &filecnt;
          %let dataset=%scan(&nooblist,&i);
          drop table &lib..&dataset;
    %end;
  quit;
%mend droptbl;

%droptbl(&MyLib,&NameList)
run;


J S Huang
1-515-557-3987
fax 1-515-557-2422

That's would I would do, if I knew the provenance of the data sets.
I'd probably use dictionary.tables rather than sashelp.vtable - it's
supposedly more efficient.

You do have to know how your data sets were created and modified -
there are some circumstances under which the observation count in
dictionary.tables will not be correct.  See my paper How Many
Observations Are In My Dataset?" at

< http://www.**--****.com/ ;.








---
Jack Hamilton
Sacramento, California

Re: How to identify and delete empty datasets in an elegant manner

Postby joewhitehurst » Sun, 26 Mar 2006 04:45:24 GMT

Or, you might consider the folllowing simple SAS Component Language program.

length memname $32;
init:
  submit continue;
     proc contents data=newtable._all_ dir noprint out=lib_contents;
     run;
  endsubmit;
lib_contents_dsid=open('lib_contents','i');
do until(fetch(lib_contents_dsid)^=0);
   temp_dsid=open('sashelp.'||memname,'v');
   if attrn(temp_dsid,'nobs')=0 then do;
      close_rc=close(temp_dsid);
      delete_rc=delete('newtable.'||memname);
  end;
end;
close_rc=close(lib_contents_dsid);
return;



Re: How to identify and delete empty datasets in an elegant manner

Postby shiling99 » Sun, 26 Mar 2006 04:48:52 GMT

You may modify the SQL below to achieve your needs.
HTH

1    data;
2    stop;
3    run;

NOTE: The data set WORK.DATA1 has 0 observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.00 seconds


4    data;
5    stop;
6    run;

NOTE: The data set WORK.DATA2 has 0 observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds


7    data;
8    stop;
9    run;

NOTE: The data set WORK.DATA3 has 0 observations and 0 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds


10
11   proc sql noprint;
12     select 'drop table '||compress(libname)||'.'||memname into:
dropstmt separated by ';'
13     from sashelp.vtable
14     where nobs=0 and memtype='DATA' and libname in ('WORK');
15     ;
16     &dropstmt
17     ;
NOTE: Table WORK.DATA1 has been dropped.
NOTE: Table WORK.DATA2 has been dropped.
NOTE: Table WORK.DATA3 has been dropped.
18   quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.07 seconds
      cpu time            0.01 seconds


19
20   %put >>>"&dropstmt"<<<;







Re: How to identify and delete empty datasets in an elegant manner

Postby RandyHerbison » Sun, 26 Mar 2006 07:15:46 GMT

entry libname :input :char;

dcl num rc;

init:
dsid=open('sashelp.vtable(where=(libname=upcase("' || libname || '") and
nobs=0))');
any=attrn(dsid,'ANY');
if any then do;
  do until(fetch(dsid)^=0);
    rc=delete('work.'||getvarc(dsid,varnum(dsid,'MEMNAME')));
  end;
end;
dsid=close(dsid);
return;

-----Original Message-----
From:  XXXX@XXXXX.COM  [mailto: XXXX@XXXXX.COM ]
On Behalf Of  XXXX@XXXXX.COM 
Sent: Friday, March 24, 2006 2:45 PM
To: Jiann-Shiun Huang;  XXXX@XXXXX.COM 
Subject: Re: Re: How to identify and delete empty datasets in an elegant
manner


Or, you might consider the folllowing simple SAS Component Language
program.

length memname $32;
init:
  submit continue;
     proc contents data=newtable._all_ dir noprint out=lib_contents;
     run;
  endsubmit;
lib_contents_dsid=open('lib_contents','i');
do until(fetch(lib_contents_dsid)^=0);
   temp_dsid=open('sashelp.'||memname,'v');
   if attrn(temp_dsid,'nobs')=0 then do;
      close_rc=close(temp_dsid);
      delete_rc=delete('newtable.'||memname);
  end;
end;
close_rc=close(lib_contents_dsid);
return;



Re: How to identify and delete empty datasets in an elegant manner

Postby joewhitehurst » Sun, 26 Mar 2006 07:24:35 GMT

andy,

Nice work. I noticed that my solution would not have worked because I left out a call set statement, so values of memname on the contents dataset would never have been moved into the SCL nonwindow variable of the same name causing the delete function to fail.

Joe

Re: How to identify and delete empty datasets in an elegant manner

Postby Shelley.Baxter » Sun, 26 Mar 2006 11:44:15 GMT





Thank you for the help. I can see that the Shiling approach is the most
compact and elegant. I will keep the dictionary vs vtable distinction in
mind. I have thought about learning SCL since I won a book about it as a
door prize and keep finding myself in that documentation area and that's
the only way something can be done. But if I bunny trail off on that now I
will never get the project done!

Re: How to identify and delete empty datasets in an elegant manner

Postby BenDray » Tue, 28 Mar 2006 19:05:41 GMT

Hi Joe/Randy,

I like the look of the SCL program above - however I've never used SCL
and just tried to copy/paste into a SAS session but it's not working.
Can you tell me how to run this SCL code please??

Many thanks!!

Ben


Re: How to identify and delete empty datasets in an elegant manner

Postby joewhitehurst » Wed, 29 Mar 2006 02:29:47 GMT

Ben,

You must place the code in a SAS Catalog as member type SCL and compile it
before you can execute it.

Joe

-----Original Message-----
From: SAS(r) Discussion [mailto: XXXX@XXXXX.COM ] On Behalf Of BenDray
Sent: Monday, March 27, 2006 5:06 AM
To:  XXXX@XXXXX.COM 
Subject: Re: How to identify and delete empty datasets in an elegant manner

Hi Joe/Randy,

I like the look of the SCL program above - however I've never used SCL
and just tried to copy/paste into a SAS session but it's not working.
Can you tell me how to run this SCL code please??

Many thanks!!

Ben

Similar Threads:

1.How to identify and delete empty datasets in an elegant

2.FW: How to identify and delete empty datasets in an elegant

3.FW: How to identify and delete empty datasets in an

4.deleting empty files in a catalog

Hi,
I am planning to make a macro that has a catalog name as parameter and 
delete all empty files in that catalog.

%macro delete_empty_files(catalog);
???
%mend;

Has anyone made something like that before and can share it with me ? I am 
using Windows XP if it matters.

Regards, Rune




5.Deleting empty columns

I have datasets with 50+ variables. However not all of the columns are
being used. What would be the most efficient way to delete all columns
that are completely empty?

Thanks,
Gerrit

6. Why doesn't this macro delete the empty dataset?

7. identifying two different datasets

8. Identifying observations not in other Datasets



Return to sas

 

Who is online

Users browsing this forum: No registered users and 8 guest