cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ANLYNG
‎09-12-2023
  • 128 Posts
  • 26 Likes Given
  • 1 Solutions
  • 11 Likes Received

SAS VA homepage/report portal

by Pyrite | Level 9 in SAS Visual Analytics
‎02-07-2018 05:41 AM
‎02-07-2018 05:41 AM
Hi,   We want to use visual analytics as report portal for our users.   We have different appartments who needs to see specific reports and visual graphs on their report page. In the old days we used BI server portal in order to show/filter the raports. But how are things in that relation in VA?   1. I can see that it is possible to create your on customized homepage with collections (which can be filtreret user group wise). But some how it does not look nice.   2. I have tried to create a VA report with links. I can look great. But the problem is that it is that i can not hide links (to the reports) and I it seems not possible to import report collections (where I can filter per user group what is visible).   3. A possibility is to build up a eg. HTML page outside VA - but then the issue is lower performance as i takes time to load the VA hub every time and therefore I think it is better to build it in SAS VA?   Do you have any ideas how to progress or some examples or hint??   Thanks in advance.         ... View more

Show updated data on a report

by Pyrite | Level 9 in SAS Visual Analytics
‎02-07-2018 05:29 AM
‎02-07-2018 05:29 AM
Hi, We are running SAS visual Analytics 7.3 and i want to show the date the data was updated on the raport.   I tried to show it in a list table (one colimn).   The problem is that it look ugly as VA show the next emty column depending on which screen you have.   Is is possible to restrict the number of shown column in a list table.   Like this (see attachment)     ... View more

Re: SAS do loop sgplot

by Pyrite | Level 9 in SAS Programming
‎01-26-2018 02:04 PM
‎01-26-2018 02:04 PM
This is a nice solution and it works as expected...Thanks   ... View more

SAS do loop sgplot

by Pyrite | Level 9 in SAS Programming
‎01-26-2018 07:23 AM
‎01-26-2018 07:23 AM
Hi, I need to output a separat PDF plot file for each unit which aooear in my data set.   How can I make this simple and smart?????   The code below works but i need to loop it over the different units in the dataset so I output one plot per unit.   The dataset plot1 contains data for several units.   Hope you have some ideas.   Thanks in advance,     SAS program:   * data selection; data plot1; set masterdata(where=(year notin('2018') and unitname in(&unit.) )) other_sum; run;   *make PDF file;   ods pdf file="C:/SGPLOT/&unit..pdf" notoc; PROC SGPLOT DATA = plot1;     SERIES X = Reg_aar Y = var1/lineattrs=(color=green) ; SERIES X = Reg_aar Y = var2 /lineattrs=(color=red) ; SERIES X = Reg_aar Y =var3/lineattrs=(color=green pattern=dash) ; SERIES X = Reg_aar Y =var4/lineattrs=(color=red pattern=dash); yaxis values=(0 to 100 by 20);   TITLE 'Plot for &unit'; RUN; ods pdf close;   ... View more

Re: get file from FTPS site

by Pyrite | Level 9 in SAS Programming
‎12-07-2017 07:49 AM
‎12-07-2017 07:49 AM
The FTP site is FTPS and not SFTP. Is there a way from sas to get files transferred? It seems to time out. ... View more

Re: get file from FTPS site

by Pyrite | Level 9 in SAS Programming
‎12-06-2017 03:23 PM
‎12-06-2017 03:23 PM
I get the following message now:   NOTE: 500 OOPS: error:00000000:lib(0):func(0):reason(0) NOTE: <<< 500 OOPS: error:00000000:lib(0):func(0):reason(0) NOTE: >>> AUTH TLS NOTE: <<< 500 OOPS: priv_sock_get_cmd WARNING: Validate the FTP server accepts TLS authentication before using the AUTHTLS option. ERROR: Invalid Reply received for the AUTH TLS command. NOTE: The file TAR_FILE is: .....   ... View more

get file from FTPS site

