cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
A1ex777
Fluorite | Level 6 A1ex777
Fluorite | Level 6

Inserting html text into table

Posted 04-11-2022 06:10 AM (1147 views)

Hello.

Can you please advice any best practice how i can load html text to database table using SAS.

Any help would be appreciate!

0 Likes
Reply
2 REPLIES 2
Oligolas
Barite | Level 11 Oligolas
Barite | Level 11

Re: Inserting html text into table

Posted 04-11-2022 06:50 AM (1110 views)  |   In reply to A1ex777

Here you go: FILENAME Statement: URL Access Method 

________________________

- Cheers -
0 Likes
Reply
AllanBowe
Barite | Level 11 AllanBowe
Barite | Level 11

Re: Inserting html text into table

Posted 04-11-2022 08:47 AM (1083 views)  |   In reply to A1ex777
If you'd like to do this without writing any code (just copy paste the data into the database table) you could consider this tool, produced by my team: https://datacontroller.io
/Allan
MacroCore library for app developers
Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs
Reply
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

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
  • 2 replies
  • ‎04-11-2022 06:10 AM
  • 1148 views
  • 2 likes
  • 3 in conversation