BookmarkSubscribeRSS Feed
bbb_NG
Fluorite | Level 6

Dear All,

     I have a work to export mobile phones in dataware house to excel files for SMS need.

     Before sas, I use MS Access moudles to do it and it works.The upload platform for sending SMS recognize both text and numberic format for

mobile phone.

     Now I write a macro to export excel files with mobile phone using character format.

  The upload platform refuse to recognize the sas-output format.

I even try "'||'mobile phone'n ,don't work either.

My alternative solution is add a step as export to ms access in SAS.

Can any one here give a thought?

Thanks.

1 REPLY 1
manojinpec
Obsidian | Level 7

Please provide example if possible

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Discussion stats
  • 1 reply
  • 779 views
  • 0 likes
  • 2 in conversation