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;




 

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!

Register now

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