DATA Step, Macro, Functions and more

Converting char to numeric in macro

Posts: 50

Converting char to numeric in macro

[ Edited ]

 I applied the code provided in this topic to convert character variable to numeric, it works quite well for individual data sets.But when I apply the code in macro, I meet problems. When I use "proc sql" to find out character variables in data sets, SAS tells me that there are no character variables in the data sets but actually there are some. I don't know why, so could you kindly help me out? 


%macro sic2_state(i,j);
	data &j&i;
		set &j&i;
	proc sql;
	create table char_cur&j&i as 
		select name from dictionary.columns where libname='WORK' and MEMNAME="&j&i" and type='char'; 


Thanks a lot! Cheers, Owen

Super User
Posts: 6,544

Re: Converting char to numeric in macro

Within dictionary.columns, all the MEMNAME values are stored in uppercase.  So the initial hurdle to overcome is to change the MEMNAME criterion to:


and memname = upcase("&j&i")

Posts: 50

Re: Converting char to numeric in macro

Posted in reply to Astounding
@Astounding Thank you so much Astounding! That's the point! Regards, Owen
Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation