topic Re: read a numerical value "111" in a format as "0111" in SAS Programming

read a numerical value "111" in a format as "0111"

Alexxxxxxx — Tue, 25 Feb 2020 00:09:10 GMT

Dear all,

I want to read a numerical value (i.g., SIC) "111" in a format as "0111" by the following code.

DATA SIC_code_list;
	infile "G:\PATSTAT_control_variable\CSV\SIC_Code_List.csv"
	DLM = ";"
	DSD
	missover
	lrecl=32767
	firstobs = 2;
	input
	SIC : 4.
	Description :$1000.
	;
	format
	SIC 4.
	;
run;

however, I only get 111, is there any method to change the format and shown as 0111?

thanks in advance.

Re: read a numerical value "111" in a format as "0111"

novinosrin — Tue, 25 Feb 2020 00:53:46 GMT

Use Z format

format	SIC z4.;


DATA SIC_code_list;
	infile "G:\PATSTAT_control_variable\CSV\SIC_Code_List.csv"
	DLM = ";"
	DSD
	missover
	lrecl=32767
	firstobs = 2;
	input
	SIC : 4.
	Description :$1000.
	;
	format	SIC Z4.	;/*Notice here*/
run;

Re: read a numerical value "111" in a format as "0111"

Kurt_Bremser — Tue, 25 Feb 2020 06:43:38 GMT

When leading zeroes need to be kept, it's usually not a number, but some kind of code. Read as character.