topic Re: Generating a large number of data sets in SAS Programming

Generating a large number of data sets

shivate_ps0 — Wed, 15 Aug 2018 18:37:26 GMT

I am trying to understand how does following lines of code create a number of data sets.

data _null_;
   if "&sysscp"="WIN" then do;
     call symputx('rawdata',"&path\"); 
	 end;
   else do;
     call symputx('rawdata',"&path/"); 
     end;
run;

And after these lines, obviously there many data sets written using SAS code including formats and lengths and so on. How does the above code generates complete data sets and puts them in a particular folder. Could anyone please tell me the whole process behind it ? How does these macro lines run at execution time.?

	data library_name.a1;
   attrib Supplier_ID length=8 label='Supplier ID' format=12.;
   attrib Supplier_Name length=$30 label='Supplier Name';
   attrib Street_ID length=8 label='Street ID' format=12.;
   attrib Supplier_Address length=$45 label='Supplier Address';
   attrib Sup_Street_Number length=$8 label='Supplier Street Number';
   attrib Country length=$2 label='Country';

   infile datalines dsd;
   input
      Supplier_ID
      Supplier_Name
      Street_ID
      Supplier_Address
      Sup_Street_Number
      Country
   ;
datalines4;
50,Scandinavian Clothing A/S,6850100389,Kr. Augusts Gate 13,13,NO
109,Petterson AB,8500100286,Blasieholmstorg 1,1,SE
316,Prime Sports Ltd,9250103252,9 Carlisle Place,9,GB
755,Top Sports,3150108266,Jernbanegade 45,45,DK
772,AllSeasons Outdoor Clothing,9260115819,553 Cliffview Dr,553,US
798,Sportico,8300100454,C. Barquillo 1,1,ES
1280,British Sports Ltd,9250100844,85 Station Street,85,GB
1303,Eclipse Inc,9260107621,1218 Carriole Ct,1218,US
;;;;
run;

and many more data sets like this . But before doing all this following code must run successfully.

%let path=FILEPATH;
libname library_name "&path";

Re: Generating a large number of data sets

Astounding — Wed, 15 Aug 2018 18:19:40 GMT

It doesn't. The top DATA step creates 0 data sets.

The bottom DATA step creates 1 data set.

Somewhere later in your program, you might see:

&rawdata

That could be the code you need explained.

Re: Generating a large number of data sets

shivate_ps0 — Wed, 15 Aug 2018 18:39:35 GMT

Thanks but it does create .

These lines are to be run before to assign the library either in SAS Studio or SAS Enterprise.

%let path=FILEPATH;

libname library_name "&path";

Let me just edit my question.

Re: Generating a large number of data sets

Astounding — Wed, 15 Aug 2018 18:34:12 GMT

No, that code does not create data sets.

It does, however, define what "orion" means as being a particular folder. It is entirely possible that the folder already contains many SAS data sets, and executing the LIBNAME statement makes those existing data sets visible to your session.