topic Re: Changing the length of character variable in the base dataset before appending multiple datasets in SAS Programming

Changing the length of character variable in the base dataset before appending multiple datasets.

sfarash — Thu, 09 Mar 2023 21:11:12 GMT

I ran this code:

data dir.ENGBase;

length s2_disability_0_5_other $38;

set dir.E1;

run;

Goal is to change the length of s2_disability_0_5_other from a length of 7 in the set dir.E1 to 38 characters in the set dir.ENGBase.

When I run the code above, the length doesn’t change in the new dataset ENGBase. It still shows as length 7

Can you help me understand what I’m doing wrong?

I have a long list of char variables in E1 whose length I need to increase in the output ENGBase to accommodate a future append of multiple datasets max lengths. I already determined what the max length needs to be in the first dataset so that no truncation happens.

Any suggestions on how to get the lengths to increase in the base dataset?

I tried it with and without the "." after the length number 38. Neither worked.

Re: Changing the length of character variable in the base dataset before appending multiple datasets

Quentin — Thu, 09 Mar 2023 21:18:18 GMT

Your code looks good to me. Double check the log, do you get any errors/warnings/bad notes?

I ran a modified version of your code and it worked fine:

data E1 ;
  length s2_disability_0_5_other $7;
  s2_disability_0_5_other="Q" ;
run ;

data ENGBase;
  length s2_disability_0_5_other $38;
  set E1;
run;

proc contents data=E1 ;
run ;

proc contents data=ENGBase ;
run ;

Re: Changing the length of character variable in the base dataset before appending multiple datasets

ballardw — Thu, 09 Mar 2023 21:19:11 GMT

Did the log show anything entertaining? It might help to show us the Log from when you ran the code.

Is the variable s2_disability_0_5_other in column 1? (you can check with contents or opening the data set) If not, then you are likely dealing with a failure to replace an existing data set for some reason, or something else overwriting the set.

Re: Changing the length of character variable in the base dataset before appending multiple datasets

Kurt_Bremser — Thu, 09 Mar 2023 21:32:07 GMT

Do not confuse the storage LENGTH of a variable with the width of a FORMAT assigned to it. If the variable also has a format of $7. assigned to it, you won't see more than 7 characters.

Re: Changing the length of character variable in the base dataset before appending multiple datasets

PaigeMiller — Thu, 09 Mar 2023 21:41:08 GMT

Please show us PROC CONTENTS output for variable s2_disability_0_5_other in data set dir.ENGBase. And as requested by others, also show us the full log for this DATA step.