When I run this, the format for field1 should be 12,346,756 but it's 12346756
data test;
infile datalines DLM = ',';
input
field1 : comma10.0
lossyr : 20.
;
DATALINES ;
12346756,2014
;
Correct my previous version of this post.
You are only _using_ an ínformat, but you have not assigned any display format.
Add
format
field1 comma10.0
lossyr 20.
;
data test;
infile datalines DLM = ',';
format field1 COMMA10. lossyr 20.;
input field1 lossyr;
DATALINES ;
12346756,2014
;
run;
Yes, you have read the data in as comma10.0, i.e. the input reads the data in that format, buy you have not applied a format to the variable.
data test;
infile datalines DLM = ',';
input
field1 : comma10.0
lossyr : 20.;
format field1 comma10.0;
DATALINES ;
12346756,2014
;
run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.