topic Re: converting dataset to format in SAS Procedures

converting dataset to format

NJGIRL — Wed, 07 Apr 2021 14:01:05 GMT

Hi all,

Not a newbie, just can't find my code that converts a sas dataset into a format via Proc Format.

Anyone have the straightforward code readily available?

Thanks so much!

Re: converting dataset to format

Reeza — Wed, 07 Apr 2021 14:12:51 GMT

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=proc&docsetTarget=n1e19y6lrektafn1kj6nbvhus59w.htm&locale=en

You need to create your start, end, label, fmtname and type variables correctly as per the documentation and then use PROC FORMAT with CNTLIN.
The example in the documentation seems well explained, is there some portion that needs more detail?

Re: converting dataset to format

Kurt_Bremser — Wed, 07 Apr 2021 14:16:59 GMT

data fmt_cntlin;
set have (
  keep=<source> <target>
  rename=(<source>=start <target>=label)
) end=done;
fmtname = "myfmt";
type = "C"; /* N for numeric */
output;
if done
then do;
  hlo = "O";
  /* add code for "other" values */
  output;
end;
run;

proc format cntlin=fmt_cntlin;
run;

Re: converting dataset to format

DrAbhijeetSafai — Sat, 23 Dec 2023 09:18:12 GMT

Thanks a lot! It was very useful. Thanks once again!

Thanking you,

Yours sincerely,

- Dr. Abhijeet Safai