Prev: Issues with power analysis using PROC MIXED (long)
Next: Reading a high value from a series of variables
From: Eddie on 20 May 2010 14:11
Hi-
I'm trying to create a data dictionary for my dataset and willing to
read all the values for each format from the library into a dataset so
that I can export the same into Excel.

Any help is greatly appreciated.


Eddie/
From: Reeza on 20 May 2010 16:33
On May 20, 11:11 am, Eddie <aditya.penme...(a)gmail.com> wrote:
> Hi-
> I'm trying to create a data dictionary for my dataset and willing to
> read all the values for each format from the library into a dataset so
> that I can export the same into Excel.
>
> Any help is greatly appreciated.
>
> Eddie/

Look into sashelp.vcolumn

See http://www.sys-seminar.com/WISUG_Presentations/Teresa_Schudrowitz_MetaData.pdf

HTH,
Reeza
From: Arthur Tabachneck on 20 May 2010 20:46
Eddie,

If I understand your question correctly, then you probably want to
combine Reeza's advice with using the cntlout option with proc
format. E.g.,

proc format;
value agegroup
11,12,13='young'
other='old'
;
run;

data test;
set sashelp.class;
format age agegroup.;
run;

proc format library = work.formats
cntlout = the_formats;
run;

proc print data=the_formats;
run;

HTH,
Art
-------------
On May 20, 4:33 pm, Reeza <fkhurs...(a)hotmail.com> wrote:
> On May 20, 11:11 am, Eddie <aditya.penme...(a)gmail.com> wrote:
>
> > Hi-
> > I'm trying to create a data dictionary for my dataset and willing to
> > read all the values for each format from the library into a dataset so
> > that I can export the same into Excel.
>
> > Any help is greatly appreciated.
>
> > Eddie/
>
> Look into sashelp.vcolumn
>
> Seehttp://www.sys-seminar.com/WISUG_Presentations/Teresa_Schudrowitz_Met...
>
> HTH,
> Reeza

 | 
Pages: 1
Prev: Issues with power analysis using PROC MIXED (long)
Next: Reading a high value from a series of variables