topic Re: Format 8.2 with a infile in SAS Programming

Format 8.2 with a infile

Mathis1 — Fri, 04 Sep 2020 16:24:13 GMT

Hi, I have to add a numeric variable to an existing dataset. I then used this code :

data WANT;
set HAVE;
put INDIC_2009 8.;
format INDIC_2009 comma8.2;
datalines;
38,64
.
.
.
-18,36
0,36
0,36
-88,96
0,12
-88,96
-53,66
0,2
-21,344
2
3
-88,96
-88,96
-18,36
-88,96
0,12
-53,66
0,12
0,12
0,36
0,36
0,36
-107,32
0,6
-106,72
;
run;

But it does not work. I only get "."

Any idea ?

Thank you !

Re: Format 8.2 with a infile

PaigeMiller — Fri, 04 Sep 2020 16:27:38 GMT

Look at the data set HAVE. Is the variable INDIC_2009 character or numeric? Are there errors or warnings in the LOG?

Re: Format 8.2 with a infile

jimbarbour — Fri, 04 Sep 2020 17:00:54 GMT

I added an INFILE and an INPUT statement to your Data step, and it seems to be working. See code, below, and see results, below the code. I also changed the commas to decimal points, but I am based in the US, so a comma may be valid where you are.

data WANT;
	set HAVE;
*	put INDIC_2009 8.;
	format INDIC_2009 comma8.2;
	INFILE	Datalines;
	INPUT	INDIC_2009;

Jim

Results:

Re: Format 8.2 with a infile

Reeza — Fri, 04 Sep 2020 18:14:06 GMT

I think you actually want the Commax informat? Because those comma's look like decimals to me...
https://documentation.sas.com/?docsetId=leforinforref&docsetTarget=n0aggga4tdr094n14ecw1smkhva7.htm&docsetVersion=1.0&locale=en

Change INFILE to INPUT as indicated by @PaigeMiller and you should be good from there.