Date:         Tue, 11 Jul 2000 18:29:28 GMT
Reply-To:     charles_s_patridge@MY-DEJA.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         charles_s_patridge@MY-DEJA.COM
Organization: Deja.com - Before you buy.
Subject:      Re: Reformatting variables using metadata: need SQL and/or MACRO
              help

Lauren,

Without getting too fancy and having to read dataset 2 here is a simple
answer to your question:


 /*******************************************/
 /***TIP 00148                            ***/
 /***Author: Charles Patridge             ***/
 /***Email: Charles_S_Patridge@prodigy.net***/
 /***                                     ***/
 /***Use the Metadata from 1 Dataset to   ***/
 /***populate the metadata of another     ***/
 /***Dataset                              ***/
 /*******************************************/

 *** Sample Dataset 1 ;
 data set1;
  length var1 $10;
  format var2 8.2;
  infile cards;
  input var1 var2;
cards;
orange   .25
lime     .15
coke     .10
;;;;
run;


*** Sample Dataset 2;
Data set2;
 length var1 $200 ;
 format var2 12.5;
  infile cards;
  input var1 var2;
cards;
 Coffee  0.75
 Tea      1.25
 Latte    2.50
 Milk     1.99
;;;;
run;


*** Using Metadata from Set 1 Populate the ;
*** Metadata for Set 2 in a new Dataset 3  ;

 data set3;
 if _n_ = 1 then set set1 (obs=1);
            else set set2 ;
 if _n_ = 1 then delete;
 run;

/*** end of tip 00148 ***/


HTH
Charles Patridge
Email: Charles_S_Patridge@prodigy.net







In article <8kfk4d$rnq$1@nnrp1.deja.com>,
  haworthl@mindspring.com wrote:
> Okay, I'm feeling lazy. My hope is that someone has done this before.
>
> My problem: I have two datasets
> (1) metatdata including variable names, and their appropriate formats;
> (2) raw data for these variables, all formatted as $200.
>
> I want to use the metadata to create a third dataset with the
variables
> all properly formatted.
>
> Some sample data:
>
> Dataset 1
> VARNAME VARTYPE VARLEN VARDEC
> var1    char    10
> var2    numb    8      2
>
> Dataset 2
> VAR1     VAR2
> Coffee   0.75
> Tea      1.25
> Latte    2.50
>
> What I want is a dataset 3 where VAR1 is formatted as $10. and VAR2 is
> formatted as 8.2
>
> Any suggestions? I suspect this is a candidate for PROC SQL and/or a
> creative macro. Anyone have any code for something like this?
>
> TIA,
>
> Lauren Haworth
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Charles Patridge - PDPC, Ltd.
172 Monce Road - Burlington, CT 06013 USA
Phone: 860-673-9278 or 860-675-9026
Email: Charles_S_Patridge@prodigy.net - Web: www.sasconsig.com


Sent via Deja.com http://www.deja.com/
Before you buy.