by Pyrite | Level 9 in SAS Programming
‎12-06-2017 03:21 PM
‎12-06-2017 03:21 PM
Hi ,   I try to get a file from a FTPS site. Until now no luck.  I can connect to the server from the sas serves filezilla. we run sas 9.04.01M3P062415.   When I run the below code from SAS EG/SAS DI the ftps server seems to time out   options set=SAS_FTP_AUTHTLS="1";   filename Src_file ftp 'test.txt' user='myuser' pass='xxxxxx' host='ftps.FFF.XX' PORT=990 debug   ; 　 　 　 filename Tar_file "C:\test.txt";   data _NULL_; INFILE Src_file; INPUT; File Tar_file ; PUT _INFILE_ ; run;   Thanks in advance. ... View more

Re: read paradox database files

by Pyrite | Level 9 in SAS Programming
‎11-13-2017 01:31 PM
‎11-13-2017 01:31 PM
it says also that ERROR: The variable name is illegal for file WORK.MYDATA.DATA ... View more

Re: read paradox database files

by Pyrite | Level 9 in SAS Programming
‎11-13-2017 01:17 PM
‎11-13-2017 01:17 PM
as far i can see with a exported data that the labels/variable has comma , and .  - can i suppress that? ... View more

Re: read paradox database files

by Pyrite | Level 9 in SAS Programming
‎11-13-2017 01:14 PM
‎11-13-2017 01:14 PM
I tried both DBMS setting - none of them is working. I will try to export the data and see what the names is. ... View more

Re: read paradox database files

