topic Re: Apply the same format to mutiple variables in SAS Programming

Apply the same format to mutiple variables

Dennis_K — Tue, 13 Mar 2018 05:38:04 GMT

Dear all, Suppose I've the following code.

PROC FORMAT;
VALUE $RESP

'1'="STRONGLY AGREE"

'2'="AGREE"

'3'="NEUTRAL"

'4'="DISAGREE"

'5'="STRONGLY DISAGREE" ;

RUN;

DATA SURVEY;

INFILE DATALINES;

INPUT ID $ (QUES1-QUES5)($1.);

DATALINES;

001 52344

002 53241

003 43255

004 55412

005 32514 ;

RUN;

How do I use the FORMAT statement in the DATA STEP for Ques1 to Ques5?

Regards Dennis K

Shmuel — Tue, 13 Mar 2018 06:23:13 GMT

just add a line to your code:

DATA SURVEY;

INFILE DATALINES;

INPUT ID $ (QUES1-QUES5)($1.);

FORMAT ques1-ques5 $resp. ; /* or $resp20. assuminc max description is 20 chars */

Dennis_K — Tue, 13 Mar 2018 06:41:46 GMT

Dear Shmuel,
Thanks for the help. I'm keeping thinking that i should use the OF statement e.g (of Ques1-Ques5).