About ShufeGuoding

ShufeGuoding · ‎03-02-2019

How many variables can we have in a sas dataset?

ShufeGuoding · ‎02-21-2019

Some statistical analysis procedures, such as Proc Model, Proc SSM, PROC MCMC have their programming statements, most of which are the same as those in DATA step. There is even a PDV option in OUTPUT statement of PROC SSM. Put things together , I infer that SAS PROCs read and deal with the observations in SAS data sets in the similar way to that in DATA STEP.

ShufeGuoding · ‎02-21-2019

How the statistical procedures in SAS, such as proc means, proc model , to quote only a few, to read data from the SAS datasets? , read the all observations once a time to calculate the statistics, such as sample mean, or read one observation each time into PDV as DATA STEP and calculate the statistics each time? I can 't find the answer in SAS document and ask help.

ShufeGuoding · ‎10-23-2018

When readding an observation from data set using set statement in each data step iteration, Can we only do the lookup in a subset containing the observations within a date interval of 30 days from current date. In other words, is there a way to load a subset rather than the whole dataset into hash object and remove it after lookup finish, and load another subset into hash dynamically?

ShufeGuoding · ‎10-21-2018

my data set has 20 millions observation and the lookup costs time very much.Is there any other solution?

ShufeGuoding · ‎10-21-2018

only use sellid and buyid to identify the person who buys in next 30 days after sell.

ShufeGuoding · ‎10-21-2018

Thanks for your solution. I don't understand the necessity of the following statement if 0 then set have; and what the 0 stands for in that statements.

ShufeGuoding · ‎10-15-2018

I have a data set p2p as following sellid buyid id date 1000023 1144058 292173 2016/11/7 1000023 477211 292178 2015/10/27 1000023 1569350 292178 2015/10/27 1000023 318100 289648 2015/4/7 1000023 350832 289652 2015/4/7 1000023 560400 289648 2015/4/7 1000023 259210 292173 2016/11/7 1000023 1466757 289652 2015/4/7 1000023 10626 292213 2016/11/7 1000023 259210 292221 2016/11/7 1000023 328802 292221 2016/11/7 1000023 827855 289648 2015/4/7 1000023 10626 292173 2016/11/7 1000023 823271 292173 2016/11/7 1000023 1597616 292202 2016/11/7 1000023 5068647 292202 2016/11/7 1000023 823271 292213 2016/11/7 1000023 10626 292173 2016/11/7 1000023 2282389 292221 2016/11/7 1000023 1451751 289648 2015/4/7 1000023 823271 292202 2016/11/7 1000023 1661710 289652 2015/4/7 1000023 1086373 292213 2016/11/7 1000023 1854328 292173 2016/11/7 1000023 963867 290497 2015/4/7 1000023 406023 289648 2015/4/7 1000023 211396 290802 2015/4/7 1000023 719501 289652 2015/4/7 1000023 1509387 290496 2015/4/7 1000023 1086373 292221 2016/11/7 1000023 963867 290497 2015/4/7 1000023 1597616 292213 2016/11/7 1000023 1536356 289652 2015/4/7 1000023 2282389 292213 2016/11/7 1000023 1536356 290497 2015/4/7 1000023 1867463 292202 2016/11/7 1000023 2356403 292178 2015/10/27 1000023 196966 290497 2015/4/7 1000023 1144058 292202 2016/11/7 1000023 259210 292202 2016/11/7 1000023 1536356 289648 2015/4/7 1000041 744402 107950 2015/4/7 1000041 1166120 107950 2015/4/7 1000041 1514527 107950 2015/4/7 1000041 793936 357766 2015/4/7 1000041 1617063 357766 2015/4/7 1000041 793936 107950 2015/4/7 1000043 2414987 661415 2016/1/26 1000043 1878751 563862 2016/1/26 1000043 2527958 415597 2016/1/12 1000043 1288675 347600 2016/1/26 1000043 1668672 537277 2016/1/26 1000043 5973865 2084280 2017/1/9 1000043 1012668 299174 2015/10/13 1000043 1301405 415765 2016/1/26 1000043 2252908 669278 2016/1/26 1000043 1910747 133016 2016/10/15 1000043 760352 620837 2015/12/27 1000043 1789216 578613 2016/1/26 that is the trade record peer to peer. I want to find whether the seller buy again in the next 30 days,and ran the following code data want; set p2p curobs=obs1; obs2=obs1+1; do while (date2-date<30); set p2p( rename=( date=date2 sellid=sellid2 buyid=buyid2 id=id2 ) ) point=obs2 ; If buyid2=sellid Then Flag = 1; Else Flag = 0; output; obs2+1; end; run; The data step runing in a dead loop!! Please give me your help hand, thanks.

