BookmarkSubscribeRSS Feed
Filipvdr
Pyrite | Level 9

this is my code:

data csv_file_sas;

format datum ddmmyy10. tarief 4.2;

infile csv_file dlm=';' dsd missover lrecl=10000 firstobs=2;

input Etablissement Werkplaats $ Tarief_Cod $ Tarief_Label $  Det_Cod Naam $ Voornaam $ Datum ddmmyy10. Statuut $ Imputatie Kostenplaats Tarief 6 Eenheid Uren Stukken Totaal;

run;

my problem is, that for numbers with decimals like "Tarief", i don't get a number then.

In csv: Tarief

           1

           1,2

In my dataset, the number for 1,2 is blank. Any help?

1 REPLY 1
data_null__
Jade | Level 19

I think you need commaXw.d INFORMAT.

The COMMAXw.d informat operates like the COMMAw.d informat, but it reverses the roles of the decimal point and the comma. This convention is common in European countries.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2341 views
  • 0 likes
  • 2 in conversation