topic Re: Import Excel and get checkbox status in SAS Programming

Import Excel and get checkbox status

heffo — Wed, 29 Sep 2021 22:16:42 GMT

Hi,

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

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;

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

Thanks,

Henrik

Re: Import Excel and get checkbox status

ballardw — Thu, 30 Sep 2021 03:05:50 GMT

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.