topic Format in SAS Programming

Format

sachin05t — Mon, 24 Sep 2018 18:12:06 GMT

libname HW 'C:\Desktop';
proc format;
value $TestSite 'LS'='Lumbar-Spine' 'T'='Thoracic';
Value $TypeOfImaging 1='MRI' 2='CT' 3='Plain';
format test site $TestSite. Type of Imaging $TypeOfImaging.;
Data HW6;
Set HW.HW6;
proc sort data=hw.hw6 nodupkey;
by DOS;
proc print;
run;

There are 4 variables:

PATID – Patient ID

DOS – Date of Service

TestSite – test Site: LS=Lumbar-Spine, T=Thoracic

TypeOfImaging – Type of Imaging: 1=MRI, 2=CT, 3=Plain

It is possible that a patient may have more than 1 entry on the same date of service.

I am trying to write a program so that:

A. Create a SAS data set so that a patient may not have more than 1 entry on the same date of service.

B. Create 2 formats: 1 for TestSite and 1 for TypeOfImaging so that their values will be listed in full details when PRINT procedure is used.

C. Use PRINT procedure to print out the data with full details of the values.

Not sure where the error lies.

Re: Format

Reeza — Mon, 24 Sep 2018 18:18:04 GMT

This code doesn't really do anything...where are you expecting something to happen? It creates a format and copies the file over but that's all.

Please comment your code with what you expect to be happening. This looks a lot like homework, so it's definitely preferable if you show a strong attempt first.

Re: Format

Kurt_Bremser — Mon, 24 Sep 2018 18:18:53 GMT

The format statement is a data step statement, not for open code or proc format.

This:

format test site $TestSite. Type of Imaging $TypeOfImaging.;

would also mean you have the following variables:

test
site
type
of
imaging

You create work.hw6, but sort hw.hw6.

Re: Format

sachin05t — Mon, 24 Sep 2018 18:23:11 GMT

Sure..I will make more attempts. We were taught Sort and Format today.