About Kalind_Patel

Kalind_Patel · ‎08-30-2016

Hey, Finally, I got the solution, I have done this by using "BY" statement in Proc tabulate, For that, I have created new variable called count, And this variable change it's value (eg: 1 to 2) after every 6 unique value of my name variable in my scenario, the reason is that on pdf page it is showing 6 name variable values, So now I have used that variable to add another page, Thanks @Reeza & @ballardw for your help :smileyhappy . Regards, Kalind

Kalind_Patel · ‎08-29-2016

thanks for the reply reeza, Is there any other procedure then tabulate? In which i can do this?

Kalind_Patel · ‎08-29-2016

Hi All, I want to add page break in xls file, i am using proc tabulate to create output in excel, I have already tried pagebreaks="yes", pagebreak_row options but i am not able to break that in xls file, I am attaching the desired sample in screenshot.

Kalind_Patel · ‎08-29-2016

Thanks a lot @JuanS_OCS; I appreciate your help & quick response. This reply would be enough for me to start working on it. 🙂

Kalind_Patel · ‎08-29-2016

Hello Geniuses, We have SAS Office Analytics Suite, I want to know that when the user have logged into which application (like SAS EG, SAS Studio, SAS Add-in) and when he logged out from that application, and also how much memory user is using for that application, Is that kind of things we can do in SAS? If yes then please show me the way, i will really appreciate that. Thanks & Regards, Kalind

Kalind_Patel · ‎05-29-2016

Hi @aj34321, this error generally comes when your sassrv account or sastrust account have not proper credentials or roles assigned, please read the object spawner log it will give you clear idea about that, And also make sure that sassrv password have not changed after the installation, and if changed then you have used SDM to update the paaswords.

Kalind_Patel · ‎05-28-2016

Hi Folks, Can we add the SAS VA reports on Wordpress website ? I know one way which is mentioned here: http://blogs.sas.com/content/sgf/2015/09/16/accessing-va-reports-with-parameterized-urls/ But here i have to give credentials for that specific report if i am not logged into VA, So is their any other way like SAS VA Webpart (limited to MS Sharepoint only), where i don't need to give credentials and it will work like the token authentication or other way which is secured like the VA Webpart??

Kalind_Patel · ‎05-13-2016

What is pid of that port 80 ? Have you installed Apache on that server ? If not than SAS' Apache service is running on that.

Kalind_Patel · ‎05-13-2016

SAS VA 7.3 generally take 7-10 mins to start after all services are started, so please wait for 7-10 mins after you restart all the services, and try to access that link.

Kalind_Patel · ‎05-13-2016

It looks like that other process is running on the same port, thats why Web server can not start, can you free that port and try again? generally 80 port is used by SAS Web Server.

Kalind_Patel · ‎05-13-2016

Hello @aola; You can use SASDATEFMT option like that in your query; ( sasdatefmt=( date1='datetime21.') ) This is the link for more info: http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001371624.htm

Kalind_Patel · ‎05-13-2016

Hi @pedrammobedi, Have you checked log for webserver? what it is showing?

Kalind_Patel · ‎03-06-2016

Thanks @freelancereinhard for you advice, But unfortunately it will not work in VA, Because va will do live calculations, Not like base sas, so it will not work, But anyway i really appreciate your assistance to solve this issue, thank you very much.

Kalind_Patel · ‎03-06-2016

Thanks @freelancereinhard for your reply, actually i tried both ways, using same name of predefined format & using with another name, But no luck !! And about VA limitation which i am talking about, i am also surprised after i knew that VA is not allowing variable (which has user-defined format ) to calculate, in base sas and eg, i can easily do calculations on the same variae with same user-defined format. Please see this link : http://support.sas.com/kb/47/100.html In this link under "Formats in SAS® Visual Analytics Designer" section, it is clearly mentioned that you can not convert that variable (user-define format enabled ) from category to measure, and even i can not do calculations before applying the format, it is not possible in my scenario.

Kalind_Patel · ‎03-06-2016

Hi All, Is their any way to change pre defined format ? For eg: i want to change commaw.d format, which is by default giving value like this 123,456,000 but my client wants value like this 12,34,56,000 (in indian comma ) My problem is that i had tried to create picture format and imported this format in SAS VA, but in VA if we use any user-defined format than it will convert that variable to category, and we can not convert it to measure if we want to use user-defined format (in my case that format is indian comma format), so in category i can not do calculations on that variable with user-defined format, ao is their any other way to apply user-defined format in VA and can do calculations also.

Online Status	Offline
Date Last Visited	‎12-01-2023 07:25 PM

Re: SAS 9.4 license

Re: Unable to launch SAS Deployment Wizard from SAS web server as a di...

Re: Start LASR Servers via API

Re: Theory of relativity in SAS programming

Re: Create a Bar Chart Race in SAS using SGPLOT Procedure

Re: Create a Bar Chart Race in SAS using SGPLOT Procedure

Create a Bar Chart Race in SAS using SGPLOT Procedure

Re: Interrupted Installation: Now I can't finish Install OR Uninstall

Re: Interrupted Installation: Now I can't finish Install OR Uninstall

Re: Folder and Table locked and not removable

3rd Place Winner - 2023 Customer Awards: ICON - Curious Thinker

Fake News Detection

Build a HTML5 Web App Using SAS 9 or Viya

Platform and Security related Updates in SAS 9.4 M6

Start LASR Servers via API

Re: Theory of relativity in SAS programming

Re: Folder and Table locked and not removable

Re: Interrupted Installation: Now I can't finish Install OR Uninstall

Re: Correct the spelling if middle of the string

Re: Avoid restarting the server for configuration change to take effec...

Create a Bar Chart Race in SAS using SGPLOT Procedure

Start/Stop all SAS Services in Windows using Batch File

Re: Insert Pagebreak in ods tagsets.excelxp (.xls file)

Re: Insert Pagebreak in ods tagsets.excelxp (.xls file)

Insert Pagebreak in ods tagsets.excelxp (.xls file)

Re: View SAS User's Login Logout time & memory usage

View SAS User's Login Logout time & memory usage

Re: Content Server Validation - Java Connection time out error.

View SAS VA Reports on Wordpress Website

Re: httpd WebServer not starting

Re: Webapp not up after Deployment (SAS Visual Analytics Hub not worki...

Re: httpd WebServer not starting

Re: date format in proc sql

Re: httpd WebServer not starting

Re: Modify Predefined format

Re: Modify Predefined format

Modify Predefined format

SAS Global Forum 2017

SAS Global Forum 2019

SAS Global Forum 2016