topic Use a dataset to provide the format to an argument for a put statement in SAS Programming

Use a dataset to provide the format to an argument for a put statement

dewittme — Thu, 26 Apr 2018 13:12:11 GMT

I have a data set that looks like this:

Where "response" is a formatted column (actual values are numeric: 1,2, 3). I have the correct format in the "format" column, as text.

I would like to do something like

DATA desired;

    SET current_data;

    question_fmt = put(response, format);

RUN;

Here I want the format supplied to the put argument to come from the format column. IS there a way to do this?

Re: Use a dataset to provide the format to an argument for a put statement

Kurt_Bremser — Thu, 26 Apr 2018 13:15:24 GMT

Please post data in a usable form (hint: pictures ar NOT useful). See my footnotes.

Re: Use a dataset to provide the format to an argument for a put statement

Oligolas — Thu, 26 Apr 2018 13:20:16 GMT

Hi,

you can use the vvalue function (Returns by Default a $200 length if not specified)

DATA desired;
    SET current_data;
    question_fmt = vvalue(Response);
RUN;

Re: Use a dataset to provide the format to an argument for a put statement

RW9 — Thu, 26 Apr 2018 13:20:25 GMT

Post test data in the form of a datastep and what you want to see out. How are you going to store the output text with the format, as formats apply to the whole variable? You could use a text field of course.

I suspect what you are after is the putc and putn functions. Then you pass the variable, the format name, and optionally length across:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212562.htm

Re: Use a dataset to provide the format to an argument for a put statement

dewittme — Thu, 26 Apr 2018 13:46:20 GMT

This is exactly the function I needed

Thank you!