Hi all,
I am trying to use a special SAS code. In order to use it I have to have a data set with 2 variables ID and PCODE. ID is $12 and PCODE is a $6. I am importing this data set from a csv file using proc import. The csv file looks like this:
pcode
id
T0B3M2
724806
T0L0K0
2241906
T0K2S0
2559858
T1M0B1
3115006
T6L4S4
4527226
T5R1E9
6093226
T2A6K3
6927026
T8V7G7
7186848
T7S1N9
8380906
T0L1R0
9075136
T0E2M0
9232706
T0H3C0
10004336
T5X1G5
10106718
T8L5G3
10682226
T8A1R5
13721906
T3E7C4
15817336
However, I am unable to make the main SAS code that is supposed to use this data set as input to work. Someone has suggested that I should make the ID values left-justified. Aren't all the character values in SAS automatically left-justified? If not how can I left-justify them? I have attached the data set that I have made from the csv file here. BTW, I am using SAS 9.4.
Many thanks,
... View more