About George_S

George_S · ‎05-07-2012

If the fileref is on a remote Unix server,How to do this? Thanks

George_S · ‎04-25-2012

Could this be done in data step or other special procedure?

George_S · ‎04-25-2012

Hello everyone, Here is the part of a dataset, I want to check whether there was any same value in the two column. please help. Thanks! data findsame; input value1 value2; cards; 1998 1540 2727 222222 111111 206415 207206 207322 207216 207884 207319 208778 208490 209184 208628 111111 222222 209696 208924 209719 ; run;

George_S · ‎04-20-2012

Hello everyone! I can't find the discuss made before ,Could anybody tell me where I can find them? Thanks! George

George_S · ‎04-17-2012

Thank you Shivas and Cynthia! the result of y and z is exact what I want,but x is just for display the original values but not for summation. proc report data =have out =want6 nowindows ; column x y z k new1; define k / group ; define x/ display ; /*This will cause problem,I want display all the X a, also I want the sum of y and z by k*/ define y / analysis sum ; define z / analysis sum ; define new1 / computed ; define new2 / computed ; compute new1; new1 = y.sum *k; endcomp; rbreak before/summarize; run;

George_S · ‎04-17-2012

how to create this report classified by k? Thanks data have; input x y z k $; cards; 1 2 3 a 1 1 3 a 5 2 3 a 0 3 5 a 3 1 3 b 1 3 3 b 1 3 5 b 0 1 3 b 6 5 3 b 1 0 3 b 4 2 5 a 1 4 3 a 0 1 3 a ; run; ods listing close; ods tagsets.excelxp file='H:\My Documents\total29.xls' style=sasweb options(default_column_width="5,10,10" ) ; proc report data=have nowd; column x y z k; define x/display; define y/analysis sum; define z/analysis mean; define k/group ;/*not work*/ rbreak before/summarize; run; ods tagsets.excelxp close; ods listing;

George_S · ‎04-17-2012

Thank you Ksharp! One more question is how to change the style to make the cells looks like the regular excel cells? That is remove the cells filling and border(set no border,no fill in excel). Thanks!

George_S · ‎04-16-2012

I prefer this could be done by using proc report, Thanks a lot! data have; input x y; cards; 1 2 1 1 5 2 0 3 3 1 1 3 1 3 0 1 6 5 1 0 4 2 1 4 0 1 ; data want(in SAS or excel format ) 1 2 1 1 5 2 0 3 3 1 1 3 1 3 0 1 6 5 1 0 4 2 1 4 0 1 28

George_S · ‎04-16-2012

data have; input x y; cards; 1 2 1 1 5 2 0 3 3 1 1 3 1 3 0 1 6 5 1 0 4 2 1 4 0 1 ; wanted:(excel file,,use proc report ,with summation of y, sum=28) x y 1 2 1 1 5 2 0 3 3 1 1 3 1 3 0 1 6 5 1 0 4 2 1 4 0 1 28 Thanks

George_S · ‎04-13-2012

Why a works but b not? Thanks! data a; input dt mmddyy10.; format dt date9.; cards; 05/07/1953 ; run; data b; input dt mmddyy10.; cards; 05/07/1953 ; format dt date9.; run;

George_S · ‎04-13-2012

Thank you Ksharp, I have a problem when I runing your code, I must remove "_temporary_",which will cause error "ERROR: The ARRAYNAME specification requires a variable based array." I don't understand it. also I add "retain retain _v1-_v3;",while this is not a big problem. Thank you! George

George_S · ‎04-11-2012

what diference? proc sql; create table two as select distinct A.month, A.value, sum(b.value) as rollingValue from one as A inner join one as B on B.month between A.month and A.month-2 group by A.month/*, A.value*/ order by A.month desc; select * from two; quit;

George_S · ‎04-11-2012

how to get need from have(move variable y upward two cells) in one data step. Thanks! data have; input x y; cards; 1 2 3 a 4 b 5 c ; run; need: x y 1 a 2 b 3 c 4 5

George_S · ‎04-11-2012

FYI: data two_pre; set one ; temp1=lag1(value); temp2=lag2(value); rolling_three_month_value_pre=value+temp1+temp2; run;

George_S · ‎04-11-2012

Hello everyone, dataset two is needed. How to get the new colomn rolling_three_month_value in a simple way? Thanks! two: month value rolling_three_month_value 12 100 100+200+150 11 200 200+150+180 10 150 150+180+290 9 180 180+290+410 8 290 290+410+360 7 410 .....so and so forth.... 6 360 5 700 4 850 3 220 2 255 1 600 data one; input month value ; cards; 12 100 11 200 10 150 9 180 8 290 7 410 6 360 5 700 4 850 3 220 2 255 1 600 ;

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

Re: Where is the physical location of work folder

Re: Find same value in two columns

Find same value in two columns

where to find the topic I made before?

Re: how to create this report classified by k

how to create this report classified by k

Re: How to create Excel report of a dataset with summation of variabl...

How to create a dataset whose last row is summation of specified varia...

How to create Excel report of a dataset with summation of variable y?

Why a works but b not?

Re: how to create this report classified by k

Re: Using an array as a lookup table

Re: Using an array as a lookup table

Re: Rolling calculation dataset

Re: Rolling calculation dataset

How to rearrange the columns' order alphabetically

Re: Where is the physical location of work folder

Re: Find same value in two columns

Find same value in two columns

where to find the topic I made before?

Re: how to create this report classified by k

how to create this report classified by k

Re: How to create Excel report of a dataset with summation of variabl...

How to create a dataset whose last row is summation of specified varia...

How to create Excel report of a dataset with summation of variable y?

Why a works but b not?

Re: Rolling calculation dataset

Re: Rolling calculation dataset

How to change dataset like this

Re: Rolling calculation dataset

Rolling calculation dataset