by Pyrite | Level 9 in SAS Programming
‎11-11-2017 02:46 AM
‎11-11-2017 02:46 AM
How can i see the version - the files are arranged with 5 types: *.DB *.MB *.PX *.XGO *.YGO   I found this text in some of the ?license file.   when i edit the files it looks like this:                 ¬3äk          ÿ ÿN   fm @@äk2@äk                     ò          Mé9W ƒ  ä‘       `@äkeAäkiAäkrAäkyAäkAäk‡AäkAäkresttemp.DB                                                                                                                                                                            Any clues what it is and can it be written into SAS?       ... View more

Re: read paradox database files

by Pyrite | Level 9 in SAS Programming
‎11-11-2017 02:37 AM
‎11-11-2017 02:37 AM
is stills fails with the options -but give maybe more information about the variables:   13 14 * denne importerer paradox filer; 15 options validvarname=v7; 16 PROC IMPORT OUT= WORK.MYDATA 17 DATAFILE= "C:\YYYY\TTTT\MYDATA.DB" 18 DBMS=PARADOX REPLACE; NOTE: Variable Name Change... -> _1 NOTE: Variable Name Change. ë‹Ë·Ó¸ÿ -> VAR3 NOTE: Variable Name Change... -> _2 NOTE: Variable Name Change. » -> __ NOTE: Variable Name Change... -> _3 NOTE: Variable Name Change... -> _4 NOTE: Variable Name Change. ¿ -> _ NOTE: Variable Name Change... -> _5 NOTE: Variable Name Change... -> _6 NOTE: Variable Name Change. €ë·Ó·Ã‹û‹Ë» -> VAR11 NOTE: Variable Name Change... -> _7 NOTE: Variable Name Change... -> _8 NOTE: Variable Name Change. L‹E§f E"fA‰@‹ÃfA‰A‰HA‰xH‹MÿH -> VAR14 NOTE: Variable Name Change... -> _9 NOTE: Variable Name Change... -> _10 NOTE: Variable Name Change. HÄ  -> VAR17 NOTE: Variable Name Change... -> _11 NOTE: Variable Name Change... -> _12 NOTE: Variable Name Change. A_A^A]A\_^]ÃÌÌH‰\$UVWATAUAVAWH -> VAR20 NOTE: Variable Name Change... -> _13 NOTE: Variable Name Change... -> _14 NOTE: Variable Name Change. H‹Ùp -> VAR23 NOTE: Variable Name Change... -> _15 NOTE: Variable Name Change... -> _16 NOTE: Variable Name Change. ‰U³º -> VAR26 NOTE: Variable Name Change... € -> __1 NOTE: Variable Name Change... -> _17 NOTE: Variable Name Change. E3íf#ÊDzÿD‰EÇfA#ÿH‰]¿ÇE÷ÌÌÌÌÇEû -> VAR29 NOTE: Variable Name Change... -> _18 NOTE: Variable Name Change. E…Ò…. -> VAR31 NOTE: Variable Name Change... -> _19 NOTE: Variable Name Change. f;ÊADÀfÇC0fD‰+ˆCDˆké’ -> VAR33 NOTE: Variable Name Change... -> _20 NOTE: Variable Name Change. fA;ÿ… -> VAR35 NOTE: Variable Name Change... ¾ -> __2 NOTE: Variable Name Change... -> _21 NOTE: Variable Name Change... -> _22 NOTE: Variable Name Change. €fD‰D;ÎuE…Òt9Aºá-r2HKLsG -> VAR39 NOTE: Variable Name Change... -> _23 NOTE: Variable Name Change... º -> ___1 NOTE: Variable Name Change... -> _24 NOTE: Variable Name Change... -> _25 NOTE: Variable Name Change. èÔÿÿ…À„¯ -> VAR44 NOTE: Variable Name Change... -> _26 NOTE: Variable Name Change... -> _27 NOTE: Variable Name Change. E3ÉE3À3Ò3ÉL‰l$ èÎÿÿÌf…Ét;Aù -> VAR47 NOTE: Variable Name Change... -> _28 NOTE: Variable Name Change... -> _29 NOTE: Variable Name Change. Àu2E…ÒunHKL&G -> VAR50 NOTE: Variable Name Change... -> _30 NOTE: Variable Name Change. ARèÕÓÿÿ…Àt7E3ÉE3À3Ò3ÉL‰l$ èMÎÿ -> VAR52 NOTE: Variable Name Change... -> _31 NOTE: Variable Name Change. ARèžÓÿÿ…Àu¸ -> VAR54 NOTE: Variable Name Change... -> _32 NOTE: Variable Name Change... ¿1 -> _1_1 NOTE: Variable Name Change... ¿2 -> _2_1 NOTE: Variable Name Change... ¿3 -> _3_1 NOTE: Variable Name Change... ¿4 -> _4_1 NOTE: Variable Name Change... ¿5 -> _5_1 NOTE: Variable Name Change... ¿6 -> _6_1 NOTE: Variable Name Change... 1 -> _1_2 NOTE: Variable Name Change... 1 -> _1_3 NOTE: Variable Name Change... ¾1 -> _1_4 NOTE: Variable Name Change... ¾2 -> _2_2 NOTE: Variable Name Change... ¾3 -> _3_2 NOTE: Variable Name Change... ¾4 -> _4_2 ERROR: The variable name is illegal for file WORK.MYDATA.DATA. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.14 seconds user cpu time 0.07 seconds system cpu time 0.06 seconds memory 647.90k OS Memory 12008.00k Timestamp 11/11/2017 08.32.32 f.m. Step Count 6 Switch Count 0 ... View more

Re: SAS visual analytics autoload data in subfolders

by Pyrite | Level 9 in SAS Visual Analytics
‎11-10-2017 09:26 AM
1 Like
‎11-10-2017 09:26 AM
1 Like
Thanks for the tip. This is a great solution. ... View more

read paradox database files

by Pyrite | Level 9 in SAS Programming
‎11-10-2017 09:24 AM
‎11-10-2017 09:24 AM
Hi, I need to access data which is in paradox format. I use the proc import (have tried by libname) but I get errors and no data.   Do you have any ideas how to access the data ? or is it not possible (we run sas on windows, 9.4)    Thanks in advance.     142  PROC IMPORT OUT= WORK.MYDATA 143              DATAFILE= "C:\YYYY\FFFF\MYDATA.DB" 144              DBMS=PARADOX REPLACE; NOTE:    Variable Name Change...   -> _1 NOTE:    Variable Name Change...   -> _2 NOTE:    Variable Name Change...   -> _3 NOTE:    Variable Name Change...   -> _4 NOTE:    Variable Name Change...   -> _5 NOTE:    Variable Name Change...   -> _6 NOTE:    Variable Name Change...   -> _7 NOTE:    Variable Name Change...   -> _8 NOTE:    Variable Name Change...   -> _9 NOTE:    Variable Name Change...   -> _10 NOTE:    Variable Name Change...   -> _11 NOTE:    Variable Name Change...   -> _12 NOTE:    Variable Name Change...   -> _13 NOTE:    Variable Name Change...   -> _14 NOTE:    Variable Name Change...   -> _15 NOTE:    Variable Name Change...   -> _16 NOTE:    Variable Name Change...   -> _17 NOTE:    Variable Name Change...   -> _18 NOTE:    Variable Name Change...   -> _19 NOTE:    Variable Name Change...   -> _20 NOTE:    Variable Name Change...   -> _21 NOTE:    Variable Name Change...   -> _22 NOTE:    Variable Name Change...   -> _23 NOTE:    Variable Name Change...   -> _24 NOTE:    Variable Name Change...   -> _25 NOTE:    Variable Name Change...   -> _26 NOTE:    Variable Name Change...   -> _27 NOTE:    Variable Name Change...   -> _28 NOTE:    Variable Name Change...   -> _29 NOTE:    Variable Name Change...   -> _30 NOTE:    Variable Name Change...   -> _31 NOTE:    Variable Name Change...   -> _32 NOTE:    Variable Name Change...   -> _33 NOTE:    Variable Name Change...   -> _34 NOTE:    Variable Name Change...   -> _35 NOTE:    Variable Name Change...   -> _36 NOTE:    Variable Name Change...   -> _37 NOTE:    Variable Name Change...   -> _38 NOTE:    Variable Name Change...   -> _39 NOTE:    Variable Name Change...   -> _40 NOTE:    Variable Name Change...   -> _41 NOTE:    Variable Name Change...   -> _42 NOTE:    Variable Name Change...   -> _43 NOTE:    Variable Name Change...   -> _44 NOTE:    Variable Name Change...   -> _45 NOTE:    Variable Name Change...   -> _46 NOTE:    Variable Name Change...   -> _47 NOTE:    Variable Name Change...   -> _48 NOTE:    Variable Name Change...   -> _49 NOTE:    Variable Name Change...   -> _50 NOTE:    Variable Name Change...   -> _51 NOTE:    Variable Name Change...   -> _52 NOTE:    Variable Name Change...   -> _53 NOTE:    Variable Name Change...   -> _54 NOTE:    Variable Name Change...  1 -> _1_1 NOTE:    Variable Name Change...  2 -> _2_1 NOTE:    Variable Name Change...  3 -> _3_1 NOTE:    Variable Name Change...  4 -> _4_1 NOTE:    Variable Name Change...  5 -> _5_1 NOTE:    Variable Name Change...  6 -> _6_1 NOTE:    Variable Name Change...  1 -> _1_2 NOTE:    Variable Name Change...  1 -> _1_3 NOTE:    Variable Name Change...  1 -> _1_4 NOTE:    Variable Name Change...  2 -> _2_2 NOTE:    Variable Name Change...  3 -> _3_2 NOTE:    Variable Name Change...  4 -> _4_2 ERROR: The variable name  is illegal for file WORK.MYDATA.DATA. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time):       real time           0.10 seconds       user cpu time       0.06 seconds       system cpu time     0.03 seconds       memory              646.03k       OS Memory           18672.00k       Timestamp           10/11/2017 12.27.26 e.m.       Step Count                        24  Switch Count  0   145 146  RUN; ... View more

SAS visual analytics autoload data in subfolders

by Pyrite | Level 9 in SAS Visual Analytics
‎11-09-2017 02:08 PM
1 Like
‎11-09-2017 02:08 PM
1 Like
Hi, We are running sas VA 7.3 on windows. I am a new administrator on it.   We got a lot of data from different areas which we now loads to a single folder (autoload) on VA.   Is it possible or what is best practice to put data in more folders which could load into memory (as subfolders) e.g. users need to drill down in the subfolders to access data? do I need another server context (is that possible in the windows version ??). I could be interesting if I could put security on the folders as well.   Thanks in advance. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-12-2023 06:32 AM
Likes given to
Quick links