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
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 */
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 */
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.