About qkaiwei

qkaiwei · ‎05-24-2013

I use block statment in proc gmap with an anno data, the anno can be used successfully to mark province names in choro statment, but be not suitable in block statment. Anyone who can give me an example of annotate dataset which can be used in block statment. William Que

qkaiwei · ‎05-23-2013

When developing an Add-in for enterprise guide, and executing a stored process using obWs.LanguageService.StoredProcessService.Execute("abc.sas","") I find that, if the work library path of obWs is /sas/temp/abcde, then all datasets created by the stored process are stored in a sub-directory under the work path, such as /sas/temp/abcde/a12345/. So I can't visit them using OleDbConnection got from obWs because the work library paths of obWs and StoredProcessService are different. Any ideas? Thanks! public SAS.Shared.AddIns.ShowResult Show(System.Windows.Forms.IWin32Window Owner) { SAS.Tasks.Toolkit.SasServer obServer; SAS.IWorkspace obWs = null; string strServer = consumer.AssignedServer; consumer.Workspace(strServer); try { obWs = consumer.Workspace(strServer) as SAS.Workspace; obServer = new SAS.Tasks.Toolkit.SasServer(strServer); } catch { return SAS.Shared.AddIns.ShowResult.Canceled; } ..................... }

qkaiwei · ‎05-01-2013

I answer it by myself. Use PROC FCMP to create some functions to solve it, the mechanism of SAS is a little different with that of MATLAB.

qkaiwei · ‎05-01-2013

Hi all: I define 4 numeric variables: a, b, c, d and want to calculate the minimal value of objective function, and meet a problem. When interating, the a variable named flag is based on variable a, b : flag=max(a,b), and the flag variable is also involved in the objective function, for example: min f= X + a*Y * flag - ........; that means the flag variable value and the objective function will change during each interation. So how to define them in proc optmodel. Thanks!

qkaiwei · ‎03-18-2013

I create a dataset named T with an index date, data t(index=(date)); do i=1 to 1000000; date=intnx('day','01jan2010'd,i); x=1;y=2222222;z=33333; output; end; format date yymmdd10.; run; The following two pieces of codes are to delete obs efficiently using indexes, but after submitting, I find the size of physicial file of table T don't change(perhaps called logically delete). The reason why I use the following is that they do not create a new copy of the data set and delete indexes, save time of re-creating, but if logically delete, the table size will become bigger an bigger, and the IO time will increase rapidly. How to balance? data t; modify t; if date<='01feb3050'd then remove t; run; proc sql; delete from t where date<='01feb3050'd; quit;

qkaiwei · ‎03-03-2013

How to specify the default path of images generated by proc sgplot. thanks!

qkaiwei · ‎01-23-2013

R language stament, and how to do it by SAS IML? b<-sample(1:9,size=3,replace=FALSE) , that means creating 1 set with 3 elements, every element is randomly selected from 1 to 9, and each element is different with the other two in the set(non-replacement sampling). Thanks！

qkaiwei · ‎11-01-2012

We can use BASS model to predict sales of new proudcts in the future, but can any give me a suggestion how to predict sales of every products for an new dealer? Thanks!

qkaiwei · ‎10-08-2012

Hi all: Why can't I find X-11, X-12 model in the model library of SAS Forecast server? Thanks

qkaiwei · ‎09-05-2012

I have a table of data cleaning rules in one excel sheet, with variables: table_name, statement, like the following: table_name statement ------------------------------------ a if ..... then ..... b if birth_date=. then birth_date=input(substr(id,3,8)),yymmdd10.) The excel file will be modifed by our customer, new data cleaning rules will be added or modified into it. During the ETL process, all rules will in the xls file will be loaded and checked syntax, and then take effect by a SAS macro. The question is: for an undeclared vairable in a data set. the substr function does not give an error message showing the varible doesn't exist, but create a new one. so the above step of syntax checking will mleiss some errors. Thanks!

qkaiwei · ‎07-31-2012

When looking though the illustration of croston's model in SAS help, the help explians the initialization of the model, that's when the starting time t=1: the level of q(1)=max[q(1), the level of q(0)], where the level of q(0) is is the final backcast level state. So please tell me what's the final backcast level state, if possible. Thanks!

qkaiwei · ‎07-08-2012

Thanks.

qkaiwei · ‎07-04-2012

Hi all: I have an equation, w*P=w, w means a 1*3 row vector, with unknown elements, but sum of all element is 1, P means a known 3*3 matrix, so how to calculate the w by iml? thanks!

qkaiwei · ‎03-14-2012

Hehe, In ENGLISH environment, column's labels are almostly same as column's names, but if in Asia language environment, you know, there are so much trouble. More than 30 variables , right click one by one ?

qkaiwei · ‎03-13-2012

I strongly recommend that a button used to switch between showing labels and showing column names should be added on the toolbar of datagridview in EG. Althougn I know the same function exists in the 'Options' panel.

Online Status	Offline
Date Last Visited	‎11-21-2018 09:48 PM

Optmodel problem

Re: proc glmSelect and offset variable

proc glmSelect and offset variable

Re: How to add moving average after hpfdiagnose

Re: How to add moving average after hpfdiagnose

How to add moving average after hpfdiagnose

Re: Path analysis node of EM 7.1

Re: Path analysis node of EM 7.1

Re: Path analysis node of EM 7.1

Re: Path analysis node of EM 7.1

Annotate data of proc gmap - Block statment

Problem of developing an Add-In

Re: Proc optmodel - Dynamic variable and objective function

Proc optmodel - Dynamic variable and objective function

Delete obs efficiently

The default image path of sgplot

What's the same function like R statement?

Sales forecast of new dealer.

X-11,X-12

substr function does not give error info when meeting undeclared varia...

croston's model

Re: How to solve the equation?

How to solve the equation?

EG suggestion

EG suggestion