topic Re: recoding data in SAS Studio

recoding data

halladje — Thu, 17 Aug 2017 10:18:34 GMT

Hello,

I am looking for a description of the code to recode variables in sas studio. All the codes I have looked up online do not work.

I am looking to recode my age variable so any age 16 thru 22 is coded as missing or '.'

Thanks in advance,

Re: recoding data

SuzanneDorinski — Thu, 17 Aug 2017 11:49:27 GMT

proc print data=sashelp.class;
run;

data class;
  set sashelp.class;
  if 16 le age le 22 then age=.;
run;

proc print data=class;
run;

Re: recoding data

Reeza — Thu, 17 Aug 2017 14:59:59 GMT

http://video.sas.com/detail/videos/how-to-tutorials/video/4573016759001/performing-conditional-logic-in-sas?autoStart=true

https://stats.idre.ucla.edu/sas/modules/creating-and-recoding-variables-in-sas/

Also, search LexJansen.com for papers on any topic. It appears to be down right now, but it'll have papers and tutorials on any topic you could want, especially at the beginner level.

The first SAS e-course is also free.

Re: recoding data

ballardw — Thu, 17 Aug 2017 15:36:28 GMT

@halladje wrote:

Hello,

I am looking for a description of the code to recode variables in sas studio. All the codes I have looked up online do not work.

I am looking to recode my age variable so any age 16 thru 22 is coded as missing or '.'

Thanks in advance,

I would be very interested in seeing what did not work and the logs associated with the code that did not work.

Re: recoding data

halladje — Thu, 17 Aug 2017 20:40:19 GMT

Thanks so much! This worked!

Re: recoding data

halladje — Thu, 17 Aug 2017 20:40:47 GMT

Thank you! The video was helpful.

Re: recoding data

halladje — Thu, 17 Aug 2017 20:42:01 GMT

I didn't keep any of them because they were not working anyways. I very easily could have been missing a key component - I started using SAS yesterday (I am primarily an SPSS and MlwiN user - converting to SAS).

Re: recoding data

ballardw — Thu, 17 Aug 2017 22:33:33 GMT

If you use frequently Value Labels in SPSS you will need to become familiar with Proc Format. Formats are the equivalent of a value label and for some purposes that suffices (binning or grouping).

When data is read either from an external file or an existing variable an INFORMAT is one way to accomplish bulk recoding without a large number of If/then/else statements.

I do sypathize with having to make that adjusment. I had to go the other way to SPSS after using SAS for about 13 years.