Hi, Can I make a test of proc DS2 in 'SAS onDEmand for academics'? Do I need an special dataset? Thanks ... View more

Hi,   I am getting problems using %str.   When i do:   %let val = %str(data coches; set sashelp.cars; run); %put val = &val.; &val.; it works properly, but now I make a modification:   %let fich = cars; %let fich2 = %str(%")&fich%str(%"); %let val = %str(data coches; set coches; fichero = &fich2 ;run;); %put val = &val.; &val.; it doesn' work in the put stament I can see the macrovaroable well created %put val = &val.; val = data coches; set coches; fichero = "cars" ;run; but when I invoke tha macrovariable to execute de the data steps with errors:   23 &val.; 180: LINE y COLUMN no se pueden determinar. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. _ 386 200 ERROR 386-185: Expecting an arithmetic expression. ERROR 200-322: The symbol is not recognized and will be ignored. 24 25 GOPTIONS NOACCESSIBLE; 26 %LET _CLIENTTASKLABEL=; 27 %LET _CLIENTPROJECTPATH=; 28 %LET _CLIENTPROJECTNAME=; 29 %LET _SASPROGRAMFILE=; 30 31 ;*';*";*/;quit;run; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: The SAS System stopped processing this step because of errors.   Can anybody help me?? Thanks in advance ... View more

Hi,   I use the _method in proc sql in order to know the execution plan, but I have a question, ¿is there anyway to change the execution plan in SAS?. I know that creating an index can change the execution plan, but I dob't know other options... Any help will be greatly appreciated   proc sql _method; create table prueba3 as (select cod_articulo, sum(hc_venta) as ag_venta from prueba1 group by cod_articulo); quit; ... View more

Hi,   I am using proc princomp to reduce number of vars in a model.I don't have previous experience with PCA I have a simple question: Using proc princomps I get the eigenvalues and the coefficients that relate its with raw vars. I have 30 raw vars and using PCA I can reduce to 7 pca vars (eigenvalues) that keep 95% of datasets variance.  I want to work with this 7pca vars in my model, but now I have a doubt: Once created the model with the 7 pca vars I want to validate this model with a test dataset. How I get the 7 pca vars in my test datasets?, do I have to use the coefficients obtained in the proc princomp to calculate the 7 pca vars of the test dataset and then apply the model?   Any advice will be greatly appreciated. ... View more

  Hi,   I have a workflow in a SAS EG project. I would like to know if it's possible to condition the execution of a workflow to the value of a a macrovariable. For example if &var=1 -> execute all the branch of the workflow, else don't execute. I know how to do something similar with sas base code using macros, but I would like to know if it is possible in workflows of SAS EG projects.   Thanks in advanec, ... View more