About SachinRuk

SachinRuk · ‎06-23-2011

and the drop=age_: while Im at it. Not sure what it does specifically. Thanks again

SachinRuk · ‎06-23-2011

Appreciate the response. and sorry that was meant to be nway. What does sum=/autoname do? Thanks, Sachin

SachinRuk · ‎06-22-2011

Hi All, In my data step my period variable is numeric in format yymmdd8. My question is I want to do a proc summary such that: proc summary data=mydata nvar; class period; var _numeric_ (except for period); output out=mysummary sum=; run; Any thoughts? Thanks, Sachin

SachinRuk · ‎04-08-2011

Hi, I have the following piece of code. ods pdf text="~S={just=left cellwidth=1.6in background=CX4D7EBF foreground=black} ~mName: ~S={background=white foreground=black} Sachin"; I want to have a blue box around the "Name" part and no background on the "Sachin" part. I also need this to be in one line. How would you go about doing this. Thanks in advance, Sachin

SachinRuk · ‎02-15-2011

Hi Cynthia, Suppose I want to add the last three variables (forget what I said about trying to add variable number of rows), is there another way to do it without using a lag operator? Thanks, Sachin

SachinRuk · ‎02-14-2011

is it possible to do it without the lag function? Only because as an example I said 3 but its most likely to be 12 and may vary. For example can we do this using _n_ and a do loop? /*for each _n_ (row)*/ /*loop 12 times with previous 12 rows and add up*/ Thanks Sachin

SachinRuk · ‎02-14-2011

Hi all, I want to add the last 3 rows for every row for a particular table. Suppose my table looked like this: col1 1 2 3 4 5 6 I want the resulting table to be (disregarding first two rows): col1 6 9 12 15 Thanks Sachin

SachinRuk · ‎02-10-2011

Thanks Rob, That helped heaps. Any suggestions as to how to use a heat map on this (or atleast a traffic light one) such that I get a red dot for the $7000, amber for $5000 and so on. Cheers, Sachin

SachinRuk · ‎02-09-2011

Hi All, Im trying to map some data on to the australian map (called austral i believe). Say the data is as follows: lat long expenditure -31.5 149.8 $5000 -30.5 148.2 $3000 -29.6 147.3 $7000 How do I plot the above data onto the australian map? Is using Gproject an absolute must? Thanks, Sachin

SachinRuk · ‎01-04-2011

Hi All, I want to align my title with the proc report that I have. I have so far left justified it which moves the title all the way to the left. One tip that I got from one of the SAS papers was to (pain stakingly) do: "%str( ) my title" I also want to have the background blue ( a small blue rectangular strip around the title) and the text white for the title. Any tips/ thoughts? Thanks, Sachin

SachinRuk · ‎11-23-2010

Hi Cynthia, I did not mean the minor tick marks and have already turned them off, but thank you none the less :). and yes I am using gplot. I suppose I should have reworded my question regarding the order statement. I dont mind it as long as its in the form: axis2 order=(min_data to max_data by (max_data-min_data)/5) but would be great if i could suppress say, every second label/ (and its tick mark) from the axis instead. Thanks, Sachin

SachinRuk · ‎11-22-2010

Hi All, On a pdf that I create the number of ticks are quite annoying and makes the axis look cramped up. Is there a way to set the number of ticks? So I have nice spaced out ticks without actually messing with the size of the actual graph? I also DONT want to use something like axis2 order=(70 to 80 by 2) because I dont know the minimum or maximum value of the data prior to the program running. Thanks, Sachin Message was edited by: SachinRuk Message was edited by: SachinRuk

SachinRuk · ‎11-18-2010

thing is im doing this from a csv file. And those date-times exist in ONE column. So any suggestions as to how to pull it in from a csv itself. OR if not pull the column in as text and do what you did there? Sorry, Im just quite new to SAS Sachin

SachinRuk · ‎11-18-2010

Hi All, This is what I want my table to end up looking like after a proc transpose. Measure Mar 10 Aug 10 Month 10 11 Annual 12 13 but thanks to the way the proc transpose had been used it ends up like: Measure Aug 10 Mar 10 Annual 13 12 Month 11 10 It sorts the variable names as well as the measures in alphabetic order :(. Any thoughts? Thanks, Sachin

SachinRuk · ‎11-18-2010

Hi All, I want to read into a dataset date times which look like the following: Note especially that 9:45...AM has one integer before the ":" and 10:02...PM has two. 26/01/2009 9:45:51 AM 26/01/2009 10:02:08 PM Any suggestions? Thanks, Sachin

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: choose all variables _numeric_ except for variable period

Re: choose all variables _numeric_ except for variable period

choose all variables _numeric_ except for variable period

Different formats in one line: ods pdf text

Re: Adding the last 3 rows in a table

Re: Adding the last 3 rows in a table

Adding the last 3 rows in a table

Re: proc gmap

proc gmap

formatting titles

Re: choose all variables _numeric_ except for variable period

Re: choose all variables _numeric_ except for variable period

choose all variables _numeric_ except for variable period

Different formats in one line: ods pdf text

Re: Adding the last 3 rows in a table

Re: Adding the last 3 rows in a table

Adding the last 3 rows in a table

Re: proc gmap

proc gmap

formatting titles

Re: controlling number of ticks on axes

controlling number of ticks on axes

Re: date-time informats

proc transpose stopping auto sorting of var names

date-time informats