Re: SAS-L Digest - 5 Oct 2007 - Special issue (#2007-1685)

How do I unsubscribe from this? Thank you.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Automatic digest processor
Sent: Friday, October 05, 2007 1:53 PM
To: Recipients of SAS-L digests
Subject: SAS-L Digest - 5 Oct 2007 - Special issue (#2007-1685)

There are 13 messages totalling 1040 lines in this issue.

Topics in this special issue:

1. Comma separated (3)
2. Real time feedback from a sas session (2)
3. Enterprise Guide
4. Columns Interchange (4)
5. <No subject given>
6. SCSUG SQL paper: Thinking in Sets, Celko
7. SAS/Graph positioning the graph

----------------------------------------------------------------------

Date: Fri, 5 Oct 2007 15:32:31 +0000
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: Comma separated

I found a slip up in th untested code after i tested it. It should be:

Data Need ( Drop = Temp ) ;
Length Var1 $ 200 ;
Infile Cards DLM = ',' ;

Input @ ;

Temp = CatX( ',' , Scan( _Infile_ , 1 , ',' ) , Scan( _Infile_ , 3 , ',' ) ) ; _InFile_ = Temp ;

Input Var1 Var3 ;

Run ;



Now it works as it should....



Toby Dunn

Compromise is like telling a lie, it gets easier and easier. Each compromise you make, that becomes your standard.

Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.

> Date: Fri, 5 Oct 2007 15:21:16 +0000
> From: tobydunn@HOTMAIL.COM
> Subject: Re: Comma separated
> To: SAS-L@LISTSERV.UGA.EDU
>
> Data Need ( Keep = Var1 Var3 ) ;
> Length Var1 $ 200 ;
> Infile MyFile DLM = ',' ;
> Input Var1 Var2 Var3 Var4 Var5 Var6 ;
> Run ;
>
>
>
> Or < Untested>
>
> Data Need ( Drop = Temp ) ;
> Length Var1 $ 200 ;
> Infile MyFile DLM = ',' ;
>
> Input @ ;
>
> Temp = CatS( Scan( _Infile_ , 1 , ',' ) , Scan( _Infile_ , 3 , ',' ) )
> ; _InFile_ = Temp ;
>
> Input Var1 Var3 ;
>
> Run ;
>
>
>
>
>
>
> Toby Dunn
>
> Compromise is like telling a lie, it gets easier and easier. Each compromise you make, that becomes your standard.
>
> Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.
>
>> Date: Fri, 5 Oct 2007 08:08:10 -0700
>> From: valkrem@YAHOO.COM
>> Subject: Comma separated
>> To: SAS-L@LISTSERV.UGA.EDU
>>
>> Dear SAS users,
>>
>> I want read a data file that is separated by commas
>>
>> Example- the following data file have 6 varaibles,
>>
>> TYG123, 435, 22334, 46, 123234, 670005
>>
>>
>>
>> The variables may not have the same length. The first variable is always Character and the other variables are numeric.
>>
>> How can I read them?
>>
>> I may want to read only some variables. eg. variable 1, and variable 3.
>>
>> Any help is highly appreciated.
>>
>>
>> Val.
>>
>>
>> ---------------------------------
>> Need a vacation? Get great deals to amazing places on Yahoo! Travel.
>
> __________________________________________________ _______________
> Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it now.
> http://office.microsoft.com/en-us/ou....aspx?pid=CL10
> 0626971033

__________________________________________________ _______________
Peek-a-boo FREE Tricks & Treats for You!
http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us

------------------------------

Date: Fri, 5 Oct 2007 11:38:41 -0400
From: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Subject: Re: Real time feedback from a sas session

Tree Frog wrote:
> Hi all (and I expect Alan Churchill in particular...)
>
> I am exploring ways to submit code to SAS from a .NET app, and I'd
> like to get some good (and actionable) feedback in real time.
>
> Where can I find out about how to access the "streaming" task
> information that appears, for example, in the EG Task Status window?
> Can I get a hold of that stream and point it to a text box in my .NET
> app? Can I get better real-time information than that about a running
> SAS session? Could I have the log output in real time like that?
>
> Is there some juicy SAS documentation about submitting code to sas
> from an external app in general, and feedback from the session in
> particular?
>
> Thanks muchly


For a foundation only installation, you can can specify -altlog "monitored.log" on the session command line. A separate process can monitor the "monitored.log" which is current with respect to completed SAS steps.

The EG streaming log type feedback is done through SAS/IT (integration
technologies) and the integrated object model (IOM).
Take a walk over to http://support.sas.com/rnd/itech/papers/index.html.
The techniques discussed in "Developing an Open Client in Visual Basic" can be easily coded in .net

If you are submitting arbitrary sas code and you want per step log feedback, you might have to write a parser to identify and submit each step boundary in the SAS source code -or- I'm not sure, but IOM might have an eventing system to alert you when (in a multistep submittal) a step has completed.

--
Richard A. DeVenezia

------------------------------

Date: Fri, 5 Oct 2007 10:45:47 -0500
From: "data _null_," <datanull@GMAIL.COM>
Subject: Re: Comma separated

You don't want to read the "skip" fields using numeric input. No need to have SAS do all that work to make it floating point when you don't even want it.

You can also reuse the same variable "dummy" or "_" or whatever you want to call it.

data work.vars;
length var1 $200 dummy $1;
infile cards dlm=',' ;
input var1 dummy var3 dummy var4;
drop dummy;
cards;
TYG123, 435, 22334, 46, 123234, 670005
run;
proc print;
run;

On 10/5/07, toby dunn <tobydunn@hotmail.com> wrote:
> Data Need ( Keep = Var1 Var3 ) ;
> Length Var1 $ 200 ;
> Infile MyFile DLM = ',' ;
> Input Var1 Var2 Var3 Var4 Var5 Var6 ;
> Run ;
>
>
>
> Or < Untested>
>
> Data Need ( Drop = Temp ) ;
> Length Var1 $ 200 ;
> Infile MyFile DLM = ',' ;
>
> Input @ ;
>
> Temp = CatS( Scan( _Infile_ , 1 , ',' ) , Scan( _Infile_ , 3 , ',' )
> ) ; _InFile_ = Temp ;
>
> Input Var1 Var3 ;
>
> Run ;
>
>
>
>
>
>
> Toby Dunn
>
> Compromise is like telling a lie, it gets easier and easier. Each compromise you make, that becomes your standard.
>
> Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.
>
> > Date: Fri, 5 Oct 2007 08:08:10 -0700
> > From: valkrem@YAHOO.COM
> > Subject: Comma separated
> > To: SAS-L@LISTSERV.UGA.EDU
> >
> > Dear SAS users,
> >
> > I want read a data file that is separated by commas
> >
> > Example- the following data file have 6 varaibles,
> >
> > TYG123, 435, 22334, 46, 123234, 670005
> >
> >
> >
> > The variables may not have the same length. The first variable is always Character and the other variables are numeric.
> >
> > How can I read them?
> >
> > I may want to read only some variables. eg. variable 1, and variable 3.
> >
> > Any help is highly appreciated.
> >
> >
> > Val.
> >
> >
> > ---------------------------------
> > Need a vacation? Get great deals to amazing places on Yahoo! Travel.
>
> __________________________________________________ _______________
> Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it now.
> http://office.microsoft.com/en-us/ou....aspx?pid=CL10
> 0626971033
>

------------------------------

Date: Fri, 5 Oct 2007 11:46:53 -0400
From: Stephen McDaniel <stephen@STEPHENMCDANIEL.US>
Subject: Re: Enterprise Guide

Hi,

According to these two articles, anywhere from $50-150k for a typical BI server. No per user pricing is needed since Web Report Studio, the Add-
In, etc. are unlimited seats for the server, just pricing per server. My
guess is that these prices would be for corporate users, not academic or government, which is usually much lower…

http://www.intelligententerprise.com...leID=165700935
http://www.softwaremag.com/L.cfm?Doc...2006-01-11/sas

Federal government pricing is available at: http://www.execinfosys.com/SAS% 20GSA%20PriceList.pdf , BI Server starts on page 90 and page 98.

Best regards,
Stephen

On Fri, 5 Oct 2007 09:10:23 -0400, Thomas B <thomas@BOOSECAT.COM> wrote:

>Well ain't that a *hem* Thanks for all of the info. Our SAS rep
>is extraordinaryly slow with getting back to us. I've called and
>e-mailed several times but still haven't gotten all of our answers.
>
>No guestimates on the price of SAS/BI? A colleague and I are working
>on a costing model for getting our SAS system up and am trying to get
>some rough estimates.
>
>Thanks again and thanks for the link.
>
>
>
>On Fri, 5 Oct 2007 02:26:26 -0400, Stephen McDaniel
><stephen@STEPHENMCDANIEL.US> wrote:
>
>>EG is included with PC SAS (or local Windows SAS) but is not included
with
>>SAS servers nor with BI Server (unless you bought BI Server a while
>>back, when the contract included BI Server.)
>>
>>That said, EG comes with Enterprise Miner and many other SAS solutions.
>>To use EG with a remote SAS Server (i.e.- not on your local PC), you
>>need an EG license (either purchased individually or included with
>>another SAS product like Enterprise Miner) -AND- you need SAS
>>Integration
Technologies
>>on the remote SAS server (either purchased separately or included with
SAS
>>BI, SAS EM Server, etc.)
>>
>>If you have further questions, consult your SAS contract, a lawyer,
>>and your SAS Account Exec! Likely, just a call to the Account Exec
>>is all that's really needed...
>>
>>See my blog for some ideas on why you might want EG:
>>http://stephenmcdaniel.us/2007/09/26...erprise-guide/
>>
>>Best regards,
>>Stephen
>>Pragmatic Data Analysis, LLC
>>Stephen@StephenMcDaniel.us
>>http://www.stephenmcdaniel.us
>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>
>>I've read many sources that have said EG is now included with SAS. We
>>have SAS 9.1.3 installed on our server but only have SAS as a program
>>option. Is EG a separate install that we must do or did we somehow
>>not get EG?
>>
>>Also, is EG in any way connected to SAS/BI? Anyone have a general
>>idea (and I mean general) of what SAS/BI will cost us? Just 10 users
>>on a Win 2000 adv server.
>>
>>TYIA

------------------------------

Date: Fri, 5 Oct 2007 16:02:40 +0000
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: Comma separated

Data _Null_ ,


Good point, I was shooting for clarity and understandability rather than resource efficiency on the first example.... the second example which once I tested had to update with a follow up post was my resource efficienct solution.


Toby Dunn

Compromise is like telling a lie, it gets easier and easier. Each compromise you make, that becomes your standard.

Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.

> Date: Fri, 5 Oct 2007 10:45:47 -0500
> From: datanull@GMAIL.COM
> Subject: Re: Comma separated
> To: SAS-L@LISTSERV.UGA.EDU
>
> You don't want to read the "skip" fields using numeric input. No need
> to have SAS do all that work to make it floating point when you don't
> even want it.
>
> You can also reuse the same variable "dummy" or "_" or whatever you
> want to call it.
>
> data work.vars;
> length var1 $200 dummy $1;
> infile cards dlm=',' ;
> input var1 dummy var3 dummy var4;
> drop dummy;
> cards;
> TYG123, 435, 22334, 46, 123234, 670005 run; proc print; run;
>
> On 10/5/07, toby dunn wrote:
>> Data Need ( Keep = Var1 Var3 ) ;
>> Length Var1 $ 200 ;
>> Infile MyFile DLM = ',' ;
>> Input Var1 Var2 Var3 Var4 Var5 Var6 ; Run ;
>>
>>
>>
>> Or < Untested>
>>
>> Data Need ( Drop = Temp ) ;
>> Length Var1 $ 200 ;
>> Infile MyFile DLM = ',' ;
>>
>> Input @ ;
>>
>> Temp = CatS( Scan( _Infile_ , 1 , ',' ) , Scan( _Infile_ , 3 , ',' ) ) ;
>> _InFile_ = Temp ;
>>
>> Input Var1 Var3 ;
>>
>> Run ;
>>
>>
>>
>>
>>
>>
>> Toby Dunn
>>
>> Compromise is like telling a lie, it gets easier and easier. Each compromise you make, that becomes your standard.
>>
>> Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.
>>
>>> Date: Fri, 5 Oct 2007 08:08:10 -0700
>>> From: valkrem@YAHOO.COM
>>> Subject: Comma separated
>>> To: SAS-L@LISTSERV.UGA.EDU
>>>
>>> Dear SAS users,
>>>
>>> I want read a data file that is separated by commas
>>>
>>> Example- the following data file have 6 varaibles,
>>>
>>> TYG123, 435, 22334, 46, 123234, 670005
>>>
>>>
>>>
>>> The variables may not have the same length. The first variable is always Character and the other variables are numeric.
>>>
>>> How can I read them?
>>>
>>> I may want to read only some variables. eg. variable 1, and variable 3.
>>>
>>> Any help is highly appreciated.
>>>
>>>
>>> Val.
>>>
>>>
>>> ---------------------------------
>>> Need a vacation? Get great deals to amazing places on Yahoo! Travel.
>>
>> __________________________________________________ _______________
>> Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it now.
>> http://office.microsoft.com/en-us/ou...CL100626971033
>>

__________________________________________________ _______________
Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare!
http://onecare.live.com/standard/en-...wl_hotmailnews

------------------------------

Date: Fri, 5 Oct 2007 16:11:50 -0000
From: "shaunak.adgaonkar@gmail.com" <shaunak.adgaonkar@GMAIL.COM>
Subject: Columns Interchange

I have a dataset as this

data test;
input type $ amount;
datalines;
D 3000
H 1000
T 5000
;

Here H means header, D means data and T means Tail... in between there
are a lot of observations for data starting with D.... but header and
tail is unique. SO what i exactly want to do is header entities should
be first observation then data and then tail....

output data set should be

H 1000
D 3000
T 5000

i have tried using proc transpose ....as well as sorting data on type
but coulndt quite get that... last option is hard coding .... but just
thought if some body knows method to do it .....

Plz plz reply ... thanx a lot

Shaunak

------------------------------

Date: Fri, 5 Oct 2007 12:14:04 -0400
From: "Audimar P. Bangi" <audi@SAS2THEMAX.COM>
Subject: Re: Real time feedback from a sas session

> If you are submitting arbitrary sas code and you want per step log
> feedback,
> you might have to write a parser to identify and submit each step boundary
> in the SAS source code -or- I'm not sure, but IOM might have an eventing
> system to alert you when (in a multistep submittal) a step has completed.

Yes, there is an "eventing system", but very limited. The
SAS.LanguageService interface exposes the following events:

DatastepStart
DatastepComplete
ProcStart
ProcComplete
SubmitComplete
StepError

You can find more information here:

http://support.sas.com/rnd/itech/doc...oc/ilngca.html

Audi

----- Original Message -----
From: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
To: <SAS-L@LISTSERV.UGA.EDU>
Sent: Friday, October 05, 2007 11:38 AM
Subject: Re: Real time feedback from a sas session

------------------------------

Date: Fri, 5 Oct 2007 12:16:03 -0400
From: Florio Arguillas <foa2@CORNELL.EDU>
Subject: <No subject given>

Val,

Usually when I have .CSV file, i usually try the Import Wizard.

1. Click File>Import Data
2. for Data source, select Comma Separated Values (.csv).
3. Click Next, and the rest, just follow the wizard.

Note: towards the end of the Wizard you will be given the option to
save the PROC IMPORT statement used to read your file. I suggest you save it.

When you click Finish, in the log window, you would also see the
Generated SAS DATA step code .

4. Once you've successfully imported your file, submit a data step
that keeps only the variables you want.

HTH,

Florio





At 11:24 AM 10/5/2007, Val Krem wrote:
>Nat Wooding,
>Thanks for your help,
>
>Suppose if I do not know the number of variables in a record.
>is there a quick way of the total number of variables?
>
>Val
>
>
>
>Nat Wooding <Nathaniel.Wooding@DOM.COM> wrote: Val
>
>The following code reads your data:
>
>Data val;
>infile cards dlm =',';
>informat var1 $10. ;
>input var1 var2 var3 var4 var5 var6;
>cards;
>TYG123, 435, 22334, 46, 123234, 670005
>proc print;
>run;
>
>
>If you do not want to keep all of your variables, say you don't want var3
>and var4, you can add
>
>Drop var3 var4 ;
>
>and place this anywhere after the Data Val; and before the Cards;
>statement.
>
>
>
>Nat Wooding
>Environmental Specialist III
>Dominion, Environmental Biology
>4111 Castlewood Rd
>Richmond, VA 23234
>Phone:804-271-5313, Fax: 804-271-2977
>
>
>
> Val Krem
>
> M> To
> Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
> Discussion" cc
>
> GA.EDU> Subject
>
>
> 10/05/2007 11:06
> AM
>
>
> Please respond to
> Val Krem
>
> M>
>
>
>
>
>
>
> Dear SAS users,
>
>I want read a data file that is separated by commas
>
> Example- the following data file have 6 varaibles,
>
> TYG123, 435, 22334, 46, 123234, 670005
>
>
>
> The variables may not have the same length. The first variable is always
>Character and the other variables are numeric.
>
>How can I read them?
>
>I may want to read only some variables. eg. variable 1, and variable 3.
>
>Any help is highly appreciated.
>
>
>Val.
>
>
>
>
>---------------------------------
>Need a vacation? Get great deals to amazing places on Yahoo! Travel.
>
>
>
>-----------------------------------------
>CONFIDENTIALITY NOTICE: This electronic message contains
>information which may be legally confidential and/or privileged and
>does not in any case represent a firm ENERGY COMMODITY bid or offer
>relating thereto which binds the sender without an additional
>express written confirmation to that effect. The information is
>intended solely for the individual or entity named above and access
>by anyone else is unauthorized. If you are not the intended
>recipient, any disclosure, copying, distribution, or use of the
>contents of this information is prohibited and may be unlawful. If
>you have received this electronic transmission in error, please
>reply immediately to the sender that you have received the message
>in error, and delete it. Thank you.
>
>
>
>---------------------------------
>Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.

------------------------------

Date: Fri, 5 Oct 2007 12:18:45 -0400
From: Nat Wooding <Nathaniel.Wooding@DOM.COM>
Subject: Re: Columns Interchange

How about this approach


data test;
input type $ amount;
if type ='D' then sortord = 2;
else if type = 'H' then sortord = 1;
else if type = 'T' then sortord = 3;
else sortord = 99;
datalines;
D 3000
H 1000
T 5000
;
Proc sort out=test (drop = sortord);
by sortord;
Proc print;
run;




Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977



"shaunak.adgaonka
r@gmail.com"
<shaunak.adgaonka To
r@GMAIL.COM> SAS-L@LISTSERV.UGA.EDU
Sent by: "SAS(r) cc
Discussion"
<SAS-L@LISTSERV.U Subject
GA.EDU> Columns Interchange


10/05/2007 12:11
PM


Please respond to
"shaunak.adgaonka
r@gmail.com"
<shaunak.adgaonka
r@GMAIL.COM>






I have a dataset as this

data test;
input type $ amount;
datalines;
D 3000
H 1000
T 5000
;

Here H means header, D means data and T means Tail... in between there
are a lot of observations for data starting with D.... but header and
tail is unique. SO what i exactly want to do is header entities should
be first observation then data and then tail....

output data set should be

H 1000
D 3000
T 5000

i have tried using proc transpose ....as well as sorting data on type
but coulndt quite get that... last option is hard coding .... but just
thought if some body knows method to do it .....

Plz plz reply ... thanx a lot

Shaunak



-----------------------------------------
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.

------------------------------

Date: Fri, 5 Oct 2007 12:21:58 -0400
From: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject: Re: SCSUG SQL paper: Thinking in Sets, Celko

On Fri, 5 Oct 2007 10:09:25 -0400, Fehd, Ronald J. (CDC/CCHIS/NCPHI)
<rjf2@CDC.GOV> wrote:

>Why I go to Regional User Groups:
>
>Austin is home to Mr SQL:
>
>Data Management & SQL
>Thinking in Sets
>Joe Celko
>
>http://www.scsug.org/SCSUGProceeding...Data-Celko.pdf 60
>slides

60 slides, but no paper as such. It looks like his participation was under
some special arrangement.

>
>see also:
>http://www.celko.com/
>
><sigh> I was teaching my SGF-2007 Hands On Workshop
>or I would've been there!
>
>Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
>
>I made my contribution, too:
>
>"Keep Austin Wierd!"

------------------------------

Date: Fri, 5 Oct 2007 09:26:06 -0700
From: "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject: Re: Columns Interchange

Hi,

Here is one approach:


proc format;
invalue myorder
'H' = 1
'D' = 2
'T' = 3
;
run;

data test;
input type $ amount;
sortorder=input(type,myorder.);
datalines;
D 3000
H 1000
T 5000
;
run;

proc sort data=test out=test(drop=sortorder);
by sortorder;
run;




Hope this is helpful.


Mark Terjeson
Senior Programmer Analyst, IM&R
Russell Investments


Russell Investments
Global Leaders in Multi-Manager Investing






-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
shaunak.adgaonkar@gmail.com
Sent: Friday, October 05, 2007 9:12 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Columns Interchange

I have a dataset as this

data test;
input type $ amount;
datalines;
D 3000
H 1000
T 5000
;

Here H means header, D means data and T means Tail... in between there
are a lot of observations for data starting with D.... but header and
tail is unique. SO what i exactly want to do is header entities should
be first observation then data and then tail....

output data set should be

H 1000
D 3000
T 5000

i have tried using proc transpose ....as well as sorting data on type
but coulndt quite get that... last option is hard coding .... but just
thought if some body knows method to do it .....

Plz plz reply ... thanx a lot

Shaunak

------------------------------

Date: Fri, 5 Oct 2007 09:48:34 -0700
From: "ajs2004@bigfoot.com" <ajs2004@BIGFOOT.COM>
Subject: Re: Columns Interchange

Use formats to define a numeric variable (TYPEN in example below) that
has the sort order you want and displays the way you want:
____________________________

data test;
input type $ amount;
datalines;
D 3000
H 1000
T 5000
;

proc format;
value type 1='H' 2='D' 3='T';
invalue intype 'H'=1 'D'=2 'T'=3;
run;

data test;
set test;
typen = input(type, intype.);
format typen type.;
run;

proc sort data=test;
by typen;
run;

proc print;
run;
____________________________

Obs type amount typen

1 H 1000 H
2 D 3000 D
3 T 5000 T
____________________________

SAS Language Elements
Formats and Informats
http://support.sas.com/onlinedoc/913...a002612372.htm

The FORMAT Procedure
http://support.sas.com/onlinedoc/913...a000063536.htm

On Oct 5, 5:11 pm, "shaunak.adgaon...@gmail.com"
<shaunak.adgaon...@gmail.com> wrote:
> I have a dataset as this
>
> data test;
> input type $ amount;
> datalines;
> D 3000
> H 1000
> T 5000
> ;
>
> Here H means header, D means data and T means Tail... in between there
> are a lot of observations for data starting with D.... but header and
> tail is unique. SO what i exactly want to do is header entities should
> be first observation then data and then tail....
>
> output data set should be
>
> H 1000
> D 3000
> T 5000
>
> i have tried using proc transpose ....as well as sorting data on type
> but coulndt quite get that... last option is hard coding .... but just
> thought if some body knows method to do it .....
>
> Plz plz reply ... thanx a lot
>
> Shaunak

------------------------------

Date: Fri, 5 Oct 2007 10:52:40 -0700
From: "ajs2004@bigfoot.com" <ajs2004@BIGFOOT.COM>
Subject: Re: SAS/Graph positioning the graph

Maybe just put a blank foootnote before the real footnote to add some
space between the graph and the footnote:

footnote1 ' ';
footnote2 'This is the footnote';


On Oct 5, 3:31 am, rose.gra...@ABBOTT.COM (Rose Grandy) wrote:
> I am creating a relatively straightforward graph and sending it to an RTF
> file. The graph is exactly the way I want it except I would like to move
> it up closer to the titles so I have more "white space" between the bottom
> of the graph and the footnotes (right now it is centered). I tried using
> horigin/vorigin in my goptions but it had no effect. Could someone offer a
> suggestion.
>
> These are the goptions I am using (having removed the horigin and vorigin
> values that did not seem to have an effect)
>
> goptions
> reset=all
> gsfmode=replace
> gsfname=outpng
> device=png
> target=png
> xmax=6in
> ymax=9in
> xpixels=1500 ypixels=2250
> ftext="Times New Roman"
> ;
>
> the axis are both set to a length of 5 inches.
>
> Thanks
>
> Rose

------------------------------

End of SAS-L Digest - 5 Oct 2007 - Special issue (#2007-1685)
************************************************** ***********