BookmarkSubscribeRSS Feed
heffo
Pyrite | Level 9

Hi,

I have an Excel file what has a tickbox/checkbox that I would like to get the status from (ticked or not). 

heffo_0-1632953478492.png

When I do the normal proc import, the column is just empty for both these rows. 

 

proc import datafile="&file"
		dbms=xlsx
		out=import_1_1 
		replace;
		range="1.1$P13:W15" ;
run;

heffo_1-1632953636694.png

Does anyone have any idea on how to get the tickbox value? 

 

Thanks,

Henrik 

1 REPLY 1
ballardw
Super User

Save the XLSX to CSV. See what value is created.

Read it with a data step.

 

Proc Import and XLSX is just waiting to be problem in so many ways...

Since you are using macro variables one has to guess you are going to do this with multiple files. If they are all supposed to be of similar structure it is almost certain that you will have some problem with Imported data being different in some way that causes problems later.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 741 views
  • 1 like
  • 2 in conversation