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

Re: How to insert leading spaces in a column

by Calcite | Level 5 in SAS Enterprise Guide
‎07-16-2012 07:56 AM
‎07-16-2012 07:56 AM
Cynthia,     This is what I am trying to do.  TY. John data _null_; OPTIONS Missing='';     retain old_degree '   ';     retain old_seq_no '  ';             set Query_for_SORDEGR_II;     file tmp1 mod;     if _n_ = 1 then do;         put '---'         /         'Degree Information: '         ;     end;     If old_seq_no NE seq_no then do;     put     Degree $5.     @10 '---> Major:' Major $30.     @55 '---> School:' School $30.     ;     end;     If  old_seq_no = seq_no then do;     put     '      ' I want to put in leading spaces and by if two majors equal to the degree output above ******     @10 '---> Major:' Major $30.     @55 '---> School:' School $30.     ;     end;    old_degree = Degree;    old_seq_no = seq_no ;   ;     ; ... View more

Re: How to insert leading spaces in a column

by Calcite | Level 5 in SAS Enterprise Guide
‎07-16-2012 07:50 AM
‎07-16-2012 07:50 AM
Doc this is what I am trying to do see below.  Thank you. John This is what I am trying to do data _null_; OPTIONS Missing='';     retain old_degree '   ';     retain old_seq_no '  ';             set Query_for_SORDEGR_II;     file tmp1 mod;     if _n_ = 1 then do;         put '---'         /         'Degree Information: '         ;     end;     If old_seq_no NE seq_no then do;     put     Degree $5.     @10 '---> Major:' Major $30.     @55 '---> School:' School $30.     ;     end;     If  old_seq_no = seq_no then do;     put    '      '    I want to put in leading spaces and by if two majors equal to the degree output above ******     @10 '---> Major:' Major $30.     @55 '---> School:' School $30.     ;     end;    old_degree = Degree;    old_seq_no = seq_no ;   ;     ; ... View more

How to insert leading spaces in a column

by Calcite | Level 5 in SAS Enterprise Guide
‎07-15-2012 03:03 PM
‎07-15-2012 03:03 PM
This is probably a simple question.  Using put how would I created output like this Degree   Major MA        Music              Education PHd        Music              My issue is on I want leading blanks on the third line.  SAS pulls the word education back to the first column.  I have tried @ for column etc and have not been able to get it to work.  Degree and major are fields on the record.  I don't want to repeat MA if the degree is a double major.  Thanks for you help.   J ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links