topic Re: Proc Format in SAS Procedures

Proc Format

SamuelRajKandru — Fri, 16 Sep 2016 18:07:53 GMT

How do you create a (proc) format for a variable having mixed values (character and numeric) like ME2 and SE2 ? Is it possible? Or is there any other way?

Re: Proc Format

Reeza — Fri, 16 Sep 2016 18:25:11 GMT

Numbers are characters.

Are ME2/SE2 variables or values your having issues with? Please explain in detail.

Re: Proc Format

Tom — Fri, 16 Sep 2016 18:32:27 GMT

Perhaps your question is about how to NAME your format?

FORMAT names cannot end in a digit as that would be too confusing because a format reference specifies the length in the using the trailing digits. DATE9. for example. So a format reference of ME2. means to use the format named ME and display using 2 character positions.

Note that the name you use for your FORMAT has nothing to do with the name of the VARIABLE. It desribes the FORMAT itself.

So if you have variables named ME1 and ME2 and they both use the same sets of possible values then you could create a single format named ME or MEF and use it for both variables. If they use different sets of possible vlaues then could create formats named ME1F and ME2F.

Re: Proc Format

SamuelRajKandru — Fri, 16 Sep 2016 18:34:33 GMT

JobCode is the variable. 'ME2' and 'SE2' are the values of the variable JobCode.

Re: Proc Format

Tom — Fri, 16 Sep 2016 18:37:52 GMT

If you variable JOBCODE has values like 'ME2' then you have a character variable. You will need to use a character format.

proc format;
  value $jobcode
   'ME2'='Must Enter Twice'
  ;
run;
....
format jobcode $jobcode. ;
....

Re: Proc Format

SamuelRajKandru — Fri, 16 Sep 2016 18:49:37 GMT

proc format;
value $Jobf
'TA2'='MANAGER'
'ME2'='ASSISTANT'
'ME1'='TECHNICAL WRITER'
'FA3'='SENIOR TECHNICAL WRITER'
'TA3'='ASST MANAGER'
'ME3'='ASSISTANT ASST'
'SCP'='TIME PASS';
RUN;

Is this code correct?

Re: Proc Format

Tom — Fri, 16 Sep 2016 19:31:47 GMT

That should work.

Re: Proc Format

Reeza — Fri, 16 Sep 2016 19:47:06 GMT

Close, but probably not the way you want. YOU should always test your code.

To test a format, test all values AND some values that aren't in your list.

proc format;
value $Jobf
'TA2'='MANAGER'
'ME2'='ASSISTANT'
'ME1'='TECHNICAL WRITER'
'FA3'='SENIOR TECHNICAL WRITER'
'TA3'='ASST MANAGER'
'ME3'='ASSISTANT ASST'
'SCP'='TIME PASS';
RUN;

data test;
input orig $5.;
want=put("TA2", $jobf.);
cards;
TA2
ME2
ME1
FA3
TA3
ME3
SCP
XXX
YYY
AAA
TB24
TA24
ME23
;
run;

proc print data=test;run;

Re: Proc Format

SamuelRajKandru — Sat, 17 Sep 2016 05:00:40 GMT

Reeza, can I copy paste this code and run it? or do I need to edit anything?

Re: Proc Format

Reeza — Sat, 17 Sep 2016 05:31:30 GMT

Try it...

Re: Proc Format

SamuelRajKandru — Sat, 17 Sep 2016 06:35:02 GMT

Re: Proc Format

SamuelRajKandru — Sat, 17 Sep 2016 06:37:47 GMT

Below is the screenshot of the output. I think something's wrong?

Re: Proc Format

Reeza — Sat, 17 Sep 2016 07:09:47 GMT

@SamuelRajKandru wrote:
Below is the screenshot of the output. I think something's wrong?

Yes, that was the point of this little exercise, though not as bad as your output.

Check the log to make sure no errors occurred.

Re: Proc Format

SamuelRajKandru — Sat, 17 Sep 2016 07:14:10 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 data test;

57 input orig $5.;

58 want=put("TA2", $jobf.);

59 cards;

NOTE: The data set WORK.TEST has 13 observations and 2 variables.

NOTE: DATA statement used (Total process time):

real time 0.02 seconds

cpu time 0.00 seconds

73 ;

74 run;

76 proc print data=test;run;

NOTE: There were 13 observations read from the data set WORK.TEST.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.07 seconds

cpu time 0.08 seconds

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Proc Format

Reeza — Sat, 17 Sep 2016 07:41:11 GMT

Sorry, typo

Want=put(orig, $jobf.);

Re: Proc Format

SamuelRajKandru — Sat, 17 Sep 2016 07:50:04 GMT

Okay, corrected the code and submitted it. There weren't any errors or warnings in the log.

Re: Proc Format

SamuelRajKandru — Sat, 17 Sep 2016 07:50:09 GMT

Okay, corrected the code and submitted it. There weren't any errors or warnings in the log.

Re: Proc Format

Reeza — Sat, 17 Sep 2016 08:20:08 GMT

So, are the results what you want? If so, your done.

Re: Proc Format

SamuelRajKandru — Sat, 17 Sep 2016 08:29:35 GMT

Yes, I got the results! Thank you, Reeza!