PROC import

Reply
New Contributor
Posts: 2

PROC import

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.

PROC Star
Posts: 7,363

Re: PROC import

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

 

Art, CEO, AnalystFinder.com

Super User
Posts: 10,514

Re: PROC import

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.

New Contributor
Posts: 2

Re: PROC import

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. -##
Ask a Question
Discussion stats
  • 3 replies
  • 119 views
  • 0 likes
  • 3 in conversation