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: 
DavidJ
‎03-28-2017
  • 32 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS Graph

by Calcite | Level 5 in SAS Programming
‎12-20-2010 10:59 AM
‎12-20-2010 10:59 AM
I'd post this over on the SAS Graph forum. You'd probably get an answer there. ... View more

Re: Macro variable in array declaration.

by Calcite | Level 5 in SAS Programming
‎09-13-2010 11:01 AM
‎09-13-2010 11:01 AM
Excuse me while I call chang on my rotary dial land line 🙂 ... View more

Re: how can i get the external file information

by Calcite | Level 5 in SAS Programming
‎09-10-2010 08:56 AM
‎09-10-2010 08:56 AM
The FILEEXIST function can check for file existence. Read up on that. As for information on the specific file once defined with a FILENAME statement, I am going to defer to Cynthia or Scott. I don't know if there is a SASHELP view that can be queried for external files like there is for LIBNAMEs. You should probably post some code and logs in english as well. I can't understand what is being displayed right now. ... View more

Re: Issues reading tab-delimited file on z/os

by Calcite | Level 5 in SAS Programming
‎08-06-2010 09:00 AM
‎08-06-2010 09:00 AM
I'll look into that, thanks for the quick response, Scott. ... View more

Issues reading tab-delimited file on z/os

by Calcite | Level 5 in SAS Programming
‎08-06-2010 08:42 AM
‎08-06-2010 08:42 AM
I have a tab-delimited file which was created in Excel 2007 under Windows which looks as follows (portion shown, tabs represented by a T) 95008T 68106T 44970T 7001T 95014T 100020T 54412T 2643T The file is uploaded to the mainframe and I have a SAS program which reads in the file as follows: filename census 'CENSUS.DATA' disp=shr; Data Census; infile census dlm='05'X expandtabs missover lrecl=300 input zipcode $5. median_income 8. population 8. pop_density 8.; run; The code runs fine EXCEPT for lines where median_income is 100000 and higher (six digits vs.five). For those lines, SAS then complains there is invalid data for the population field and truncates the median_income field (the value should be 100020) NOTE: Invalid data for population in line 143 14-21. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6-- 143 95014 100020 54412 2643 zipcode=95014 med_Income=10002 population=. pop_density=2643 I have tried not using the expandtabs option and the file does not read in properly at all. ... View more

Re: Changing the Column positions in SAS

by Calcite | Level 5 in SAS Procedures
‎07-16-2010 02:30 PM
‎07-16-2010 02:30 PM
I had some SAS code that was creating html tables of SAS datasets and we wanted the output columns to appear in a certain order. The code was not smart enough to parse PROC CONTENTS output, so we issued a PROC SQL to the SAS dataset in the column order we desired. I could also see wanting the columns in a certain order if using the %DS2CSV macro to create a delimited flat file, which outputs the columns in the order SAS finds them. I agree with Scott for 99.9% of the cases though. ... View more

Re: sas certification

by Calcite | Level 5 in SAS Health and Life Sciences
‎07-08-2010 01:42 PM
‎07-08-2010 01:42 PM
Take the prep classes offered by SAS if possible. And stop asking for the "Question packs" learn the bleeping material! ... View more

Upward Compatibilty with Version 9.2

