topic Re: Help required on NLMNYw.d informat from Excel input in SAS Procedures

Help required on NLMNYw.d informat from Excel input

Brian_lewis67 — Sun, 04 Oct 2009 19:30:52 GMT

Hi I'm new on this forum but couldn't find anything after a search regarding a problem I have with using the nlmny informat function while inputting data in from an excel spreadsheet

The code is below but the table result comes out as null in every observation

data ptd;
infile xl3 notab dlm='09'x dsd missover;
format field1 $8. field2 14.2 field3 $7.;
input field1 $ a $field3 $ c $ d$ field2 nlmny14.2 ;
run;

Field2 is read in from excel and currently has monetry format fields which I need to calculate on.

Can anyone please help?

Thanks,

Brian

Re: Help required on NLMNYw.d informat from Excel input

ChrisNZ — Sun, 04 Oct 2009 23:10:00 GMT

More information needed imho:

Is it only field2 that is returned missing?

What is the LOCALE option equal to?

What is the raw value of field2? (Read it using character informat)

Any message in the log?

Re: Help required on NLMNYw.d informat from Excel input

data_null__ — Sun, 04 Oct 2009 23:40:33 GMT

I was thinking the colon format modifier is need to read DSD data properly.
[pre]
input field1 $ a $field3 $ c $ d$ field2 :nlmny14.2 ;
[/pre]

Knowing more about the log messages would be helpful too.

Re: Help required on NLMNYw.d informat from Excel input

Brian_lewis67 — Mon, 05 Oct 2009 08:37:01 GMT

The colon format identifier worked perfectly.

Thanks for the replies.