datastep Questions - RunSubmit.com

Data step code for metadata administration

2010-07-15T14:04:17Z

I am trying to find and/or create some (presumably DATA Step) code to create a metadata folder under an existing metadata folder, inheriting all access rights. I'm sifting through the various Metadata manuals, but any assistance would be appreciated.

Andrew Howell

Using set lists (i.e. SET dataset1-datasetn ;)?

2010-03-17T22:29:26Z

in the documentation it says this about the "SET" statement:

Using Data Set Lists with SET...

You can use data set lists with the SET statement....

For example, set SALES1:; tells SAS to read all data sets starting with "SALES1" such as SALES1, SALES10, SALES11, and SALES12

... [and] ...

For example, these lists refer to the same data sets:

sales1 sales2 sales3 sales4

sales1-sales4...

However, I'm getting an error when I use this:

data MyFile1;
   input name $ dept $;
   datalines;
John Sales
Mary Acctng
;

data MyFile2;
   input name $ dept $;
   datalines;
Jim Reporting
Steven Acctng
;

data combine;
set MyFile: ;
run;

data combine;
set MyFile1-MyFile2;
run;

and the error looks like this:

28         data combine;
29         set MyFile: ;
                     _
                     22
                       _
                       200
ERROR: File WORK.MYFILE.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, 
              _DATA_, _LAST_, _NULL_.  

ERROR 200-322: The symbol is not recognized and will be ignored.

or this:

32         data combine;
33         set MyFile1-MyFile2;
                      _
                      22
                       _______
                       202
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, 
              _DATA_, _LAST_, _NULL_.  

ERROR 202-322: The option or parameter is not recognized and will be ignored.

I'm running v9.01 on UNIX Is this a version or an option thing?

Jim

Theta Symbol in a SAS Label?

2010-01-04T19:58:58Z

How do I make the label for a variable display a Greek character.

So I need:

label Theta = <somehex_expression?>;

I'm trying to label the variable named Theta with the upper case Greek theta symbol. thoughts?

How to create a listing of all intervening dates between a start and end date?

2009-10-22T10:39:18Z

I have the following code where I have a tradid with the first date when the trade was opened and the second date when it was closed (as shown in the code below).

Data new; 
  Infile cards; 
  input tradeid $8. Date anydtdte20.; 
  format date ddmmyy10.; 
datalines; 
10392867        26Mar04 
10392867        30Mar04 
10433324        29Mar04 
10433324        2Apr04 
10448117        30Mar04 
10448117        2Apr04 
RUN;

I need to have output that inserts the dates that occur inbeween the dates I have in the data new file. Results would need to look like this (I inserted spaces between tradeid's for illustrative purposes only - same for the above):

tradeid         Date 
-----------     ---------
10392867        26-Mar-04 
10392867        27-Mar-04 
10392867        28-Mar-04 
10392867        29-Mar-04 
10392867        30-Mar-04 

10433324        29-Mar-04 
10433324        30-Mar-04 
10433324        31-Mar-04 
10433324        1-Apr-04 
10433324        2-Apr-04 

10448117        30-Mar-04 
10448117        31-Mar-04 
10448117        1-Apr-04 
10448117        2-Apr-04 
10448117        3-Apr-04 
10448117        4-Apr-04

Selecting just Numeric or Character variables?

2009-10-20T16:17:54Z

Can anyone please tell me how to select only numeric or character variables?