topic PROC import in SAS Programming

PROC import

Jdesai123 — Tue, 16 May 2017 16:30:24 GMT

How do I import a particular column in Excel which utilize Formula to generate values using PROC IMPORT?

I am using following code and per my understanding SAS should automatically generate values in the field solving formula.

Ex. Excel File: COL_C is based on the formula (100-COLA).

proc import datafile= "..\Temp\test.xlsx" dbms=xlsx out= test replace;
sheet="temp";
getnames=YES;
run; quit;

While importing, COLA and COLB gets correct value while COLC is generating all missing values.

Re: PROC import

art297 — Tue, 16 May 2017 17:16:35 GMT

Impossible (for me at least) to tell without seeing the file.

Art, CEO, AnalystFinder.com

Re: PROC import

ballardw — Tue, 16 May 2017 19:53:55 GMT

Do you get any messages in the log? Post the code and messages from the log.

Is he formula actually: = 100 - A2

or does is have one of $ modifiers like = 100 - A$2 or 100 - $A2 ?

Does the cell address reference the result of another cell containing a formula?

Also depending on spreadsheet the variable may be getting assigned a numeric variable type in SAS but for some reason the result of the forumla is behaving like character and hence gets a missing value in SAS.

Easiest may be to SAVE As CSV and import the resulting CSV file.

Re: PROC import

Jdesai123 — Wed, 17 May 2017 17:11:56 GMT

Hi,

I re-do the Formula and it worked fine.

I think Formula was saving as Character while converting so it was not
resolving while converting.

Thank you all for the help.

##- Please type your reply above this line. Simple formatting, no
attachments. -##