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.
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;
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;
When leading zeroes need to be kept, it's usually not a number, but some kind of code. Read as character.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.