Prev: How to surpress log statement: "NOTE: ABSGCONV convergence
Next: Repeat Steps >1 Data Set
From: Sunny on 5 Feb 2010 14:29


Hello Group,

I want to append the live Stock data at the end of my
excel sheet
each time its run, which is scheduled to run after every
10 minute.
I want the updated value to be appended after prev value.

Where does proc append fits in here ?


ods csv file ="C:\users\&dsn1..&ext"; /* &ext=csv */
proc print data=alix.&dsn1 noobs;
var ticker price day Tradetime change open hi lo volume;
run;
ods csv close;
run;



Thanks

Sunny

From: Joe Matise on 5 Feb 2010 16:56
First off - that's not an excel sheet, it's a comma delimited file. Excel
opens those.

I don't see where you read in the file. Do you already have the dataset and
are just putting it out over and over again? If so then PROC APPEND goes
before any of this [immediately before is fine]. You could also avoid
processing the entire file each time by putting it out directly with a data
step write, as those can update files in place [look up the FILE/INFILE
statement and SHAREBUFFERS].

Your final RUN is irrelevant, as well...

-Joe

On Fri, Feb 5, 2010 at 1:29 PM, Sunny <msunny17(a)gmail.com> wrote:

> Hello Group,
>
> I want to append the live Stock data at the end of my
> excel sheet
> each time its run, which is scheduled to run after every
> 10 minute.
> I want the updated value to be appended after prev value.
>
> Where does proc append fits in here ?
>
>
> ods csv file ="C:\users\&dsn1..&ext"; /* &ext=csv */
> proc print data=alix.&dsn1 noobs;
> var ticker price day Tradetime change open hi lo volume;
> run;
> ods csv close;
> run;
>
>
>
> Thanks
>
> Sunny
>
 | 
Pages: 1
Prev: How to surpress log statement: "NOTE: ABSGCONV convergence
Next: Repeat Steps >1 Data Set