How to edit table value in Sas

strik11 — Sat, 13 Aug 2016 08:03:55 GMT

i want to change values of hlthfood variable and set all 0 to no

Re: How to edit table value in Sas

LinusH — Sat, 13 Aug 2016 12:29:14 GMT

Please, take the free online programming course.

Re: How to edit table value in Sas

Cynthia_sas — Sat, 13 Aug 2016 14:34:19 GMT

Hi:
I would recommend a user-defined format because you cannot suddenly turn a numeric variable into a character variable. But you can use a format to have the number 0 be displayed as No on any report output.

As Linus suggests, taking Programming 1 would help you with this task. In Programming 1, which is free, as self-paced e-learning, user-defined formats are covered in Lesson 5, entitled "Formatting Data Values" and in that lesson, there is a demo that covers "Specifying a User-Defined Format for a Numeric Variable".

cynthia
ps you can activate the free Programming 1 class by setting up a SAS Profile and clicking Start Now on this page next to Programming 1: https://support.sas.com/edu/elearning.html?ctry=us&productType=library

cynthia

topic Re: How to edit table value in Sas in SAS Programming

How to edit table value in Sas

Re: How to edit table value in Sas

Re: How to edit table value in Sas