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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.