BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Dennis_K
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Shmuel
Garnet | Level 18

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 */

View solution in original post

2 REPLIES 2
Shmuel
Garnet | Level 18

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
Obsidian | Level 7
Dear Shmuel,
Thanks for the help. I'm keeping thinking that i should use the OF statement e.g (of Ques1-Ques5).
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 994 views
  • 0 likes
  • 2 in conversation