When I am trying to run this below piece of code from SAS EG, the xml file is opening with the required data   ods tagsets.excelxp file="/trnapp/sas/dev/projects/so/shovan/&rep_name._9.xml" style=printer; proc report data=p.testing; columns _all_; define road_number / 'road_number' style={tagattr="format:@"}; run; ods tagsets.excelxp close;   But when I am trying to run this code from a stored process( The stored process contain several macros and in one of the macro contains the above code) through SAS Portal, I am able to download the file and when I am opening it it is saying "Unable to Read File". The file is getting created in the physical location and the size is only of some KBs and also when I am opening that file it is giving that error. FYI,This code is within a %do; %end clause in one of the macro from the stored process but from SAS EG i was running it without %do; %end.   Can you please help me regarding this. ... View more

Using ODS CSV, when I am running from a stored process program the data is not getting populated in the csv file. It is showing blank.   For your reference, I used this ods csv code. I ran the stored process program from SAS 9.3   ods _all_ close; ods csv file="/trnapp/sas/dev/projects/so/sho/num_as_char28.csv" options(Prepend_Equals='Yes' quote_by_type="Yes" ); proc print data=adw_mwh_to; run; ods csv close; ... View more

Hi SAS Experts   In a report which is in csv format, there is column say 'X'. So if one of the value say 0879 which is in the actual source data but in the report which is in csv format is showing as 879. But we want the value as 0879.  So in the below mentioned sas code, we did the following by changing the numeric to string format but in this also the 0 is getting omitted.   For Example:   data test ; prodID = 0457 ; result = put(prodID , $4.) ; run ; proc print ; run ;   So how can we resolve this so that when we download the report, it will show exact value as shown in the source data when the value starts with 0 in Excel. ... View more

Last week we had our unix patching in Dev server. So after the patching we restarted the services and for testing purposes, we opened the SAS Portal. It opened successfully but when we were going to CMR app from the portal, the login icon was not showing up and it is giving up errors.    Stored Process Error Unable to execute stored process. Unable to connect to a SAS server.   Can you help me in resolving this error and how to proceed in fixing these errors. ... View more

In one of my date variable the value stores as '09MAY2019:14:51:51.000000'   So I need to concatenate additional time format characters in this timestamp because I need to change it to another timestamp format in my sql pass through query.   So how can I resolve the the above mentioned timestamp into another variable to to_timestamp('09MAY2019:14:51:51', 'DDMONYYYY:HH24:MI:SS')    The above mentioned statement should be stored in another variable. For example...09MAY2019:14:51:51 is one timestamp value. There are different timestamp values ... View more

Inserting records into Oracle database using SQL passthrough query doesn’t shows the number of records inserted to the table.   Am using SQL passthrough query for inserting records to the DB table in Prod SQL. The macro code is being included in the parent code that is scheduled for processing. When I run manually the macro code in SAS EG, I can see the number of records inserted in the table. But when running in the include code in the parent code together, it doesn’t shows any logs messages on how many records are inserted in the oracle table.   In SAS EG – can see – ORACLE: 0 rows inserted/updated/deleted. 153 1556630270 no_name 0 SQL (2)   While running in the parent code –  cannot see the records inserted in the oracle table as in below log. Already using %PUT &SQLXRC. &SQLXMSG. ; and this only shows 0 as return code is zero with no error message –   MPRINT(EXECUTESEQUERY):   *SE scrub stg; MPRINT(EXECUTESEQUERY):   proc sql; MPRINT(EXECUTESEQUERY):   CONNECT TO oracle ( path=xxx authdomain="xx") ; MPRINT(EXECUTESEQUERY):   execute ( INSERT INTO tablename ( col1, col2 ) select app_transaction_key, T. scrub_key, sum(T.flag) as override_type from ( select a.app_transaction_key, b.scrub_key, 1 as flag from schema.v_transaction_current a, schema.master b where trunc(a.s_effective_from) > '30-APR-2019' and b.query_group_key = 80 and WAREHOUSE_CODE='PPP' AND CUSTOMER_NAME='SAN' union Select a.app_transaction_key, a.scrub_key, -1 as flag from schema.v_transaction_current c, schema.v_tran_current a, schema.master b where c.app_transaction_key=a.app_transaction_key and b.scrub_key = a.scrub_key and trunc(c.s_effective_from) > '30-APR-2019' and b.query_group_key = 80 ) t group by T.app_transaction_key, T.scrub_key ) by oracle ; 0 MPRINT(EXECUTESEQUERY):   Disconnect from oracle; MPRINT(EXECUTESEQUERY):   quit; NOTE: PROCEDURE SQL used (Total process time): ... View more

Hi SAS Experts,   Our current SAS env ( SAS EG, SAS DI, SAS OLAP, SAS Infomap, WRS, Portal, Enterprise Miner) is installed in Linux OS. We are planning to upgrade the version and move from Linux to AWS platform. Please share any documentation to refer to perform the migration from one platform to another.   AWS is vast in documentation and what should be considered for migrating the big change(SAS Environment) from Linux to AWS. We need something specific to SAS only. ... View more

How can I change the default username of sysuserid?   ... View more

Hi SAS Experts   When I am deleting records from a table with Proc Sql method, it is deleting the records but it is not reclaiming the space. Everytime I run the same code and inserting it again, It shows the actual number of rows but the space is increasing.  So can I reclaim the space with Proc SQL method and also why I am seeing this issue?     ... View more