About smm662002

smm662002 · ‎12-03-2015

Hello, I am creating two XLS report using proc report and ods excelxp.tagset (I am using SAS 9.3 on Windows). The code run without any errors and the report is created but after the file is created a SAS window is displayed asking if I want to open the XLS file in SAS. I have managed to disable this message window only by manually changing the options in Tools-->Options-->Preferences-->Results. The problem is that even if I change the display options in one session, SAS will still revert to the default settings when a new session is started. I have tried to use ods _all_ close, ods html close but no results. I think that the default options can be changed in the ODS SAS registry but I don't want to so far. Would anybody know what should I do to stop displaying that message window? Thank you, Madalin

smm662002 · ‎09-24-2013

Hello, I am trying to create an Excel report using Tagset.excelXP. I would like to create the report from column B instead of column A and let the column A blank. Would it be possible to do this by using tagsets? Thank you, Madalin

smm662002 · ‎11-06-2012

In fact I'm using SAS Data Integration Studio v 3.4. Would this make any difference?

smm662002 · ‎11-06-2012

More info: We have a large daily dataset that is updated every day which store about 5 years data (the file is aprox 7Gb while the index is about 1Gb). Based on this table we build two views: one weekly and one monthly. Because recently the dataset has start making problems and restoring the dataset from backups takes about 6 hours we have decided to split the dataset in two tables: a rolling 12 month file and a history file. In the current process we use 3 indexes. Because the views use all the data we need to union or append the two tables created and build the views. In the current process the views get the indexes from the parent dataset but the problem I have now is that after union join the 2 tables the views are not indexed. Is there a way to "transfer" the indexes to the views after the union join?

smm662002 · ‎11-05-2012

Hello, Would anybody know if possible to keep the indexes on a "view" resulted from a union join of 2 tables which have 3 indexes? I have to create the view immediatley after the join without creating any intermediary tables (the table would be aprox 9Gb ). The two tables I'm union are smaller parts of the same table which have been split to avoid data problems. Do you think that using append instead of union would keep the indexes? I'm using SAS DI 3.4. Thank you, Madalin

smm662002 · ‎05-16-2012

Thank you Udo, Much appreciated. Proc esm is the one I need but unfortunately I'm using SAS 9.1.3. Regards, Madalin

smm662002 · ‎05-10-2012

Hello, I am trying to run multiple SAS forecasts without using TSFS. Would it be possible to have the SAS code which would replicate the following model (the option bellow are the one I would use in TSFS Develop Models): (I'm using SAS 9.1.3) Interval: Month Period of Fit: Jan2008 to Mar2012 Period of Evaluation: Jan2012 to Mar2012 Forecast Horizon: 44 (to Dec2015) Error Method: Mean Absolute Percent Error Smoothing Model: Winters Method Additive Smoothing Weights: Level: Optimize Trend: Optimize Season: Optimize Bounds: Zero One/Additive No Transformation Thank you, Madalin

smm662002 · ‎05-10-2012

Thank you for your help. Regards, Madalin

smm662002 · ‎05-02-2012

Hello, I am using the Time Series Forecasting System to forecast some time series. Would it be possible to see or save the SAS codes used by this interface? (in a similar way as we can save the code when exporting a dataset) Thank you, Madalin

smm662002 · ‎03-16-2012

Hi, When using Program in SAS EG 4.3 there is an option where the user can select the server (if more than one server available) to use: "Selected Server" (this option is on the Program toolbar between "Stop" and "Analyze Program" buttons. Does anybody know if is possible to achieve the same results (to select the right server) but using code lines (maybe something similar to "libname" statement) instead of selecting the server manually? Thank you, Madalin

smm662002 · ‎03-15-2012

Hello, I'm trying to check the results from a query builder by using a data step merge in a SAS program in SAS EG 4.3. The query builder is extracting data from two tables linked via a join between WORK.table1 and CSRIDM.table2. There are no errors in the query builder log. When I'm trying to use the merge in the data step (SAS code is bellow) I have the error: "Libname CSRIDM is not assigned" I checked if the library is still assigned in the Server List and its color is yellow, so the library is assigned. Would anybody have any suggestions what is the reason of the error and how can be fixed? Thank you, Madalin

smm662002 · ‎02-22-2012

Hi, Thank you for your answer. Please find bellow the log extract, including the error. I have tried to use the macro variable in a query builder. You have mentioned that I have to run the autoexec before the query builder executes. Can you please tell me more about this? PROC SQL NOEXEC; 4 SELECT t1.Table 5 FROM MBMNTHM0.MCLAIM t1 6 WHERE t1.DATE >= &Date_RPT_From; _ 22 WARNING: Apparent symbolic reference DATE_RPT_FROM not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER. Thank you, Madalin

smm662002 · ‎02-22-2012

Hello, I have created three macro variables (presented bellow) and save the code in a process flow named AutoExec. I have tried to use these macro variables in a diffrent process flow in a querry builder and I had an error message (both process flows were part of the same project). Is there a way to transfer macro variables between diffrent process flows (without using prompts)? Is there a way to use Prompts to achieve the same results as the code I have bellow? data _null_; Extract_start=intnx('month',today(),-1,'b'); Extract_end=intnx('month',today(),-1,'e'); call symput('Date_RPT_From',put(Extract_start,date9.)); call symput('Date_RPT_To',put(Extract_end,date9.)); call symput('RunDate',put(today(),date9.)); run; Thank you, Madalin

smm662002 · ‎11-08-2011

Hi, I did try it but I had an error message. Would it be possible to have an example of the setup? In Connection Information GUI I have tried the following: Machine: localhost Port: 8561 For UserID and Password I used my Windows account login details. For Machine I have also tried 127.0.0.1. Thank you, Madalin

smm662002 · ‎11-08-2011

Hi, Would anyone know if it is possible to use the localhost (127.0.0.1) for creating a data Integration Studio profile? Thank you, Madalin

Online Status	Offline
Date Last Visited	‎08-11-2025 07:25 AM

proc ds2 error

Rule to restrict reports edit for custom user group

Add index to a CAS table which is already indexed

Why style not applied to SAS Job HTML output?

Re: SAS VIYA Job Schedule Issue

SAS VIYA Job Schedule Issue

Re: Optimising SAS VIYA Jobs

Optimising SAS VIYA Jobs

Proc DS2 error when processing Data Grid

SAS JES _action name=wait issues

Re: Pie Chart Legend Issue

Re: Create geo-line geography roles

Rule to restrict reports edit for custom user group

Re: CAS action table.tableInfo - create date detail issues

Re: SAS VIYA 3.5 Environment Manager Monitor Job inconsistent Status r...

Re: load dataset from client to CAS

Re: Writing to a non standard caslib in data step

Use proc report in tagset.excelxp in SAS 9.3 issue

tagset.ExcelXP and Excel empty columns

Re: "View" Index after Union Join?

Re: "View" Index after Union Join?

"View" Index after Union Join?

Re: SAS code example to replicate TSFS interface

SAS code example to replicate TSFS interface

Re: SAS code generate by SAS Time Series Forecasting System graphic in...

SAS code generate by SAS Time Series Forecasting System graphic interf...

"Selected Server" option in SAS EG Program

Library in data step and in query builder in SAS EG 4.3

Is it possible to transfer macro variables between Process flows in th...

Is it possible to transfer macro variables between Process flows in th...

Create a Data Integration Studio profile using Localhost instead as se...

Create a Data Integration Studio profile using Localhost instead as se...