I have a field with the input layout of '$9999.99'. What SAS format will fit this besides character. This field will be summarized in a total with supporting record lines. Really stuck on what format to use.
DOLLAR
@larrytex wrote:
I have a field with the input layout of '$9999.99'. What SAS format will fit this besides character. This field will be summarized in a total with supporting record lines. Really stuck on what format to use.
To read such a field, you need to apply an informat, such as:
input varname dollar8.;
That will give you a numeric variable that you can summarize. If you want to print out the result using dollar signs and commas, apply a format for printing:
format summarized_varname dollar9.;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: