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

Re: [newbie] Ordering output in the same order as input

by Calcite | Level 5 in SAS Procedures
‎11-14-2013 02:20 PM
‎11-14-2013 02:20 PM
Thanks Lap. You were absolutely right.  I was using the PROC LIST command and was not seeing the label name in the output. I changed it to PROC REPORT, and now I see it. ... View more

Re: [newbie] Ordering output in the same order as input

by Calcite | Level 5 in SAS Procedures
‎11-14-2013 10:53 AM
‎11-14-2013 10:53 AM
That makes sense, but there's definitely only one LABEL statement here. It only "picks up" the LABEL statement if I read in the tst_format.inc file prior to reading in the tst_informat.inc file.  However, if I do that then that puts me back in my original predicament...So by reading in the tst_informat.inc file first, I get to maintain the correct variable order (which is what I wanted), the FORMAT statements in the tst_format.inc file still work (which is what I wanted), BUT the variable names, as they are listed in the tst_informat.inc file, seem to be unaffected by the LABEL commands in the tst_format.inc file (which is Not what I wanted). ... View more

Re: [newbie] Ordering output in the same order as input

by Calcite | Level 5 in SAS Procedures
‎11-14-2013 10:23 AM
‎11-14-2013 10:23 AM
I was mistaken...the FORMAT commands are not being ignored as I previously thought.  I also have LABEL commands in the same tst_format.inc file that I mentioned, and they are being ignored, so I assumed the entire file was being ignored.  However, I verified that it is only the Label command that is not being taken into account. For example: LABEL lst_name      = "LAST NAME"; FORMAT lst_name        $50.; The output from this has 50 characters, however it shows up in the dataset as "lst_name". It would be nice if the LABEL worked as well, but right now having the format and the correct overall ordering of every variable is more important. ... View more

Re: [newbie] Ordering output in the same order as input

by Calcite | Level 5 in SAS Procedures
‎11-14-2013 09:23 AM
‎11-14-2013 09:23 AM
First of all, thank you very much for taking time to reply.  You're assumption was correct in how I am trying to do this.  I took your advice and put the informat before the format and it kept the ordering as you suggested. However, now it appears to be ignoring the format commands in the format file...Any suggestions? This is what it currently looks like: data test (compress=binary);    infile tst_inp linesize=3000;    input              %include "!SASPROG/tst_fields.inc";     ;    %include "!SASPROG/tst_format.inc";    run; ... View more

[newbie] Ordering output in the same order as input

by Calcite | Level 5 in SAS Procedures
‎11-13-2013 04:58 PM
‎11-13-2013 04:58 PM
I have an informat file and an output format file.  The informat file contains the names/data types of all of the variables being read in from an input text file.  The format file contains just the variable names/formats that require special formatting or need to be renamed, etc..... So what is happening is that the actual dataset that gets outputted is first following the order of the variables listed in the format file, and then picks up with the remaining variables in the informat file.  However, I want the output dataset to maintain the exact order of the informat file. Is there a way to use the format file strictly for formatting, but to ignore the order that is present in that file, and just keep the original ordering? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links