Dear All:
I have two variables and I want to change the format and informat of these variable
VarA has
Format BEST12. INFORMAT BEST32.
I want to change it to BEST12. and BEST12.
Var_B has $13. as the format and $13. as the INFORMAT
I want to change it to
$12. as the format and $12. as the Informat
Can someone please help
Randy
Once the variables are in a SAS data set, further changing of the informat is useless, it has no impact. So don't do that.
To change the format of a variable from $13. to $12. (why?)
proc datasets library=WORK; /* Or whatever the proper library name is */
modify have; /* Or whatever the proper data set name is */
format var_b $12.;
run;
quit;
You can also change the format in procedures where this variable is used. The only real impact of changing format from $13. to $12. is to chop off the last character, is that really what you want?
You can use PROC DATASETS to make your changes, for example:
data one;
x=100;
format x percent.;
run;
proc datasets lib=work nolist;
modify one;
format x best3.;
quit;
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.