topic Re: proc format in SAS Programming

proc format

ambreen — Thu, 03 Oct 2019 21:10:51 GMT

I am not able to assign the formats to all of them except gender please help me with code

libname _all_ clear;
libname cdc "C:/Users/noor/Desktop/cups";
data fda;
set cdc.hw7;
run;

PROC FORMAT;
VALUE Gender 1= Female 2 = Male;
VALUE Occupation 1= Mstudent 2 = Nurse 3-5 = Resident 6-10 = Fellow;
VALUE JudgedPreviously 1= Yes 2= No;
VALUE Age 20-29 = second 30-39 = third 40 - 49 = fourth 50 - 59 = fifth;
RUN;
PROC PRINT DATA= cdc.hw7;
FORMAT GENDER GENDER. Occupation OCCUPATI. JudgedPreviously JUD. AGE AGEAGE.;
run;

Re: proc format

Reeza — Thu, 03 Oct 2019 21:17:24 GMT

Post your log.

Re: proc format

ambreen — Thu, 03 Oct 2019 21:22:00 GMT

Re: proc format

ambreen — Thu, 03 Oct 2019 21:23:07 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 libname _all_ clear;

NOTE: Libref CDC has been deassigned.

74 libname cdc "C:/Users/noor/Desktop/cups";

NOTE: Libref CDC was successfully assigned as follows:

Engine: V9

Physical Name: C:\Users\noor\Desktop\cups

75 data fda;

76 set cdc.hw7;

77 run;

NOTE: There were 37 observations read from the data set CDC.HW7.

NOTE: The data set WORK.FDA has 37 observations and 5 variables.

NOTE: DATA statement used (Total process time):

real time 0.28 seconds

cpu time 0.06 seconds

80 PROC FORMAT;

81 VALUE Gender 1= Female 2 = Male;

NOTE: Format GENDER is already on the library WORK.FORMATS.

NOTE: Format GENDER has been output.

82 VALUE Occupation 1= Mstudent 2 = Nurse 3-5 = Resident 6-10 = Fellow;

NOTE: Format OCCUPATION is already on the library WORK.FORMATS.

NOTE: Format OCCUPATION has been output.

83 VALUE JudgedPreviously 1= Yes 2= No;

NOTE: Format JUDGEDPREVIOUSLY is already on the library WORK.FORMATS.

NOTE: Format JUDGEDPREVIOUSLY has been output.

84 VALUE Age 20-29 = second 30-39 = third 40 - 49 = fourth 50 - 59 = fifth;

NOTE: Format AGE is already on the library WORK.FORMATS.

NOTE: Format AGE has been output.

85 RUN;

NOTE: PROCEDURE FORMAT used (Total process time):

real time 0.15 seconds

cpu time 0.00 seconds

86 PROC PRINT DATA= cdc.hw7;

87 FORMAT GENDER GENDER. Occupation OCCUPATI. JudgedPreviously JUD. AGE AGEAGE.;

88 run;

NOTE: There were 37 observations read from the data set CDC.HW7.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.49 seconds

cpu time 0.14 seconds

91 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

104

Re: proc format

PaigeMiller — Thu, 03 Oct 2019 21:25:13 GMT

No errors here, so please explain what the problem is in a lot more detail.

Re: proc format

ambreen — Thu, 03 Oct 2019 21:27:05 GMT

see my result in the file attached as mistake
I am not able to assign the values to observations except in gender

u can see if you see my result in file attached above

Re: proc format

Reeza — Thu, 03 Oct 2019 21:27:26 GMT

I don't see anything wrong in code or log, so that means it's a logic error. Can you retry this approach using SASHELP.CLASS data set and see what happens? If it works there, it's your data that's the issue somehow.

Re: proc format

ambreen — Thu, 03 Oct 2019 21:27:43 GMT

mistake_rtf

Re: proc format

Reeza — Thu, 03 Oct 2019 21:28:42 GMT

Can't open attachments - work restrictions, please post directly into the forum.

Re: proc format

PaigeMiller — Thu, 03 Oct 2019 21:31:49 GMT

@ambreen wrote:
see my result in the file attached as mistake
I am not able to assign the values to observations except in gender

u can see if you see my result in file attached above

Many of us don't (or can't) download attachments. Why don't you post the output here in your reply, or better yet, explain the problem to us.

Re: proc format

VDD — Thu, 03 Oct 2019 21:47:22 GMT

well @ambreen there are to many things wrong to point at just one.

Try this and see if you can find out what you did wrong.

data fda;

*set cdc.hw7;
input gender occupation judgedpreviously age;
cards;
1	1	1	21
1	1	1	48
2	2	1	54
2	1	2	35
;


PROC FORMAT;
VALUE Gender  1= 'Female'  2 = 'Male';
VALUE Occupation 1= 'Mstudent' 2 = 'Nurse' 3-5 = 'Resident' 6-10 = 'Fellow';
VALUE JudgedPreviously 1= 'Yes' 2= 'No';
 VALUE Age  20-29 = 'second' 30-39 = 'third' 40 - 49 = 'fourth' 50 - 59 = 'fifth';
RUN;
 PROC PRINT DATA= fda ;/*cdc.hw7;*/
FORMAT GENDER GENDER.  Occupation Occupation. JudgedPreviously JudgedPreviously.  AGE AGE.;
run;

The SAS System 


Obs gender occupation judgedpreviously age 
1 Female Mstudent Yes second 
2 Female Mstudent Yes fourth 
3 Male Nurse Yes fifth 
4 Male Mstudent No third