BookmarkSubscribeRSS Feed
cbuon
Calcite | Level 5

Disclaimer: I'm brand new to SAS.  But I've created a new data set named "employee_info" and I cannot figure out how to change the variable type of the salary column to currency.  This is the code I get, which does not specify the individual variables:

Code for Employee_info.PNG

4 REPLIES 4
Reeza
Super User

PROC IMPORT doesn’t allow you to change types, but I don’t thing that’s your issue anyways. 

 

SAS only has two types, numeric and character. Which of those is your variable? There is a currency format that can be applied, which may be what you’re looking to do. 

 


@cbuon wrote:

Disclaimer: I'm brand new to SAS.  But I've created a new data set named "employee_info" and I cannot figure out how to change the variable type of the salary column to currency.  This is the code I get, which does not specify the individual variables:

Code for Employee_info.PNG


 

cbuon
Calcite | Level 5

Thank you for responding! The format type is numeric, how do I apply the currency format?

Reeza
Super User
data sample;
x= 100000;
format x dollar12.;
run;

proc print data=sample;run;

Use a FORMAT statement as above. 

Kurt_Bremser
Super User

When posting code and/or logs, follow the advice here: https://communities.sas.com/t5/help/faqpage/faq-category-id/posting?nobounce

Typing text from pictures is tedious and unnecessary work.

 

To add to @Reeza: assigning a format does not change the type or the contents of a variable (the type can't be changed at all), but it changes the way the contents are displayed. You still need to use the raw value in comparisons, for example.

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 3364 views
  • 0 likes
  • 3 in conversation