ShufeGuoding · ‎10-06-2018

My intention is to understand the way in which the data step read the obervations in input data set. I just wander why the different obervations are read sequentially in the do loop in one data step iteration in the first code , but it did not in the second code. Thanks a lot!

ShufeGuoding · ‎10-06-2018

why?

ShufeGuoding · ‎10-06-2018

What's the difference between the results from two data step in the following? data s; do n=1 to 2; set sashelp.class; end; run; data s; set sashelp.class; set sashelp.class; output; run;

ShufeGuoding · ‎07-21-2015

In nlp optimization, when trival errors occurs, objective function can be evaluated as infinite to get around the error. Is there the infinite constant in IML?

ShufeGuoding · ‎07-19-2015

I define a objective function and use optimization subroutine NLPNMS to optimize it in IML. After a long time runing, the following error pops up in log window: ERROR: NMSIMP Optimization cannot be completed. ERROR: The function value of the objective function cannot be computed during the optimization process. ERROR: Execution error as noted previously. (rc=100) operation : NLPNMS at line 501 column 1 operands : *LIT1287, x0, , constr *LIT1287 1 row 1 col (character, size 2) ml x0 1 row 6 cols (numeric) 0.5 0.1 0.1 0.5 0.1 0.1 constr 2 rows 6 cols (numeric) -0.99 0.01 0.01 -0.99 0.01 1 0.99 . . 0.99 . . statement : CALL at line 501 column 1 501! /*call Nelder-Mead Simplex optimization subroutine*/ 502 print xr; ERROR: Matrix xr has not been set to a value. If I use the xr at this step as my suboptimal result, how can i get it?

ShufeGuoding · ‎07-16-2015

When i use create statement to create a data set in a do iteration in IML, the message"note: a data set xxx has one varialbe and xx " pops up repeatedly in log window , which slows down the computaion. How to prevent that happens?

ShufeGuoding · ‎03-19-2015

Is there any function or algorithm to verity a matrix is nonsingular in IML? I need if in a "if then"statement.

Online Status	Offline
Date Last Visited	‎03-02-2019 04:39 AM

Number of Columns in a Dataset

Re: The way in which procs read data

The way in which procs read data

Re: How to mathing current oberservation with next observations to lo...

Re: How to mathing current oberservation with next observations to lo...

Re: How to mathing current oberservation with next observations to lo...

Re: How to mathing current oberservation with next observations to lo...

How to mathing current oberservation with next observations to lookup...

Re: set a dataset many times within a data step

Re: set a dataset many times within a data step

Re: Is not missing

Error: Result of when clause 8 is not same data type as the preceding ...

Re: Fill in observations of controls to match value of cases (by panel...

Re: Fill in observations of controls to match value of cases (by panel...

Re: Wrong median survival time in proc lifetest in SAS ondemand

Number of Columns in a Dataset

Re: The way in which procs read data

The way in which procs read data

Re: How to mathing current oberservation with next observations to lo...

Re: How to mathing current oberservation with next observations to lo...

Re: How to mathing current oberservation with next observations to lo...

Re: How to mathing current oberservation with next observations to lo...

How to mathing current oberservation with next observations to lookup...

Re: set a dataset many times within a data step

Re: set a dataset many times within a data step

set a dataset many times within a data step

Is there the infinite constant in IML as in Matlab?

How to get the optimizations results when the error occurs?

How to prevent the "note:xxxx" to be displayed in log window when IML ...

How to test the singularity of a matrix in IML?