Well I would suggest you use proc compare as mentioned by tom or use proc content . This would help you decide your next steps. Make sure the are identical - type, length, format .
... View more
SAS gives multiple approaches to the same issue. This is mine proc sql; create table work.test2 as select year,qtr , Max(var3) as var3, Max(var4) as var4 from work.test group by year, qtr order by year, qtr; quit;
... View more
This happens if a variable is of character type in one data set and numeric in another. Please have a uniform data type or considering converting both to the same type.
... View more
I have not worked with DI studio, however based on my experience with folders on a BI server have a suggestion. Perhaps the information I give may be of help. In BI server the metadata folders can be exported as a package and imported. Similarly in the DI studio one should be able to rearrange folders ( http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/viewer.htm#n0qdpe8ffsg8w9n1d7svdr3ox46w.htm ) With this information one can create 1. new subfolders 2.Copy the contents from the older ones'(one approach is to export and import) 3) set new properties. If this works, the old folders can be given a new name and the new folder can be given the name of old folders.
... View more
The size of 5 MB mentioned is about SAS logs. There are ways and means to overcome this. What size you want to limit? Need clarity on this.
... View more
Thanks everybody for your time and efforts in answering my question. I agree that it is possible to schedule SAS EGP using vbscript . Thanks for the answer. However as mentioned in my question and reproduced below : $my_object=SASEGApplication.Model.Application7.1 $my_egp =new-object -cpmObject $ob $EGP.open ("D:\my_egp_projec.egp", "") This is creating an EG object . As I understand now this involve the IOM object module. This requires access to metadata server/Object spawner/workspace server. So this approach is not possible on PC SAS with no access SAS Server. Thanks once again everybody for their time.
... View more
I have just tested your code in SAS Studio It works. The log is shown below : 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 73 74 ods excel file="/folders/myfolders/Excel/test_01JAN2019.xlsx"; 75 /*https://communities.sas.com/t5/SAS-Programming/ods-excel/m-p/523987*/ 76 proc freq data=sashelp.class; 77 tables age; 78 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: PROCEDURE FREQ used (Total process time): real time 0.12 seconds cpu time 0.10 seconds 79 proc freq data=sashelp.class; 80 tables sex; 81 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: PROCEDURE FREQ used (Total process time): real time 0.07 seconds cpu time 0.05 seconds 82 ods excel close; NOTE: Writing EXCEL file: /folders/myfolders/Excel/test_01JAN2019.xlsx 83 84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 97
... View more
Thanks SASKiwi and Casey Smith for inviting my attention to examples of the capabilities of Powershell - SAS automation. My question is about the requirement to carry out such tasks and not capabilities. My question is can I run a SAS EG project in a batch mode with Base SAS and SAS EG installed locally say a laptop or a desktop (and more specifically not a server installation so no metadata server available - either locally or remote)
... View more
Hello Base SAS code (say somefile.sas) can be run in batch mode on base SAS . Can we similarly run the SASEGP project on base sas (with SAS EG installed) on a desktop using power shell (not vbscript). My idea is to us code something like this $my_object=SASEGApplication.Model.Application7.1 $my_egp =new-object -cpmObject $ob $EGP.open ("D:\my_egp_projec.egp", "") --------- I know Chris Hemedinger has written a number of blogs on similar topic, but I could not find the answer to my question. Has anybody used a similar approach
... View more
I was planning to automate running SAS EGP to run in batch. Scheduler calls a power shell script that would run the EG project. The EG log will not be written to any file and the error code would be caught. The following link gives the error code that SAS program would return when running on batch mode on windows. http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#n0d8f2zgsbjtqwn1f384lia2nlbm.htm Are these codes the same if we run the SAS enterprise guide project in windows in batch mode using power shell script (not VB script).
... View more
Hello Is there a difference between folded F test and Fisher F test. (The new SAS Certification guide for statistical business analyst uses this term).
... View more
