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: 
DanieleTiles
‎09-01-2015
  • 58 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Descending values of the vertical axis and position

by Calcite | Level 5 in Graphics Programming
‎10-05-2009 12:02 PM
‎10-05-2009 12:02 PM
Dear Cynthia, I've tried the descending option, but I believe it works with the sumvar variable, and not the hbar one (in fact, I get some weird ordered diagram, but which is ordered by the sum of the positive values and negative values of the sumvar variable)...I'm pretty sure of the format I'm using, since it's quite simple... Thanks Daniele ... View more

Descending values of the vertical axis and position

by Calcite | Level 5 in Graphics Programming
‎10-05-2009 08:52 AM
‎10-05-2009 08:52 AM
Hi to all, I've got the 2 following questions: 1) I've to plot a gchart, where the hbar variable is numeric, and I've applied a format to show it. However, I need to put the values in descending order, but I couldn't find any way to do it (I cannot specify all the values, because the format does regroup the values)...any idea? 2) I've been asked to put the vertical legend in the center of the graph, where the value is 0...I should use the annotate, but how? Thanks Daniele ... View more

Re: proc format picture question

by Calcite | Level 5 in SAS Procedures
‎10-05-2009 06:22 AM
‎10-05-2009 06:22 AM
Dear Patrick, THANKS!! I couldn't find that options, and now I'm happy!! 😄 Best regards! Daniele ... View more

Re: proc format picture question

by Calcite | Level 5 in SAS Procedures
‎10-02-2009 10:56 AM
‎10-02-2009 10:56 AM
Hi Patrick, I've tried with the options Locale, but I didn't see any change in the picture format...with normal formats I've no problem in replacing dot with comma. Only with the picture one... ... View more

Re: proc format picture question

by Calcite | Level 5 in SAS Procedures
‎10-01-2009 03:34 AM
‎10-01-2009 03:34 AM
Hi there, actually, I had tried to change from comma to dot before writing (otherwise I wouldn't have written! 🙂 ) Thanks for the link, I'll take a look and hopefully solve this problem. Best regards Daniele ... View more

proc format picture question

by Calcite | Level 5 in SAS Procedures
‎09-30-2009 12:50 PM
‎09-30-2009 12:50 PM
Hi to all, I've got a simple picture format: proc format; picture posval low-high='000,009'; run; However, I've got this problem: I'd like to represent the number as it would appear with a commax value (so it'd be shown like 200.000 and not as 200,000...in Italy we use a different format :)) I didn't find any hint on how to do it... Thanks Daniele ... View more

Re: Access to a Web Service

by Calcite | Level 5 in SAS Programming
‎06-27-2009 01:05 PM
‎06-27-2009 01:05 PM
Hi to all, thank you for your kind answers :). Actually, the first problem is that I'm still working with SAS 9.1.3...so, I believe that PROC SOAP isn't an available option at the moment. Any idea or guide that I might follow? Thanks Daniele ... View more

Access to a Web Service

by Calcite | Level 5 in SAS Programming
‎06-25-2009 12:08 PM
‎06-25-2009 12:08 PM
Hi to all, I might need to build a SAS application which has to access to a lot of data from some kind of Web Services... Where can I find any useful information on how to access a Web Service through SAS code? Thanks Daniele ... View more

Re: Check numeric values in alphanumeric variables

by Calcite | Level 5 in SAS Procedures
‎04-15-2009 01:55 PM
‎04-15-2009 01:55 PM
Hi Daniel, thanks for the suggestion! However, I've tested the method that seemed to fit best my issues (NOTDIGIT)...but I've found two remarks (one solved, the other one...): -- NOTDIGIT has to consider also blanks, so it has to be called always as NOTDIGIT(TRIM(LEFT(<<STRING>>)))...but that's ok -- The NOTDIGIT might be useful for recognizing integers, but not float/double (for example, if I have to check that a SALES field has got not numeric values....the dot isn't (rightly) recognized as digit). ... View more

Check numeric values in alphanumeric variables

by Calcite | Level 5 in SAS Procedures
‎04-15-2009 12:02 PM
‎04-15-2009 12:02 PM
Hi to all, in T-SQL there is a simple function (called isnumeric()) which checks if the value inside a column is numeric or not. I couldn't find anything similar in SAS functions (to be used in datasteps/proc sql)...the first (and at the moment, working) solution I've found is to check with the value returned from an input: proc sql; select * from work.test a where input(a.charValue,best.) = .; quit; I wanted to know...is there a better way? Is the method I've adopted correct? Thanks Daniele Message was edited by: Daniele Tiles ... View more

Re: SAS Stored Process Web Application and a "dummy" login

by Calcite | Level 5 in Developers
‎02-20-2009 01:12 PM
‎02-20-2009 01:12 PM
Hi Cynthia, as a dummy login I thought of a local user (inserted into the sas users group), with only the right to read and execute the SAS Stored Process (so that none could ever do any damage with that kind of user). What I've found is that I can pass in the GET request for the SAS Stored Process Web Application the variables _USERNAME and _PASSWORD (pwencoded)...my basic idea is to try to build a simple servlet, which will call the SAS Stored Process url, pass (possibly in the POST instead of the GET) the authentication parameters, and then show the XHTML flow generated by the SAS Stored Process... That should work, IMHO... ... View more

SAS Stored Process Web Application and a "dummy" login

by Calcite | Level 5 in Developers
‎02-19-2009 05:08 AM
‎02-19-2009 05:08 AM
Hi to all, we've successfully deployed a sas stored process and called it through the SAS Stored Process Web Application, which is amazing :). Unfortunately, we've got a problem: this output which is generated should be accessible from all the users who access this public web site of our client...so we'd like to introduce a "dummy" login into the metadata (with only the rights to read and execute this stored process), and find a way to pass his credentials to the SAS Metadata server in a transparent way (i.e., without presenting the user a prompt). Is this feasible? How can we implement it? Thanks! Daniele ... View more

SAS datasets and German/Italian language

by Calcite | Level 5 in SAS Procedures
‎02-02-2009 03:41 AM
‎02-02-2009 03:41 AM
Hi to all, I've got this problem: I'm reading some data from an Oracle DB, where there are some addresses, both in italian and German language. Unfortunately, in the database this are written as is (with not-ASCII characters), and so in SAS they aren't recognized correctly. Is there a way to tell programmatically, when I create a dataset, that a description should be a unicode description? Thanks Daniele ... View more

Re: Save a dataset as a CSV

by Calcite | Level 5 in SAS Procedures
‎01-27-2009 09:58 AM
‎01-27-2009 09:58 AM
Hi Cynthia, yes, it was definitely the listing: with your suggestion I've switched back to proc print (which in MUCH faster than proc sql when printing). Thanks for your tip! Daniele Message was edited by: Daniele Tiles ... View more

Re: Save a dataset as a CSV

by Calcite | Level 5 in SAS Procedures
‎01-26-2009 07:06 AM
‎01-26-2009 07:06 AM
Solved, on a different way. The problem wasn't the ODS csv, but instead a limit of proc print...so I followed this guide: http://www2.sas.com/proceedings/sugi29/042-29.pdf Page 3: "When you have a long character variable (such as a COMMENT field in the questionnaire), and you want to print the values using PROC PRINT, you will get the warning message: WARNING: Data too long for column "COMMENT"; truncated to 124 characters to fit. A simple solution is to use PROC SQL with the flow option." This worked smoothly 🙂 Thanks for your help Daniele ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links