Hello,
Is there a way to pull in values from specific cells of a spreadsheet and display them in a table.
For e.g. I have a spreadsheet that has :
Cell Address - Value
B16 - Toyota
D23 - Corolla
M45 - Honda
H-76 - Accord
Output that I am hoping for is :
A1 - Toyota
A2 - Honda
B1 - Corolla
B2 - Accord
TIA,
Varun
The input excel spreadsheet is not formatted like a table. But the values that I want to pull in have a specific cell address.
What do you call a table? A SAS data set? What are the column names?
The input excel spreadsheet is not formatted like a table.
By table I mean it doesn't have a column name. Values are spread across the sheet . Please see attachment.
Does that make sense ?
Thanks for your help.
This is just an example I posted. I know what cells I need to look up and they will remain the same.
I am aware of the PROC IMPORT option using range but my issue with it is that each import step will create a different data set.
And I want them to line up in a tabular form in the Output.
@VarunD wrote:
Thanks for your help.
This is just an example I posted. I know what cells I need to look up and they will remain the same.
I am aware of the PROC IMPORT option using range but my issue with it is that each import step will create a different data set.
And I want them to line up in a tabular form in the Output.
You can append them together after the fact.
DDE is your other option or a Visual Basic script but both are using outside technologies.
Thanks for your help.
This is just an example I posted. I know what cells I need to look up and they will remain the same.
I am aware of the PROC IMPORT option using range but my issue with it is that each import step will create a different data set.
And I want them to line up in a tabular form in the Output.
That's the easiest option as @Reeza said.
proc import .. range..
proc import .. range..
proc import .. range..
data FINAL;
merge XL1 (rename=(VAR=VAR1))
XL2 (rename=(VAR=VAR2))
XL3 (rename=(VAR=VAR3));
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.