About Akash93

Akash93 · ‎09-26-2023

Could you please share screenshot of your data to understand exact requirement?

Akash93 · ‎10-14-2022

Dear All, I have used periodic calculation functionality in VA to show cumulative profit growth(month on month). When I am placing required columns in list of cross tab result is showing correct. However, When I am trying to use control object to see particular month growth then I am getting original profit of that month in place of cumulative values. Attaching details. Please help me out. Regards, Akash

Akash93 · ‎05-31-2022

Hi Team, We have developed stored procedure to download data dump in text file with below code. proc export data=data_download outfile="path" file =_webout dbms=tab replace; run; In output last 11 column names are getting excluded. Means row 1st is blank for these 11 columns and data is flowing for these columns. I am attaching sample for reference. Please help if there is any solution. Regards, Akash

Akash93 · ‎03-02-2022

Hi Madelyn, We are getting desired details by following suggested steps till point # 6. We are unable to get details for below points : 7. Next, look at the Server tab. 8. Scroll to the bottom where you will see propery names and their values. One of the values should match the rowCount you see on the oResults tab. This is the property that would have to be increased in order to display all available rows and avoid the warning. Our Current SAS VA version is : 7.51 Regards, Akash

Akash93 · ‎02-22-2022

Hi We row limit is already set to 40k and our total data is 29k only. Regards, Akash

Akash93 · ‎02-22-2022

Hi Sam, It is working after applying changes. Thanks a lot ! Regards, Akash

Akash93 · ‎02-18-2022

Hi Team, We are developing list report on numeric column and comma format is getting applied properly. Ex : We should get result as 12,29,31,479 however we are getting as 122,931,479. Please note : Data we are loading from teradata environment where correct format is flowing in teradata table. Regards, Akash

Akash93 · ‎02-18-2022

Hi Team, Please find attached for warning. Regards, Akash

Akash93 · ‎02-18-2022

Hi Team, Is there option to hide warning shown in attached from VA objects. We are able see all data (maximum rows is 30 k & 29 columns).However, We are getting in viewer. Is there option to remove such warning. Regards, Akash

Akash93 · ‎02-12-2022

Thanks Kurt_Bremser..It helped me to achieve required output.

Akash93 · ‎02-02-2022

Hi Team, I want to download output in text delimited format using Sas Stp. I have cracked downloading in CSV,Excel and RTF with below code. data _null_; rc =stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); rc = stpsrv_header('Content-disposition','attachment;filename=Test.csv'); run; ods listing close; ods tagsets.csv body=_webout style=sasweb; proc print data=Transaction_Detail_dt_acct noobs; title 'test1 excelxp mimetype=application/vnd.ms-excel'; run; ods tagsets.csv close; Please suggest. Regards, Akash

Online Status	Offline
Date Last Visited	‎09-26-2023 05:30 PM

Re: How to create percentage calculated field in SAS viya 3.5

Periodic calculation issue in SAS VA

SAS stored process data dump download issue

Re: Remove Warning From SAS VA List/Cross Objects

Re: Remove Warning From SAS VA List/Cross Objects

Re: Comma format getting removed in SAS VA report

Comma format getting removed in SAS VA report

Re: Remove Warning From SAS VA List/Cross Objects

Remove Warning From SAS VA List/Cross Objects

Re: Facility to download output in text delimited format using STP

Re: How to create percentage calculated field in SAS viya 3.5

Periodic calculation issue in SAS VA

SAS stored process data dump download issue

Re: Remove Warning From SAS VA List/Cross Objects

Re: Remove Warning From SAS VA List/Cross Objects

Re: Comma format getting removed in SAS VA report

Comma format getting removed in SAS VA report

Re: Remove Warning From SAS VA List/Cross Objects

Remove Warning From SAS VA List/Cross Objects

Re: Facility to download output in text delimited format using STP

Facility to download output in text delimited format using STP