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: 
MichaelJustesen
‎10-30-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Forcing character length to be equal for characters, numbers, spac...

by Calcite | Level 5 in SAS Procedures
‎10-14-2015 06:39 AM
‎10-14-2015 06:39 AM
Thank you for the suggestion!   I need to deliver the file in .csv format however.   Also, there cannot be spaces between the variables which the solution you suggested includes (this is why I change spaces into & characters before concating, then use the cat function for concating the variables, and then change the & characters back into spaces - this only leaves spaces where there are blank/missing characters from the values) - I can manage this by changing the starting position of the variables however so this is not a problem.   Can I use a combination of the put sentence you suggested with an export to csv? ... View more

Forcing character length to be equal for characters, numbers, spaces a...

by Calcite | Level 5 in SAS Procedures
‎10-14-2015 06:00 AM
‎10-14-2015 06:00 AM
  I have a table with multiple data rows for multiple variables. My issue is that some of the variables in some of the data rows are missing, and when I concate all the variables to one field, SAS assigns a different length to the missing values than to other values.   I need my export to have the same exact placement of each variable (whether or not it is blank or not) but I cannot achieve this as the data rows with missing values take up less space than the other data rows.   I have attached 2 pictures of what my output looks like, and what it should look like.   My code is:   /*LENGTH FORMATTING*/ DATA total_formated; set CVR_no_incl; Country1 = put(country,2.); Rcd_type1 = put(Rcd_type, 1.); char_dealer1 = put(left(char_dealer), 10.); char_Inv_nbr1 = put(left(char_Inv_nbr), 7.); char_Doc_type1 = put(right(char_Doc_type), 3.); char_Doc_date1 = put(right(char_Doc_date), 8.); char_Outstanding_amount1 = put(right(char_Outstanding_amount), 13.); char_Credit_limit1 = put(right(char_Credit_limit), 13.); run;   /*REPLACES BLANKS WITHIN VARIABLES WITH & FOR CONCATE WITHOUT SPACES*/ Data And_instead_of_blank; set total_formated; Country1 = tranwrd(Country1, ' ', '&'); Rcd_type1 = tranwrd(Rcd_type1, ' ', '&'); char_dealer1 = tranwrd(char_dealer1, ' ', '&'); char_Inv_nbr1 = tranwrd(char_Inv_nbr1, ' ', '&'); char_Doc_type1 = tranwrd(char_Doc_type1, ' ', '&'); char_Doc_date1 = tranwrd(char_Doc_date1, ' ', '&'); char_Outstanding_amount1 = tranwrd(char_Outstanding_amount1, ' ', '&'); char_Credit_limit1 = tranwrd(char_Credit_limit1, ' ', '&'); run;   Data Ready_for_concate; set And_instead_of_blank; length Country1 $2 Rcd_type1 $1 char_dealer1 $10 char_Inv_nbr1 $7 char_Doc_type1 $3 char_Doc_date1 $8 char_Outstanding_amount1 $13 char_Credit_limit1 $13; run;   /*CONCATENATES TO A SINGLE STRING*/ PROC SQL; create table Concatenated as select cat(Country1, Rcd_type1, char_dealer1, char_Inv_nbr1, char_Doc_type1, char_Doc_date1, char_Outstanding_amount1, char_Credit_limit1) as Concatenated from Ready_for_concate; quit;   /*REPLACES & WITH BLANKS IN CONCATENATED STRING WITHOUT SPACES/DELIMITERS*/ Data Ready_for_export; set Concatenated; Concatenated = tranwrd(Concatenated, '&', ' '); run;   Can anyone help me?   Thank you!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-30-2015 04:13 AM
Quick links