topic Re: varibale names when using _null_ dataset in SAS Programming

varibale names when using _null_ dataset

pavank — Wed, 04 Dec 2024 11:10:53 GMT

data _null_;
    set sashelp.class end=last ;
    /* Check if the observation is the 1st, 15th, 6th, or the last observation */
    if _n_ in (1, 15, 6) or last then do;
        /* Use PUT with column positioning correctly */
        put @15 name $10. @30 sex $1. @40 age 3. @50 height 5.1 @60 weight 5.1 @70 ;
    end;
run;

Hi Experts,

In the above code i want get variable names also in log window with data when using _NULL_ dataset

Re: varibale names when using _null_ dataset

PaigeMiller — Wed, 04 Dec 2024 11:23:27 GMT

I don't understand. Variable names in the log window? Doesn't the log show you the code you execute, which includes the PUT statement with the variable names?

Re: varibale names when using _null_ dataset

Kurt_Bremser — Wed, 04 Dec 2024 11:33:26 GMT

Use the equal sign to also display the variable names:

put name= sex= age= height= weight=;

Re: varibale names when using _null_ dataset

pavank — Wed, 04 Dec 2024 11:39:39 GMT

Hi @Kurt_Bremser ,

I want to display top as below

Name sex age height weight

Alfred M 14 69 112.5
James M 12 57.3 83 6
Philip M 16 72 150

William M 15 66.5 112 19

Re: varibale names when using _null_ dataset

Kurt_Bremser — Wed, 04 Dec 2024 11:50:03 GMT

Use PROC PRINT and you get it in the Output window.

If you want to see the names in the log, use this as the first statement in the step.

if _n_ = 1 then put "name sex age height weight";

(adjust positions as needed)

Re: varibale names when using _null_ dataset

PaigeMiller — Wed, 04 Dec 2024 13:25:07 GMT

@pavank

Please listen to @Kurt_Bremser and use PROC PRINT, this is sooooo much easier than writing DATA _NULL_ code to do what you want. And PROC PRINT has many other useful option as well, that you may need on other problems.

To steal again from Kurt, see Maxim 7

Maxim 7

There is a procedure for it.
(The exception proves the rule)

Learn to use prefabricated procedures for solving your tasks. 5 lines of proc means may equal 20 lines (or more) of data step logic.

Re: varibale names when using _null_ dataset

Tom — Wed, 04 Dec 2024 15:24:26 GMT

Assuming you want to PUT the names (not retrieve them from some unspecified place) just use a PUT statement with quoted strings. You probably only want to write the names once say on the first observation.

data _null_;
    set sashelp.class end=last ;
    if _n_=1 then put @15 'Name' @(30-2) 'Sex' @40 'Age' @50 'Height' @60 'Weight' ;
    /* Check if the observation is the 1st, 15th, 6th, or the last observation */
    if _n_ in (1, 15, 6) or last then do;
        /* Use PUT with column positioning correctly */
        put @15 name $10. @30 sex $1. @40 age 3. @50 height 5.1 @60 weight 5.1 @70 ;
    end;
run;

Result

              Name         Sex         Age      Height    Weight
              Alfred         M          14        69.0     112.5
              James          M          12        57.3      83.0
              Philip         M          16        72.0     150.0
              William        M          15        66.5     112.0

Re: varibale names when using _null_ dataset

pavank — Thu, 05 Dec 2024 06:47:16 GMT

Hi @Kurt_Bremser

Thank you very much for your solution

topic Re: varibale names when using _null_ dataset in SAS Programming

varibale names when using _null_ dataset

Re: varibale names when using _null_ dataset

Re: varibale names when using _null_ dataset

Re: varibale names when using _null_ dataset

Re: varibale names when using _null_ dataset

Re: varibale names when using _null_ dataset

Maxim 7

There is a procedure for it.(The exception proves the rule)

Re: varibale names when using _null_ dataset

Re: varibale names when using _null_ dataset

There is a procedure for it.
(The exception proves the rule)