topic Re: I have statement like this: Proc Sort data= in SAS Programming

I have statement like this: Proc Sort data= &kpa._this data out=&kpa._thisdata; by thisVar; Run;

GN0001 — Mon, 03 May 2021 23:56:54 GMT

Hello team,

I have:

Proc Sort data= &kpa._this data out=&kpa._thisdata;

by thisVar;

Run;

What does this & sign and the dot sign is?

Regards,

Blue Blue

Re: I have statement like this: Proc Sort data= &kpa._this data out=&kpa._thisdata; by this

ChrisNZ — Tue, 04 May 2021 03:00:15 GMT

& marks the start of the macro variable KPA and the dot marks the end.

If the variable has a value of abc, the line will be transformed to

proc sort data=abc_this data out=abc_thisdata;

Re: I have statement like this: Proc Sort data= &kpa._this data out=&kpa._thisdata; by this

GN0001 — Tue, 04 May 2021 06:03:00 GMT

Hello ChrisNZ,
Do we need an Undescore after dot to separate invoke of a Macro variable?
I searched a lot to see where the Macro variable is created in the code; I just found the call to Macro Variable but no trace of Macro creation.
Regards,
Blue Blue

Re: I have statement like this: Proc Sort data=

ChrisNZ — Tue, 04 May 2021 06:24:56 GMT

No. The underscore is not linked to the macro variable.

Re: I have statement like this: Proc Sort data=

GN0001 — Tue, 04 May 2021 16:50:55 GMT

Thanks for the response.
What that is used for? Just part of the name of following item?
Regards,
Blue Blue

Re: I have statement like this: Proc Sort data= &kpa._this data out=&kpa._thisdata; by this

Tom — Tue, 04 May 2021 17:46:53 GMT

The macro processor is a simple text replacement tool. Especially when you are only talking about macro variable references, like in your example. Once the text is replaced the resulting text is passed on to SAS to interpret and run the same as if the resulting text was what the program looked like to begin with.

So if you create a macro variable named PREFIX. For example by using a %LET statement.

%let prefix=AAA;

And then reference that macro variable in the middle of some other text in your program:

proc sort data=&prefix._old ....

The after the macro processor has finished processing the text your program will look like:

proc sort data=AAA_old ....

So the underscore in this situation just becomes part of the name of the dataset being sorted.

Re: I have statement like this: Proc Sort data= &kpa._this data out=&kpa._thisdata; by this

Tom — Tue, 04 May 2021 17:53:10 GMT

Your posted code cannot work. Most likely you have inserted an extra space or some other extra characters. Note that using the pop-up boxes for inserting code will make your posts easier to read since they will use fixed width fonts.

Let's add multiple spaces between the words (tokens) in your statements to make it clearer there is something wrong:

proc   sort   data=   &kpa._this   data   out=   &kpa._thisdata   ;

So if KPA has the value FRED then this code expands to

proc   sort   data=   FRED_this   data   out=   FRED_thisdata   ;

Now it is very clear that there is an extra word "data" in there. If we remove the space(s) between THIS and DATA then this call to PROC SORT is going to overwrite the original dataset with the sorted version of the dataset.

Re: I have statement like this: Proc Sort data= &kpa._this data out=&kpa._thisdata; by this

GN0001 — Tue, 04 May 2021 18:05:21 GMT

Thanks for this great response.

Re: I have statement like this: Proc Sort data= &kpa._this data out=&kpa._thisdata; by this

GN0001 — Tue, 04 May 2021 18:10:29 GMT

thanks it is resolved

Re: I have statement like this: Proc Sort data=

ChrisNZ — Tue, 04 May 2021 21:16:56 GMT

Yes See the generated code.