BookmarkSubscribeRSS Feed
bzlspn
Calcite | Level 5

Hi all,

 

I wanted to extract some KPI on the programs created with SAS. I would like to create a macro to insert his information in an SQL database. I don't how to extract computer name where the program is executed (this could be run from different machines) and also filename (.sas program )

 

Could anyone help me on this?

 

Thanks in advance

1 REPLY 1
Shmuel
Garnet | Level 18

HostName is enabled through the automatic system macro variable:  &syshostname

You can print it in the log by: %put &syshostnmae;

or get it in your code by: hostname = "&syshostname";

In some cases (as on SAS UE) you may achieve LOCALHOST as hostname.

 

Check documentation of system macro variables, mainly start with &sys...

some of them may differ according to sas platform.

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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

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
  • 1 reply
  • 1695 views
  • 0 likes
  • 2 in conversation