SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Difference between excel files extracted from SAS and MS Access

Reply
Frequent Contributor
Posts: 99

Difference between excel files extracted from SAS and MS Access

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.

Frequent Contributor
Posts: 139

Difference between excel files extracted from SAS and MS Access

Please provide example if possible

Ask a Question
Discussion stats
  • 1 reply
  • 276 views
  • 0 likes
  • 2 in conversation