BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sas_it
Quartz | Level 8

Please explain the code in detail step by step.

 

proc sort data=A out=A1;
by Division District ;
run;


Does this code mean the sorted data is stored in A1 Dataset?

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

The data step copies a dataset from your second library (TAD_DEST) called MASTER_FILE to a dataset called O in your temporary library WORK (or USER if such is defined).

For the code presented, the first LIBNAME is irrelevant, as the library is not used.

 


@sas_it wrote:

Please explain the mean

 

Please explain the meaning of the code in detail. Meaning of two libnames and where the dataset is stored.

libname TAD_Sour odbc dsn=TAD user="SAAS_DATA" password="abc" schema=dbo;
libname TAD_Dest "/sasdatauser/sasdatauser/TAD";

/*Starting from Program1 here,no need to look into program 1*/

data o;
set TAD_DEST.Master_File;
run;




 

View solution in original post

1 REPLY 1
Kurt_Bremser
Super User

The data step copies a dataset from your second library (TAD_DEST) called MASTER_FILE to a dataset called O in your temporary library WORK (or USER if such is defined).

For the code presented, the first LIBNAME is irrelevant, as the library is not used.

 


@sas_it wrote:

Please explain the mean

 

Please explain the meaning of the code in detail. Meaning of two libnames and where the dataset is stored.

libname TAD_Sour odbc dsn=TAD user="SAAS_DATA" password="abc" schema=dbo;
libname TAD_Dest "/sasdatauser/sasdatauser/TAD";

/*Starting from Program1 here,no need to look into program 1*/

data o;
set TAD_DEST.Master_File;
run;




 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 826 views
  • 1 like
  • 2 in conversation