topic Enter Variable and save in table in New SAS User

Enter Variable and save in table

Andres_Fuentes1 — Thu, 05 Aug 2021 14:39:24 GMT

Hello, good morning everyone, I have a query. I would like to do the following: when running a process the user has to enter a variable or parameter (numeric) that SAS requests, and this is saved in a table with a single record.

Like That

and Results

Thanks

Re: Enter Variable and save in table

Reeza — Thu, 05 Aug 2021 15:15:58 GMT

https://support.sas.com/resources/papers/proceedings/proceedings/forum2007/115-2007.pdf

Follow the instructions in the linked tutorials.

Re: Enter Variable and save in table

andreas_lds — Mon, 09 Aug 2021 06:17:29 GMT

A parameter is a macro-variable, all macro-variables are also stored in sashelp.vmacro, so if your parameters all start with a common prefix you can do:

data work.Parameter;
   set sashelp.vmacro;
   where Name =: 'PAR_';

   keep name value;
run;

proc transpose data=work.Parameter out=work.want(drop= _name_ _label_);
   var value;
   id name;
run;

If your parameter don't have a common prefix, adjust the where-statement to your needs.

EDIT: proc transpose got lost during copy/paste.