Define your own function, callable from data steps and SQL:   proc fcmp outlib=sasuser.fcmp.math; function degrees(radians); if missing(radians) then return(.); r = mod(radians, 2*constant("PI")); return (r*360/(2*constant("PI"))); endsub; run; options cmplib=sasuser.fcmp; data _null_; do x = -2 to 2 by 0.125; r = x*2*constant("PI"); d = degrees(r); put r= d=; end; run; ... View more

I echo @ballardw solution - use a format. This is a multistage process. First create a table that has all the mappings you need. These would be the reference tables. Then you can create formats from these tables using PROC FORMAT with CNTLIN. Here's a good reference paper on Proc Format. http://www2.sas.com/proceedings/sugi30/001-30.pdf ... View more

Did you create these txt file under UNIX OS and browse them under Win OS ? ... View more

Why do you need to convert a SAS dataset? I think we're having some 'translation' issues. It sounds like you want the user to provide some information and then you either store or run  a report. The term is typically considered prompts. You can search this on lexjansen.com for multiple examples of how to implement a solution. The second possible interpretation is that you need a data entry from where you're collecting information from users on a regular basis that would then fall under using SAS/AF, again you can search lexjansen.com with that term. ... View more

What type of report count, mean, sum or other statistics? Are the variables numeric or character? I'd probably start with proc freq data=have;      tables errors*months; run; ... View more