by Calcite | Level 5 in Graphics Programming
‎09-24-2009 02:13 PM
‎09-24-2009 02:13 PM
Will SAS/Graph code written in 9.1.3 work in 9.2 without any changes (anything new we'd look into). We also have a menu system using SAS/AF which drives the graphs and are concerned about things breaking. Was pretty seamless when we went from 8.2 to 9.1.3. Thanks ... View more

Complex XML and XMLMap

by Calcite | Level 5 in SAS Programming
‎09-24-2009 08:47 AM
‎09-24-2009 08:47 AM
Running SAS 9.2, Phase 2 (TS2M0) Can XMLMap assist with creating a SAS dataset such as the following XML describes: Value etc... Value etc Value etc I don't have a schema file (XSD) yet. - There can be 1 to many Reports in the file - The subrecord section can occur 0 to unbounded When we tried to read a file with one record, we ended up with Header, Info and Subrecord datasets, and many of the fields were set to missing. XML engine, tried several XMLTYPES (did not use XMLMAP). I need the following from the 1 report record: Header, Info and unique subrecord(s), 1 obs. per subrecord, header and info repeating. So if there were 3 subrecords within the one record, I'd have 3 records with the other fields carrying thru. Can this be done within SAS using the mapper, XML or XML92 engines? We are under a tight deadline. Any ideas appreciated. ... View more

Re: PROC COMPARE: Processing output dataset

by Calcite | Level 5 in SAS Procedures
‎10-15-2008 01:42 PM
‎10-15-2008 01:42 PM
15 years of coding SAS and I had never heard of that one. Thanks. ... View more

PROC COMPARE: Processing output dataset

by Calcite | Level 5 in SAS Procedures
‎10-15-2008 11:24 AM
‎10-15-2008 11:24 AM
In the following example: DATA A; KEY = 100; Value1 = 200; Value2 = 400; run; Data B; KEY = 100; Value1 = 200; Value2 = 410; run; proc compare BASE=A COMPARE=B CRITERION=2 NOSUMMARY METHOD=ABSOLUTE NOPRINT OUTNOEQUAL OUT=MYDIFFS; ID KEY; run; The dataset MYDIFFS contains 1 record, as follows (and as expected): _TYPE_ = DIF _OBS_ = 1 KEY = 100 Value1 = E Value2 = 10 However if I try and process the MYDIFFS dataset and attempt to change the E to a 0, SAS will throw an error since Value1/2 are numeric. Is there a simple solution to this? ... View more

Re: Y-Axis positioning

by Calcite | Level 5 in SAS Procedures
‎08-25-2008 08:47 AM
‎08-25-2008 08:47 AM
I like that trick. Maybe I will ask for an additional option as an enhancement on the label portion of the axis statement, something like location=inside to do what I want. Thanks. ... View more

Re: Y-Axis positioning

by Calcite | Level 5 in SAS Procedures
‎08-22-2008 03:41 PM
‎08-22-2008 03:41 PM
Bill - I am trying to get away from a lot of old SAS/Graph code that relies too much on annotation for a lot of things (including tick marks, axis values and so on). Some of the code goes way back (15 years+). Most I can convert with no problems, the y-axis label positioning has me stumped. Thanks ... View more

Re: Y-Axis positioning

by Calcite | Level 5 in SAS Procedures
‎08-22-2008 03:36 PM
‎08-22-2008 03:36 PM
More code supplied (with certain names made generic) proc gplot data=name anno=anno gout=ris.&gseg; plot mutual*n stock*n / vaxis=axis1 haxis=axis2 frame legend=legend1 vref=0 lvref=34 name='name' overlay des=DESC'; format mutual stock comma4.; * I have tried using label= with values w/ no luck; axis1 origin=(&xorg.,&yorg.) value=(h=&htextsize. f=&hwfont1. c=&black.) label=none order=(&low. to &high. by &increm.) major=(h=-0.9 c=&black.) minor=none length=&ylength.; axis2 label=none value=none major=none minor=none length=&xlength. order=(1 to &lastn. by 1) offset=(2.5,2.5)pct; symbol1 c=&rblack. i=join v=none l=&line1. w=&linewide.; symbol2 c=&bblack. i=join v=none l=&line2. w=&linewide.; legend1 across=1 down=2 offset=(-1,-1) mode=share label=none position=(top right inside) value=(font=&hwfont1. justify=l h=&ltextsize. tick=1 'item 1' tick=2 'item 2') ; run; quit; ... View more

Re: Y-Axis positioning

by Calcite | Level 5 in SAS Procedures
‎08-22-2008 02:54 PM
‎08-22-2008 02:54 PM
The current code has the following in a data step: **** y label; xsys='1'; ysys='1'; hsys='3'; x=0; y=100; text=Y-Axis label'; style="&hwfont1"; size=&stdsize*&sizeadj; * Different sizes for different outputs; color="&black."; position='3'; output; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-28-2017 07:57 AM
Quick links