topic Re: how to call a format in the datastep in SAS Programming

how to call a format in the datastep

mj5 — Thu, 19 Oct 2017 07:57:02 GMT

DATA temp1;
  input subj 1-4 num_val 6 result $8-20 ;
  DATALINES;
1024 1 manual 
1167 1 manual 
1168 2 testing 
1201 2 testing 
1302 3 plain
1302 4 natural
;

data fmtdata;
  set temp1 (rename=(num_val=start result=label));
  by start;
  retain fmtname 'ncodes' type 'N';
  if first.start;
run;

proc format cntlin = fmtdata;
run;

How to call the format?

I am using format num_val $ncodes.;

But it doesnt work

Re: how to call a format in the datastep

ChrisBrooks — Thu, 19 Oct 2017 08:11:35 GMT

You've created ncodes as a numeric format - it's character formats which have the $ sign at the start so drop that and you should be fine.

Re: how to call a format in the datastep

mj5 — Thu, 19 Oct 2017 08:18:36 GMT

Thanks, Can the length be increased for the format name for fmtname as the formats are getting truncated

Re: how to call a format in the datastep

ChrisBrooks — Thu, 19 Oct 2017 08:20:24 GMT

You shouldn't really need to do that - can you post the data and code you're using to apply the format?

Re: how to call a format in the datastep

Astounding — Thu, 19 Oct 2017 11:59:45 GMT

You can control the number of characters of the formatted value that print. All of these would be legitimate uses of the same format:

format num_val ncodes.;

format num_val ncodes4.;

format num_val ncodes8.;

That's the reason that you can't create a format name ending in a digit ... it gives you the flexibility later to add a width when applying the format.

Re: how to call a format in the datastep

mj5 — Thu, 19 Oct 2017 12:14:46 GMT

can i sort the formatted character value on basis of numeric.

For example format num_val ncodes.; is there anyway i can sort on basis of numeric values?

Re: how to call a format in the datastep

Kurt_Bremser — Thu, 19 Oct 2017 12:54:59 GMT

proc sort will use the raw, unformatted value of a variable. If you want to sort by formatted values, create a new variable that holds those formatted values and sort by that.

Certain SAS procedures can be told to use formatted values in their calculations (ie proc freq).