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

Re: How to calculate Percentile

by Calcite | Level 5 in SAS Procedures
‎04-10-2012 06:54 AM
‎04-10-2012 06:54 AM
Hi The link you supplied is helpful, but I don't know how to replicate Excel's behaviour (whether that's desirable or not is another question...) e.g. data 0 0 1 3 4 7 9 13 18 20 26 29 43 46 49 58 73 78 162 Results Excel calc Result percentile(range,0.25) 5.5 percentile(range,0.5) 20 percentile(range,0.75) 47.5 percentile(range,0.95) 86.4 Does anyone know what settings to apply to ensure SAS replicates Excel's behaviour using this example data? Thanks Matt ... View more

Variable names in DI studio

by Calcite | Level 5 in SAS Data Management
‎09-02-2011 07:33 AM
‎09-02-2011 07:33 AM
Hi I ended up raising a track with SAS as I wasn't getting anywhere - think this is down to my lack of previous SAS coding experience, a more experienced user may have found this problem much more quickly. Turns out there's a bug in the version I'm using (4.21) which incorrectly generates the header rows in the file writer transformation. This is addressed by going into the file writer and amending the section of code which generates the header. From this:    if ( _n_ = 1 ) then          do;             put incorrect ->  ""Org"n,"_101"n,"_102"n";          end; To this:        if ( _n_ = 1 ) then          do;             put correct ->   "Org,_101,_102";          end; And once I've changed this bit of code I'm able to remove the leading underscores and export in my desired format! SAS tell me this bug is fixed in version 4.3. Matt ... View more

Variable names in DI studio

by Calcite | Level 5 in SAS Data Management
‎08-25-2011 05:49 AM
‎08-25-2011 05:49 AM
Hi Thanks for the swift reply - think I'm almost there but can't see what else I need to do. I've updated the properties of my external file to accept special characters, and have amended the mapping in my file writer so that _101 maps to 101 etc. I understand that I need to set the External File Record Start Record to 2 in order for the header row to be written, but when I do this the job fails. When I set it to 1 the job succeeds but the header row is missing, this appears to show that the setting the accept special characters works but I'm missing a step to allow the file itself to be generated with special characters. I've investigated the VALIDVARNAME = ANY option but cannot get this to work. Has anyone found a way of addressing this problem? Thanks Matt ... View more

Variable names in DI studio

by Calcite | Level 5 in SAS Data Management
‎08-24-2011 06:45 AM
‎08-24-2011 06:45 AM
Hi I have a question about variable names in DI studio, but specifically about whether it is possible to output a SAS disallowed variable name to an external file XLS or CSV. I know that SAS does not allow a variable name to start with a number, and that if the result of a transpose is a numeric variable name SAS will prefix with an underscore, so variable 101 becomes _101. So, I generate a table which looks like ORG _101 _102 _103 _104 A 10 15 20 25 B 5 10 15 20 C 20 15 10 5 D 30 25 20 15 I have an existing process which needs data to be presented in CSV format without the underscores ORG 101 102 103 104 A 10 15 20 25 B 5 10 15 20 C 20 15 10 5 D 30 25 20 15 I produce 100's of output tables so would like to programmatically deal with this problem. Is there a method in DI studio which will allow me to label my variables as the variable name minus the underscore in the export process? Or is there some other solution to allow me remove the underscore character on export? Grateful for advise. Thanks Matt ... View more

Re: XML and DI Studio

by Calcite | Level 5 in SAS Data Management
‎06-07-2011 09:37 AM
‎06-07-2011 09:37 AM
Hi Apologies for my recent absence, and thanks to those who've replied. I've had XML mapper installed and have created a map file from my XML. I can view the data in a tabular form in the XML map application and can see that the example code generated in XML mapper follows the format Laurent de Walick describes earlier in this thread. But, as Jo@SAS notes, I want to find the best way to incorporate this into DI studio. I think the way to do it is via a library and created one which references the XML source file. I leave the XML type field blank, and on advanced options > XML Map tab navigate to the XML map I created using XML mapper. This creates OK, but when I try to register the tables I get an error - "No tables were retrieved from your query. Your connection information may be incorrect." When I look at the log I see that the libref was succesfully assigned but then get a partial message "encountered during XMLMap parsing occurred at or near line 16, column 36". Anyone know what I'm doing wrong? any other options on the library, or is there some other way of using the XML map within DI studio? Thanks again. Matt ... View more

Re: XML and DI Studio

by Calcite | Level 5 in SAS Data Management
‎04-20-2011 04:21 AM
‎04-20-2011 04:21 AM
Hi Anyone have any experience using XML and DI studio? Thanks Matt ... View more

Re: Data Validation Transformation not updating

by Calcite | Level 5 in SAS Data Management
‎04-07-2011 03:33 AM
‎04-07-2011 03:33 AM
I've seen this behaviour too. I've been unable to edit an expression in the pop up within the data validation but can if I open the expression builder by clicking on the ellipsis (...) next to the expression. Matt ... View more

Re: XML and DI Studio

by Calcite | Level 5 in SAS Data Management
‎03-28-2011 06:42 AM
‎03-28-2011 06:42 AM
Apologies - should have done this initially. So, my original data has the structure of the example below. - - MHHDR0304 123456789012345 260000001200001 IC MH 0000001 2010-02-08 13:07:00 0 - - 1 XY ABC 1970-01-01 1970-01-01 ABCDEF DEF 2 P 1970-01-01 ABCDEF GHI ABCDEF B 1970 - 10001 01 1970-01-01 092 0 0 0 0 0 0 0 0 - 000 000 000 000 000 000 000 003 000 000 000 000 000 AB99 1XY 000 000 000 000 000 E - 2 XY ABC 1970-01-01 1970-01-01 99AABCD GHI 1 D 1970-01-01 ABCDEF GHI ABCDEF A 2006 - 10002 01 1970-01-01 092 0 0 0 0 0 0 0 0 - 000 000 000 000 000 000 000 003 000 000 000 000 000 AB99 1XY 000 000 000 000 000 E - MHHDR0000 123456789012345 260000001200001 IC MH 0000001 55 I've used an XML library linked to this file and see that I can register the Header, Body and Trailer tables but cannot see the Table_1, _2 and _3 within the Body. I've amended the XML as below to get rid of Header, Body and Trailer and successfully register Table_1, _2 and _3. - - 1 XY ABC 1970-01-01 1970-01-01 ABCDEF DEF 2 P 1970-01-01 ABCDEF GHI ABCDEF B 1970 - 10001 01 1970-01-01 092 0 0 0 0 0 0 0 0 - 000 000 000 000 000 000 000 003 000 000 000 000 000 AB99 1XY 000 000 000 000 000 E - 2 XY ABC 1970-01-01 1970-01-01 99AABCD GHI 1 D 1970-01-01 ABCDEF GHI ABCDEF A 2006 - 10002 01 1970-01-01 092 0 0 0 0 0 0 0 0 - 000 000 000 000 000 000 000 003 000 000 000 000 000 AB99 1XY 000 000 000 000 000 E My question is (and apologies if this is down to my lack of understanding of XML) - can I use a SAS XML library to register Tables_1, _2 and _3 without having to edit the XML? Or, is there some other way of using SAS to achieve this? I'm using SAS DI studio 4.21 on Windows. Thanks again. Matt ... View more

XML and DI Studio

by Calcite | Level 5 in SAS Data Management
‎03-22-2011 10:25 AM
‎03-22-2011 10:25 AM
Hi I've been experimenting with loading and writing to XML files in DI studio . The example I tried had a structure as below Header >Body >>Table1 >>Table2 >>Table3 Trailer I created an XML library that referenced the XML file, and attempted to register the tables. When I first tried I could only see the Header, Body and Trailer as SAS objects; in order to get Table1, 2 and 3 I had to edit the XML file to delete all the information relating to the Header, Body and Trailer. Is there a way to see all objects in an XML file with a hierarchy such as this? Thanks Matt ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links