July 6, 2008 06:00pm pdt

1. bradanelson 11,064
2. PFrog 2,000
2. ee_rlee 2,000
4. wolfen351 1,964
5. jinesh_k... 1,500
6. Kdo 1,000
6. chuckyh 1,000
6. vb_jonas 1,000
6. andymcooper 1,000
10. telespan 800
11. appari 750
12. sudhijss 600
13. Randy_Bo... 500
13. jefftwilley 500
13. robocat 500

1. bradanelson 11,324
2. andymcooper 5,000
3. tobey1 4,512
4. PFrog 2,500
5. wolfen351 2,164
6. itpuzzle... 2,000
6. sasmeister 2,000
6. lwal036 2,000
6. zvmrws 2,000
6. ee_rlee 2,000
6. Tecksyzt... 2,000
12. jinesh_k... 1,500
13. andyalder 1,400
14. Kdo 1,000
14. vb_jonas 1,000
14. chuckyh 1,000
14. m1tk4 1,000

04.29.2008 at 06:27AM PDT, ID: 23361919

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.1

SAS 9.1 - ERROR: Physical file does not exist

Zone: SAS

I am using a web-based application that creates 2 data export files for pulling data into SAS:

DATA_EXPORT_2008-04-29.CSV
DATA_EXPORT_2008-04-29.SAS

Both of these files are saved together in a folder (the folder can be anywhere).

The instructions are to double-click the DATA_EXPORT_2008-04-29.SAS file (syntax file) to open that file in SAS. Then, Run, Submit. This should pull in all the data from the associated DATA_EXPORT_2008-04-29.CSV file, complete with labels, formats, etc.

However, even though the syntax file does not specify a specific path for the CSV file:

data MYDATASET;
%let _EFIERR_ = 0;
infile 'DATA_EXPORT_2008-04-29.CSV' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ;

Instead of finding the CSV file in the same folder, it is looking in the Windows\System32 folder (which is not where it is).
Here is the error in the log:

ERROR: Physical file does not exist,
C:\WINDOWS\system32\DATA_EXPORT_2008-04-29.CSV.
NOTE: The SAS System stopped processing this step because of errors.

I do not want to have to hard-code the path to the CSV file, because this will vary depending on who is exporting the data, and where they decide to store it. It will, though, always be in the same folder as the SAS file. How can I get the SAS file to find the CSV file when it is located in the same relative folder?? Is this a SAS setting that I need to set? Or does something in the code need to change?

Thank you.

Start your free trial to view this solution

Question Stats

Zone: Database

Question Asked By: sah18

Solution Provided By: bradanelson

Participating Experts: 1

Solution Grade: A

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
New Net Users
New Users

Software
Digital Music
Gaming World

Home Security
Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Handhelds / PDAs
Displays / Monitors
Components
Networking Hardware

Peripherals
Laptops/Notebooks
Storage
Servers

Desktops
New Users
Misc
Apple

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMWare
Misc
Web Development

OS
CYGWIN
Voice Recognition
Message Queue
Quality Assurance
Security
Firewalls
MultiMedia Applications

Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals

Devices
Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
WebApplications
IDS
Vulnerabilities
Email Clients

File Sharing
Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMWare

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel

Algorithms
Game
Signal Processing
Project Management
Open Source

Database
Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Images

Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration
WebApplications

Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Broadband

Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Community Advisor
Lounge
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles

Community Support

Suggestions
New to EE
New Topics
Community Advisor

CleanUp
Announcements
General

Feedback
Input
EE Bugs

04.29.2008 at 07:34AM PDT, ID: 21462642

bradanelson:

If they are running it in interactive mode, which is what you described above, this solution should work. At the top of the code, paste in the following MACRO.

%MACRO Path();
%SYSFUNC(SUBSTR(%SYSGET(SAS_EXECFILEPATH),1,%SYSFUNC(LENGTH(%SYSGET(SAS_EXECFILEPATH)))-%SYSFUNC(INDEX(%SYSFUNC(REVERSE(%SYSGET(SAS_EXECFILEPATH))),\))))
%MEND Path;

Now in the INFILE section of the DATASTEP, adjust it to the following. (Don't forget to replace the single quotes with double quotes)

data MYDATASET;
%let _EFIERR_ = 0;
infile "%PATH\DATA_EXPORT_2008-04-29.CSV" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ;

Let me know if this solves your problem.

Accepted Solution

04.29.2008 at 08:52AM PDT, ID: 21463430

sah18:

I will try your suggestion above and post back.

The syntax, though, is actually generated by the web application; and others are not having the problem I am having (using that very same syntax). It seems that it is a local software setting issue rather than a coding issue. Is there some sort of SAS preference that needs to be changed?

04.29.2008 at 09:01AM PDT, ID: 21463514

sah18:

I just tried adding in your code, and it is still not finding the file:

ERROR: Physical file does not exist,
C:\WINDOWS\system32\%PATH\DATA_EXPORT_2008-04-29-08.CSV.

04.29.2008 at 09:03AM PDT, ID: 21463532

sah18:

The error posted above should read:

ERROR: Physical file does not exist,
C:\WINDOWS\system32\%PATH\DATA_EXPORT_2008-04-29.CSV.

04.29.2008 at 09:48AM PDT, ID: 21463945

bradanelson:

Can you show me the code you are running?

04.29.2008 at 10:01AM PDT, ID: 21464061

bradanelson:

You are using the SAS CURRENT FOLDER which can change depending on many variables. I would not recommend using this method as it brings different results depending on the way SAS is opened, etc. And if you want the pathname to be dynamic, relying on this setting will not bring consitent results.

I can give you other alternatives if the above solution does not work. I could put the pathname in a GLOBAL variable for you and you can reference that as well. I would like to see your code before hand though. I tested the above example on my PC and it worked fine.

Here is an exerpt from a SUGI 28 Paper...

UNDERSTANDING THE SAS CURRENT FOLDER
The SAS current folder (which used to be called the working
folder) is an important concept related to SAS configuration files
and to saving and accessing files within the SAS System. This is
the folder that SAS looks for files in and stores files to when a
specific pathname isnt given. For example, if you do not specify a
pathname for a file specified in the FILENAME statement, the
SAS System looks for the file in the current folder.
Note: The Save As and Open dialog boxes do not default to the
current folder; rather, they default (at the beginning of a SAS
session) to the folder associated with the SASUSER libref.
The simplest case for the current folder is when you start your
SAS session using a program shortcut, such as starting SAS from
the Windows Start menu. In that case, the current folder is the
pathname specified in the Start in field in the Properties dialog
box for the SAS System shortcut that you used. To use a different
folder as the current folder, simply edit the contents of the Start in
field.
Note: It is not recommended to leave the Start in field blank.
Things start getting more complicated when you use the Windows
Run dialog box or a command-prompt window to start the SAS
System. In this situation, two scenarios have two different results:
À If you specify a path to SAS.EXE, the current folder is the
path that you specify as part of the SAS command. This is
true, even if the SAS.EXE file actually is not in that folder. If
the SAS.EXE file is not in the folder you specify in the path,
Windows searches the paths named in the PATH Windows
environment variable for a file named SAS.EXE. But the
current folder remains the path you specified in the
command.
À If you specify just SAS.EXE as the command (no path to the
file), then the current folder is the path from which you
issued the command.
o For the Run dialog box, this translates to C:\.
o For commands issued from command-prompt
windows, it is the pathname that appears before
the command prompt. For example, if you change
directories to C:\SASBOOK, then type SAS.EXE
at the command prompt and press Enter, the SAS
System starts up, using C:\SASBOOK as the
current folder.
Note: Issuing the SAS command from a command prompt
window or the Run dialog box with no pathname assumes that the
folder that contains the SAS.EXE file is listed in the PATH
Windows environment variable.
If the SASINITIALFOLDER system option is specified at SAS
System start-up (such as in the SAS configuration file or in the
SAS command), the pathname specified by the option becomes
the current folder, overriding any other rules.
Note: The SASINITIALFOLDER system option also affects the
default folder used in the Open and Save As dialog boxes (which
normally default to the folder associated with the SASUSER
libref).
The current folder is displayed in status bar at the bottom of the
SAS workspace.
To change the current folder during a SAS session, double-click
the folder name in the status bar of the SAS workspace. The
Change Folder dialog box appears, similar to Figure 2.
Figure 2. Change Folder Dialog Box
Type the full pathname of the folder in the Folder field. Or, you
can use the mouse to navigate the list of folders and double-click
the folder that you want to use. To move up in the folder
hierarchy, click the icon showing a folder with an up arrow, to the
right of the Look in field.
Once the Folder field contains the name of the folder you want,
click OK. If you change the folder more than once during a single
SAS session, the Folder field remembers all the folders you have
used. To select a previous current folder, click the down arrow by
the Folder field and select the correct folder. Then click OK.
Note: Changing the current folder using the Change Folder dialog
box is not a permanent change. The next time you invoke the
SAS System, the current folder defaults to the last current folder
that was permanently set.
An alternative way to open the Change Folder dialog box is to
issue the DLGCDIR command from the Command bar.

04.29.2008 at 10:18AM PDT, ID: 21464220

sah18:

Well, the file will always be run in exactly the same way, as follows (in case this helps):

SAS and CSV are saved to the same location (any location, but must be the same).
Double-click the SAS file to launch SAS with the syntax file loaded.
Select: Run, Submit to execute the program (syntax) file.

This will always be the sequence that is carried out.

I've included the full program code below (it includes the modifications you suggested above).

I appreciate your help on this.

                       
         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
584:
585:
586:
587:
588:
589:
590:
591:
592:
593:
594:
595:
596:
597:
598:
599:
600:
601:
602:
603:
604:
605:
606:
607:
608:
609:
610:
611:
612:
613:
614:
615:
616:
617:
618:
619:
620:
621:
622:
623:
624:
625:
626:
627:
628:
629:
630:
631:
632:
633:
634:
635:
636:
637:
638:
639:
640:
641:
642:
643:
644:
645:
646:
647:
648:
649:
650:
651:
652:
653:
654:
655:
656:
657:
658:
659:
660:
661:
662:
663:
664:
665:
666:
667:
668:
669:
670:
671:
672:
673:
674:
675:
676:
677:
678:
679:
680:
681:
682:
683:
684:
685:
686:
687:
688:
689:
690:
691:
692:
693:
694:
695:
696:
697:
698:
699:
700:
701:
702:
703:
704:
705:
706:
707:
708:
709:
710:
711:
712:
713:
714:
715:
716:
717:
718:
719:
720:
721:
722:
723:
724:
725:
726:
727:
728:
729:
730:
731:
732:
733:
734:
735:
736:
737:
738:
739:
740:
741:
742:
743:
744:
745:
746:
747:
748:
749:
750:
751:
752:
753:
754:
755:
756:
757:
758:
759:
760:
761:
762:
763:
764:
765:
766:
767:
768:
769:
770:
771:
772:
773:
774:
775:
776:
777:
778:
779:
780:
781:
782:
783:
784:
785:
786:
787:
788:
789:
790:
791:
792:
793:
794:
795:
796:
797:
798:
799:
800:
801:
802:
803:
804:
805:
806:
807:
808:
809:
810:
811:
812:
813:
814:
815:
816:
817:
818:
819:
820:
821:
822:
823:
824:
825:
826:
827:
828:
829:
830:
831:
832:
833:
834:
835:
836:
837:
838:
839:
840:
841:
842:
843:
844:
845:
846:
847:
848:
849:
850:
851:
852:
853:
854:
855:
856:
857:
858:
859:
860:
861:
862:
863:
864:
865:
866:
867:
868:
869:
870:
871:
872:
873:
874:
875:
876:
877:
878:
879:
880:
881:
882:
883:
884:
885:
886:
887:
888:
889:
890:
891:
892:
893:
894:
895:
896:
897:
898:
899:
900:
901:
902:
903:
904:
905:
906:
907:
908:
909:
910:
911:
912:
913:
914:
915:
916:
917:
918:
919:
920:
921:
922:
923:
924:
925:
926:
927:
928:
929:
930:
931:
932:
933:
934:
935:
936:

           
           
             %MACRO Path();
    %SYSFUNC(SUBSTR(%SYSGET(SAS_EXECFILEPATH),1,%SYSFUNC(LENGTH(%SYSGET(SAS_EXECFILEPATH)))-%SYSFUNC(INDEX(%SYSFUNC(REVERSE(%SYSGET(SAS_EXECFILEPATH))),\))))
%MEND Path;
 
proc delete data=_ALL_;
run;
 
data mydataset;
%let _EFIERR_ = 0;
infile '%PATH\DATA_EXPORT_2008-04-29' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ; 
	informat study_id $50. ;
	informat date_enrolled mmddyy10. ;
	informat first_name $30. ;
	informat last_name $30. ;
	informat address $500. ;
	informat telephone_1 $30. ;
	informat telephone_2 $30. ;
	informat email $30. ;
	informat sex best32. ;
	informat race best32. ;
	informat dob mmddyy10. ;
	informat height best32. ;
	informat weight best32. ;
	informat dry_weight best32. ;
	informat comorbidities $30. ;
	informat diabetes best32. ;
	informat diabetes_type best32. ;
	informat dialysis_initiation mmddyy10. ;
	informat access_type best32. ;
	informat access_location best32. ;
	informat dialysis_unit_name $30. ;
	informat dialysis_unit_phone $30. ;
	informat dialysis_schedule_days best32. ;
	informat dialysis_schedule_time best32. ;
	informat etiology_esrd best32. ;
	informat subject_comments $500. ;
	informat subject_complete best32. ;
	informat date_visit_b mmddyy10. ;
	informat date_blood_b mmddyy10. ;
	informat alb_b best32. ;
	informat prealb_b best32. ;
	informat creat_b best32. ;
	informat npcr_b best32. ;
	informat chol_b best32. ;
	informat transferrin_b best32. ;
	informat kt_v_b best32. ;
	informat drywt_b best32. ;
	informat plasma1_b best32. ;
	informat plasma2_b best32. ;
	informat plasma3_b best32. ;
	informat serum1_b best32. ;
	informat serum2_b best32. ;
	informat serum3_b best32. ;
	informat sga_b best32. ;
	informat date_supplement_dispensed mmddyy10. ;
	informat baseline_complete best32. ;
	informat date_visit_1 mmddyy10. ;
	informat alb_1 best32. ;
	informat prealb_1 best32. ;
	informat creat_1 best32. ;
	informat npcr_1 best32. ;
	informat chol_1 best32. ;
	informat transferrin_1 best32. ;
	informat kt_v_1 best32. ;
	informat drywt_1 best32. ;
	informat no_show_1 best32. ;
	informat compliance_1 best32. ;
	informat hospit_1 best32. ;
	informat cause_hosp_1 best32. ;
	informat admission_date_1 mmddyy10. ;
	informat discharge_date_1 mmddyy10. ;
	informat discharge_summary_1 best32. ;
	informat death_1 best32. ;
	informat date_death_1 mmddyy10. ;
	informat cause_death_1 best32. ;
	informat month_1_complete best32. ;
	informat date_visit_2 mmddyy10. ;
	informat alb_2 best32. ;
	informat prealb_2 best32. ;
	informat creat_2 best32. ;
	informat npcr_2 best32. ;
	informat chol_2 best32. ;
	informat transferrin_2 best32. ;
	informat kt_v_2 best32. ;
	informat drywt_2 best32. ;
	informat no_show_2 best32. ;
	informat compliance_2 best32. ;
	informat hospit_2 best32. ;
	informat cause_hosp_2 best32. ;
	informat admission_date_2 mmddyy10. ;
	informat discharge_date_2 mmddyy10. ;
	informat discharge_summary_2 best32. ;
	informat death_2 best32. ;
	informat date_death_2 mmddyy10. ;
	informat cause_death_2 best32. ;
	informat month_2_complete best32. ;
	informat date_visit_3 mmddyy10. ;
	informat date_blood_3 mmddyy10. ;
	informat alb_3 best32. ;
	informat prealb_3 best32. ;
	informat creat_3 best32. ;
	informat npcr_3 best32. ;
	informat chol_3 best32. ;
	informat transferrin_3 best32. ;
	informat kt_v_3 best32. ;
	informat drywt_3 best32. ;
	informat plasma1_3 best32. ;
	informat plasma2_3 best32. ;
	informat plasma3_3 best32. ;
	informat serum1_3 best32. ;
	informat serum2_3 best32. ;
	informat serum3_3 best32. ;
	informat sga_3 best32. ;
	informat no_show_3 best32. ;
	informat compliance_3 best32. ;
	informat hospit_3 best32. ;
	informat cause_hosp_3 best32. ;
	informat admission_date_3 mmddyy10. ;
	informat discharge_date_3 mmddyy10. ;
	informat discharge_summary_3 best32. ;
	informat death_3 best32. ;
	informat date_death_3 mmddyy10. ;
	informat cause_death_3 best32. ;
	informat month_3_complete best32. ;
	informat date_visit_4 mmddyy10. ;
	informat alb_4 best32. ;
	informat prealb_4 best32. ;
	informat creat_4 best32. ;
	informat npcr_4 best32. ;
	informat chol_4 best32. ;
	informat transferrin_4 best32. ;
	informat kt_v_4 best32. ;
	informat drywt_4 best32. ;
	informat no_show_4 best32. ;
	informat compliance_4 best32. ;
	informat hospit_4 best32. ;
	informat cause_hosp_4 best32. ;
	informat admission_date_4 mmddyy10. ;
	informat discharge_date_4 mmddyy10. ;
	informat discharge_summary_4 best32. ;
	informat death_4 best32. ;
	informat date_death_4 mmddyy10. ;
	informat cause_death_4 best32. ;
	informat month_4_complete best32. ;
	informat date_visit_5 mmddyy10. ;
	informat alb_5 best32. ;
	informat prealb_5 best32. ;
	informat creat_5 best32. ;
	informat npcr_5 best32. ;
	informat chol_5 best32. ;
	informat transferrin_5 best32. ;
	informat kt_v_5 best32. ;
	informat drywt_5 best32. ;
	informat no_show_5 best32. ;
	informat compliance_5 best32. ;
	informat hospit_5 best32. ;
	informat cause_hosp_5 best32. ;
	informat admission_date_5 mmddyy10. ;
	informat discharge_date_5 mmddyy10. ;
	informat discharge_summary_5 best32. ;
	informat death_5 best32. ;
	informat date_death_5 mmddyy10. ;
	informat cause_death_5 best32. ;
	informat month_5_complete best32. ;
	informat date_visit_6 mmddyy10. ;
	informat date_blood_6 mmddyy10. ;
	informat alb_6 best32. ;
	informat prealb_6 best32. ;
	informat creat_6 best32. ;
	informat npcr_6 best32. ;
	informat chol_6 best32. ;
	informat transferrin_6 best32. ;
	informat kt_v_6 best32. ;
	informat drywt_6 best32. ;
	informat plasma1_6 best32. ;
	informat plasma2_6 best32. ;
	informat plasma3_6 best32. ;
	informat serum1_6 best32. ;
	informat serum2_6 best32. ;
	informat serum3_6 best32. ;
	informat sga_6 best32. ;
	informat no_show_6 best32. ;
	informat compliance_6 best32. ;
	informat hospit_6 best32. ;
	informat cause_hosp_6 best32. ;
	informat admission_date_6 mmddyy10. ;
	informat discharge_date_6 mmddyy10. ;
	informat discharge_summary_6 best32. ;
	informat death_6 best32. ;
	informat date_death_6 mmddyy10. ;
	informat cause_death_6 best32. ;
	informat month_6_complete best32. ;
	informat complete_study best32. ;
	informat withdraw_date mmddyy10. ;
	informat withdraw_reason best32. ;
	informat complete_study_date mmddyy10. ;
	informat study_comments $500. ;
	informat study_completion_complete best32. ;
 
	format study_id $20. ;
	format date_enrolled mmddyy10. ;
	format first_name $20. ;
	format last_name $20. ;
	format address $20. ;
	format telephone_1 $20. ;
	format telephone_2 $20. ;
	format email $20. ;
	format sex best12. ;
	format race best12. ;
	format dob mmddyy10. ;
	format height best12. ;
	format weight best12. ;
	format dry_weight best12. ;
	format comorbidities $20. ;
	format diabetes best12. ;
	format diabetes_type best12. ;
	format dialysis_initiation mmddyy10. ;
	format access_type best12. ;
	format access_location best12. ;
	format dialysis_unit_name $20. ;
	format dialysis_unit_phone $20. ;
	format dialysis_schedule_days best12. ;
	format dialysis_schedule_time best12. ;
	format etiology_esrd best12. ;
	format subject_comments $20. ;
	format subject_complete best12. ;
	format date_visit_b mmddyy10. ;
	format date_blood_b mmddyy10. ;
	format alb_b best12. ;
	format prealb_b best12. ;
	format creat_b best12. ;
	format npcr_b best12. ;
	format chol_b best12. ;
	format transferrin_b best12. ;
	format kt_v_b best12. ;
	format drywt_b best12. ;
	format plasma1_b best12. ;
	format plasma2_b best12. ;
	format plasma3_b best12. ;
	format serum1_b best12. ;
	format serum2_b best12. ;
	format serum3_b best12. ;
	format sga_b best12. ;
	format date_supplement_dispensed mmddyy10. ;
	format baseline_complete best12. ;
	format date_visit_1 mmddyy10. ;
	format alb_1 best12. ;
	format prealb_1 best12. ;
	format creat_1 best12. ;
	format npcr_1 best12. ;
	format chol_1 best12. ;
	format transferrin_1 best12. ;
	format kt_v_1 best12. ;
	format drywt_1 best12. ;
	format no_show_1 best12. ;
	format compliance_1 best12. ;
	format hospit_1 best12. ;
	format cause_hosp_1 best12. ;
	format admission_date_1 mmddyy10. ;
	format discharge_date_1 mmddyy10. ;
	format discharge_summary_1 best12. ;
	format death_1 best12. ;
	format date_death_1 mmddyy10. ;
	format cause_death_1 best12. ;
	format month_1_complete best12. ;
	format date_visit_2 mmddyy10. ;
	format alb_2 best12. ;
	format prealb_2 best12. ;
	format creat_2 best12. ;
	format npcr_2 best12. ;
	format chol_2 best12. ;
	format transferrin_2 best12. ;
	format kt_v_2 best12. ;
	format drywt_2 best12. ;
	format no_show_2 best12. ;
	format compliance_2 best12. ;
	format hospit_2 best12. ;
	format cause_hosp_2 best12. ;
	format admission_date_2 mmddyy10. ;
	format discharge_date_2 mmddyy10. ;
	format discharge_summary_2 best12. ;
	format death_2 best12. ;
	format date_death_2 mmddyy10. ;
	format cause_death_2 best12. ;
	format month_2_complete best12. ;
	format date_visit_3 mmddyy10. ;
	format date_blood_3 mmddyy10. ;
	format alb_3 best12. ;
	format prealb_3 best12. ;
	format creat_3 best12. ;
	format npcr_3 best12. ;
	format chol_3 best12. ;
	format transferrin_3 best12. ;
	format kt_v_3 best12. ;
	format drywt_3 best12. ;
	format plasma1_3 best12. ;
	format plasma2_3 best12. ;
	format plasma3_3 best12. ;
	format serum1_3 best12. ;
	format serum2_3 best12. ;
	format serum3_3 best12. ;
	format sga_3 best12. ;
	format no_show_3 best12. ;
	format compliance_3 best12. ;
	format hospit_3 best12. ;
	format cause_hosp_3 best12. ;
	format admission_date_3 mmddyy10. ;
	format discharge_date_3 mmddyy10. ;
	format discharge_summary_3 best12. ;
	format death_3 best12. ;
	format date_death_3 mmddyy10. ;
	format cause_death_3 best12. ;
	format month_3_complete best12. ;
	format date_visit_4 mmddyy10. ;
	format alb_4 best12. ;
	format prealb_4 best12. ;
	format creat_4 best12. ;
	format npcr_4 best12. ;
	format chol_4 best12. ;
	format transferrin_4 best12. ;
	format kt_v_4 best12. ;
	format drywt_4 best12. ;
	format no_show_4 best12. ;
	format compliance_4 best12. ;
	format hospit_4 best12. ;
	format cause_hosp_4 best12. ;
	format admission_date_4 mmddyy10. ;
	format discharge_date_4 mmddyy10. ;
	format discharge_summary_4 best12. ;
	format death_4 best12. ;
	format date_death_4 mmddyy10. ;
	format cause_death_4 best12. ;
	format month_4_complete best12. ;
	format date_visit_5 mmddyy10. ;
	format alb_5 best12. ;
	format prealb_5 best12. ;
	format creat_5 best12. ;
	format npcr_5 best12. ;
	format chol_5 best12. ;
	format transferrin_5 best12. ;
	format kt_v_5 best12. ;
	format drywt_5 best12. ;
	format no_show_5 best12. ;
	format compliance_5 best12. ;
	format hospit_5 best12. ;
	format cause_hosp_5 best12. ;
	format admission_date_5 mmddyy10. ;
	format discharge_date_5 mmddyy10. ;
	format discharge_summary_5 best12. ;
	format death_5 best12. ;
	format date_death_5 mmddyy10. ;
	format cause_death_5 best12. ;
	format month_5_complete best12. ;
	format date_visit_6 mmddyy10. ;
	format date_blood_6 mmddyy10. ;
	format alb_6 best12. ;
	format prealb_6 best12. ;
	format creat_6 best12. ;
	format npcr_6 best12. ;
	format chol_6 best12. ;
	format transferrin_6 best12. ;
	format kt_v_6 best12. ;
	format drywt_6 best12. ;
	format plasma1_6 best12. ;
	format plasma2_6 best12. ;
	format plasma3_6 best12. ;
	format serum1_6 best12. ;
	format serum2_6 best12. ;
	format serum3_6 best12. ;
	format sga_6 best12. ;
	format no_show_6 best12. ;
	format compliance_6 best12. ;
	format hospit_6 best12. ;
	format cause_hosp_6 best12. ;
	format admission_date_6 mmddyy10. ;
	format discharge_date_6 mmddyy10. ;
	format discharge_summary_6 best12. ;
	format death_6 best12. ;
	format date_death_6 mmddyy10. ;
	format cause_death_6 best12. ;
	format month_6_complete best12. ;
	format complete_study best12. ;
	format withdraw_date mmddyy10. ;
	format withdraw_reason best12. ;
	format complete_study_date mmddyy10. ;
	format study_comments $20. ;
	format study_completion_complete best12. ;
 
input
		study_id $
		date_enrolled
		first_name $
		last_name $
		address $
		telephone_1 $
		telephone_2 $
		email $
		sex
		race
		dob
		height
		weight
		dry_weight
		comorbidities $
		diabetes
		diabetes_type
		dialysis_initiation
		access_type
		access_location
		dialysis_unit_name $
		dialysis_unit_phone $
		dialysis_schedule_days
		dialysis_schedule_time
		etiology_esrd
		subject_comments $
		subject_complete
		date_visit_b
		date_blood_b
		alb_b
		prealb_b
		creat_b
		npcr_b
		chol_b
		transferrin_b
		kt_v_b
		drywt_b
		plasma1_b
		plasma2_b
		plasma3_b
		serum1_b
		serum2_b
		serum3_b
		sga_b
		date_supplement_dispensed
		baseline_complete
		date_visit_1
		alb_1
		prealb_1
		creat_1
		npcr_1
		chol_1
		transferrin_1
		kt_v_1
		drywt_1
		no_show_1
		compliance_1
		hospit_1
		cause_hosp_1
		admission_date_1
		discharge_date_1
		discharge_summary_1
		death_1
		date_death_1
		cause_death_1
		month_1_complete
		date_visit_2
		alb_2
		prealb_2
		creat_2
		npcr_2
		chol_2
		transferrin_2
		kt_v_2
		drywt_2
		no_show_2
		compliance_2
		hospit_2
		cause_hosp_2
		admission_date_2
		discharge_date_2
		discharge_summary_2
		death_2
		date_death_2
		cause_death_2
		month_2_complete
		date_visit_3
		date_blood_3
		alb_3
		prealb_3
		creat_3
		npcr_3
		chol_3
		transferrin_3
		kt_v_3
		drywt_3
		plasma1_3
		plasma2_3
		plasma3_3
		serum1_3
		serum2_3
		serum3_3
		sga_3
		no_show_3
		compliance_3
		hospit_3
		cause_hosp_3
		admission_date_3
		discharge_date_3
		discharge_summary_3
		death_3
		date_death_3
		cause_death_3
		month_3_complete
		date_visit_4
		alb_4
		prealb_4
		creat_4
		npcr_4
		chol_4
		transferrin_4
		kt_v_4
		drywt_4
		no_show_4
		compliance_4
		hospit_4
		cause_hosp_4
		admission_date_4
		discharge_date_4
		discharge_summary_4
		death_4
		date_death_4
		cause_death_4
		month_4_complete
		date_visit_5
		alb_5
		prealb_5
		creat_5
		npcr_5
		chol_5
		transferrin_5
		kt_v_5
		drywt_5
		no_show_5
		compliance_5
		hospit_5
		cause_hosp_5
		admission_date_5
		discharge_date_5
		discharge_summary_5
		death_5
		date_death_5
		cause_death_5
		month_5_complete
		date_visit_6
		date_blood_6
		alb_6
		prealb_6
		creat_6
		npcr_6
		chol_6
		transferrin_6
		kt_v_6
		drywt_6
		plasma1_6
		plasma2_6
		plasma3_6
		serum1_6
		serum2_6
		serum3_6
		sga_6
		no_show_6
		compliance_6
		hospit_6
		cause_hosp_6
		admission_date_6
		discharge_date_6
		discharge_summary_6
		death_6
		date_death_6
		cause_death_6
		month_6_complete
		complete_study
		withdraw_date
		withdraw_reason
		complete_study_date
		study_comments $
		study_completion_complete
;
if _ERROR_ then call symput('_EFIERR_',1);
run;
 
proc contents;run;
 
 
data mydataset;
	set mydataset;
	label study_id='Assigned ID';
	label date_enrolled='Date subject signed consent';
	label first_name='First Name';
	label last_name='Last Name';
	label address='street, city, state, ZIP';
	label telephone_1='Phone number';
	label telephone_2='Second phone number';
	label email='E-mail';
	label sex='Gender';
	label race='Race';
	label dob='Date of birth';
	label height='Height (cm)';
	label weight='weight (kilograms)';
	label dry_weight='dry weight (kilograms)';
	label comorbidities='Any comorbid condition';
	label diabetes='Patient has a diagnosis of diabetes mellitus?';
	label diabetes_type='Type of Diabetes Mellitus';
	label dialysis_initiation='date of first outpatient dialysis treatment';
	label access_type='Type of vascular access';
	label access_location='Location of currently used vascular access';
	label dialysis_unit_name='Name of dialysis unit';
	label dialysis_unit_phone='Phone number';
	label dialysis_schedule_days='Days of the week patients is dialyzed';
	label dialysis_schedule_time='Shift patient is dialyzed';
	label etiology_esrd='Etiology of ESRD';
	label subject_comments='Comments';
	label subject_complete='Complete?';
	label date_visit_b='Date of baseline visit';
	label date_blood_b='Date blood was drawn';
	label alb_b='Serum Albumin (g/dL)';
	label prealb_b='Serum Prealbumin (mg/dL)';
	label creat_b='Creatinine (mg/dL)';
	label npcr_b='Normalized Protein Catabolic Rate (g/kg/d)';
	label chol_b='Cholesterol (mg/dL)';
	label transferrin_b='Transferrin (mg/dL)';
	label kt_v_b='Kt/V';
	label drywt_b='Dry weight (kilograms)';
	label plasma1_b='Collected Plasma 1?';
	label plasma2_b='Collected Plasma 2?';
	label plasma3_b='Collected Plasma 3?';
	label serum1_b='Collected Serum 1?';
	label serum2_b='Collected Serum 2?';
	label serum3_b='Collected Serum 3?';
	label sga_b='Subject Global Assessment (score = 1-7)';
	label date_supplement_dispensed='Date patient begins supplement';
	label baseline_complete='Complete?';
	label date_visit_1='Date of Month 1 visit';
	label alb_1='Serum Albumin (g/dL)';
	label prealb_1='Serum Prealbumin (mg/dL)';
	label creat_1='Creatinine (mg/dL)';
	label npcr_1='Normalized Protein Catabolic Rate (g/kg/d)';
	label chol_1='Cholesterol (mg/dL)';
	label transferrin_1='Transferrin (mg/dL)';
	label kt_v_1='Kt/V';
	label drywt_1='Dry weight (kilograms)';
	label no_show_1='Number of treatments missed';
	label compliance_1='How compliant was the patient in drinking the supplement?';
	label hospit_1='Was patient hospitalized since last visit?';
	label cause_hosp_1='What was the cause of hospitalization?';
	label admission_date_1='Date of hospital admission';
	label discharge_date_1='Date of hospital discharge';
	label discharge_summary_1='Discharge summary in patients binder?';
	label death_1='Has patient died since last visit?';
	label date_death_1='Date of death';
	label cause_death_1='What was the cause of death?';
	label month_1_complete='Complete?';
	label date_visit_2='Date of Month 2 visit';
	label alb_2='Serum Albumin (g/dL)';
	label prealb_2='Serum Prealbumin (mg/dL)';
	label creat_2='Creatinine (mg/dL)';
	label npcr_2='Normalized Protein Catabolic Rate (g/kg/d)';
	label chol_2='Cholesterol (mg/dL)';
	label transferrin_2='Transferrin (mg/dL)';
	label kt_v_2='Kt/V';
	label drywt_2='Dry weight (kilograms)';
	label no_show_2='Number of treatments missed';
	label compliance_2='How compliant was the patient in drinking the supplement?';
	label hospit_2='Was patient hospitalized since last visit?';
	label cause_hosp_2='What was the cause of hospitalization?';
	label admission_date_2='Date of hospital admission';
	label discharge_date_2='Date of hospital discharge';
	label discharge_summary_2='Discharge summary in patients binder?';
	label death_2='Has patient died since last visit?';
	label date_death_2='Date of death';
	label cause_death_2='What was the cause of death?';
	label month_2_complete='Complete?';
	label date_visit_3='Date of Month 3 visit';
	label date_blood_3='Date blood was drawn';
	label alb_3='Serum Albumin (g/dL)';
	label prealb_3='Serum Prealbumin (mg/dL)';
	label creat_3='Creatinine (mg/dL)';
	label npcr_3='Normalized Protein Catabolic Rate (g/kg/d)';
	label chol_3='Cholesterol (mg/dL)';
	label transferrin_3='Transferrin (mg/dL)';
	label kt_v_3='Kt/V';
	label drywt_3='Dry weight (kilograms)';
	label plasma1_3='Collected Plasma 1?';
	label plasma2_3='Collected Plasma 2?';
	label plasma3_3='Collected Plasma 3?';
	label serum1_3='Collected Serum 1?';
	label serum2_3='Collected Serum 2?';
	label serum3_3='Collected Serum 3?';
	label sga_3='Subject Global Assessment (score = 1-7)';
	label no_show_3='Number of treatments missed';
	label compliance_3='How compliant was the patient in drinking the supplement?';
	label hospit_3='Was patient hospitalized since last visit?';
	label cause_hosp_3='What was the cause of hospitalization?';
	label admission_date_3='Date of hospital admission';
	label discharge_date_3='Date of hospital discharge';
	label discharge_summary_3='Discharge summary in patients binder?';
	label death_3='Has patient died since last visit?';
	label date_death_3='Date of death';
	label cause_death_3='What was the cause of death?';
	label month_3_complete='Complete?';
	label date_visit_4='Date of Month 4 visit';
	label alb_4='Serum Albumin (g/dL)';
	label prealb_4='Serum Prealbumin (mg/dL)';
	label creat_4='Creatinine (mg/dL)';
	label npcr_4='Normalized Protein Catabolic Rate (g/kg/d)';
	label chol_4='Cholesterol (mg/dL)';
	label transferrin_4='Transferrin (mg/dL)';
	label kt_v_4='Kt/V';
	label drywt_4='Dry weight (kilograms)';
	label no_show_4='Number of treatments missed';
	label compliance_4='How compliant was the patient in drinking the supplement?';
	label hospit_4='Was patient hospitalized since last visit?';
	label cause_hosp_4='What was the cause of hospitalization?';
	label admission_date_4='Date of hospital admission';
	label discharge_date_4='Date of hospital discharge';
	label discharge_summary_4='Discharge summary in patients binder?';
	label death_4='Has patient died since last visit?';
	label date_death_4='Date of death';
	label cause_death_4='What was the cause of death?';
	label month_4_complete='Complete?';
	label date_visit_5='Date of Month 5 visit';
	label alb_5='Serum Albumin (g/dL)';
	label prealb_5='Serum Prealbumin (mg/dL)';
	label creat_5='Creatinine (mg/dL)';
	label npcr_5='Normalized Protein Catabolic Rate (g/kg/d)';
	label chol_5='Cholesterol (mg/dL)';
	label transferrin_5='Transferrin (mg/dL)';
	label kt_v_5='Kt/V';
	label drywt_5='Dry weight (kilograms)';
	label no_show_5='Number of treatments missed';
	label compliance_5='How compliant was the patient in drinking the supplement?';
	label hospit_5='Was patient hospitalized since last visit?';
	label cause_hosp_5='What was the cause of hospitalization?';
	label admission_date_5='Date of hospital admission';
	label discharge_date_5='Date of hospital discharge';
	label discharge_summary_5='Discharge summary in patients binder?';
	label death_5='Has patient died since last visit?';
	label date_death_5='Date of death';
	label cause_death_5='What was the cause of death?';
	label month_5_complete='Complete?';
	label date_visit_6='Date of Month 6 visit';
	label date_blood_6='Date blood was drawn';
	label alb_6='Serum Albumin (g/dL)';
	label prealb_6='Serum Prealbumin (mg/dL)';
	label creat_6='Creatinine (mg/dL)';
	label npcr_6='Normalized Protein Catabolic Rate (g/kg/d)';
	label chol_6='Cholesterol (mg/dL)';
	label transferrin_6='Transferrin (mg/dL)';
	label kt_v_6='Kt/V';
	label drywt_6='Dry weight (kilograms)';
	label plasma1_6='Collected Plasma 1?';
	label plasma2_6='Collected Plasma 2?';
	label plasma3_6='Collected Plasma 3?';
	label serum1_6='Collected Serum 1?';
	label serum2_6='Collected Serum 2?';
	label serum3_6='Collected Serum 3?';
	label sga_6='Subject Global Assessment (score = 1-7)';
	label no_show_6='Number of treatments missed';
	label compliance_6='How compliant was the patient in drinking the supplement?';
	label hospit_6='Was patient hospitalized since last visit?';
	label cause_hosp_6='What was the cause of hospitalization?';
	label admission_date_6='Date of hospital admission';
	label discharge_date_6='Date of hospital discharge';
	label discharge_summary_6='Discharge summary in patients binder?';
	label death_6='Has patient died since last visit?';
	label date_death_6='Date of death';
	label cause_death_6='What was the cause of death?';
	label month_6_complete='Complete?';
	label complete_study='Has patient completed study?';
	label withdraw_date='Put a date if patient withdrew study';
	label withdraw_reason='Reason patient withdrew from study';
	label complete_study_date='Date of study completion';
	label study_comments='Comments';
	label study_completion_complete='Complete?';
	run;
 
proc format;
	value sex_ 0='Female' 1='Male';
	value race_ 0='Caucasian' 1='African American' 2='Hispanic' 3='Asian' 4='Other';
	value diabetes_ 0='No' 1='Yes';
	value diabetes_type_ 0='Type 1 insulin-dependent' 1='Type 2 insulin-dependent' 2='Type 2 non insulin-dependent';
	value access_type_ 0='Graft' 1='Fistula' 2='Catheter with maturing graft' 3='Catheter with maturing fistula';
	value access_location_ 0='Forearm' 1='Upper arm' 2='Internal jugular vein' 3='Subclavian vein' 4='Other';
	value dialysis_schedule_days_ 0='Monday-Wednesday-Friday' 1='Tuesday-Thursday-Saturday' 2='Other';
	value dialysis_schedule_time_ 0='First shift' 1='Second shift' 2='Third shift' 3='Fourth shift';
	value etiology_esrd_ 0='Diabetes' 1='Hypertension' 2='Glomerulonephritis' 3='Polycystic Kidney Disease' 4='Interstitial Nephritis' 5='Hereditary Nephritis' 6='Other';
	value subject_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	value plasma1_b_ 0='No' 1='Yes';
	value plasma2_b_ 0='No' 1='Yes';
	value plasma3_b_ 0='No' 1='Yes';
	value serum1_b_ 0='No' 1='Yes';
	value serum2_b_ 0='No' 1='Yes';
	value serum3_b_ 0='No' 1='Yes';
	value baseline_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	value compliance_1_ 0='100 percent' 1='99-75 percent' 2='74-50 percent' 3='49-25 percent' 4='0-24 percent';
	value hospit_1_ 0='No' 1='Yes';
	value cause_hosp_1_ 1='Vascular access related events' 2='CVD events' 3='Other';
	value discharge_summary_1_ 0='No' 1='Yes';
	value death_1_ 0='No' 1='Yes';
	value cause_death_1_ 1='All-cause' 2='Cardiovascular';
	value month_1_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	value compliance_2_ 0='100 percent' 1='99-75 percent' 2='74-50 percent' 3='49-25 percent' 4='0-24 percent';
	value hospit_2_ 0='No' 1='Yes';
	value cause_hosp_2_ 1='Vascular access related events' 2='CVD events' 3='Other';
	value discharge_summary_2_ 0='No' 1='Yes';
	value death_2_ 0='No' 1='Yes';
	value cause_death_2_ 1='All-cause' 2='Cardiovascular';
	value month_2_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	value plasma1_3_ 0='No' 1='Yes';
	value plasma2_3_ 0='No' 1='Yes';
	value plasma3_3_ 0='No' 1='Yes';
	value serum1_3_ 0='No' 1='Yes';
	value serum2_3_ 0='No' 1='Yes';
	value serum3_3_ 0='No' 1='Yes';
	value compliance_3_ 0='100 percent' 1='99-75 percent' 2='74-50 percent' 3='49-25 percent' 4='0-24 percent';
	value hospit_3_ 0='No' 1='Yes';
	value cause_hosp_3_ 1='Vascular access related events' 2='CVD events' 3='Other';
	value discharge_summary_3_ 0='No' 1='Yes';
	value death_3_ 0='No' 1='Yes';
	value cause_death_3_ 1='All-cause' 2='Cardiovascular';
	value month_3_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	value compliance_4_ 0='100 percent' 1='99-75 percent' 2='74-50 percent' 3='49-25 percent' 4='0-24 percent';
	value hospit_4_ 0='No' 1='Yes';
	value cause_hosp_4_ 1='Vascular access related events' 2='CVD events' 3='Other';
	value discharge_summary_4_ 0='No' 1='Yes';
	value death_4_ 0='No' 1='Yes';
	value cause_death_4_ 1='All-cause' 2='Cardiovascular';
	value month_4_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	value compliance_5_ 0='100 percent' 1='99-75 percent' 2='74-50 percent' 3='49-25 percent' 4='0-24 percent';
	value hospit_5_ 0='No' 1='Yes';
	value cause_hosp_5_ 1='Vascular access related events' 2='CVD events' 3='Other';
	value discharge_summary_5_ 0='No' 1='Yes';
	value death_5_ 0='No' 1='Yes';
	value cause_death_5_ 1='All-cause' 2='Cardiovascular';
	value month_5_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	value plasma1_6_ 0='No' 1='Yes';
	value plasma2_6_ 0='No' 1='Yes';
	value plasma3_6_ 0='No' 1='Yes';
	value serum1_6_ 0='No' 1='Yes';
	value serum2_6_ 0='No' 1='Yes';
	value serum3_6_ 0='No' 1='Yes';
	value compliance_6_ 0='100 percent' 1='99-75 percent' 2='74-50 percent' 3='49-25 percent' 4='0-24 percent';
	value hospit_6_ 0='No' 1='Yes';
	value cause_hosp_6_ 1='Vascular access related events' 2='CVD events' 3='Other';
	value discharge_summary_6_ 0='No' 1='Yes';
	value death_6_ 0='No' 1='Yes';
	value cause_death_6_ 1='All-cause' 2='Cardiovascular';
	value month_6_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	value complete_study_ 0='No' 1='Yes';
	value withdraw_reason_ 0='Non-compliance' 1='Did not wish to continue in study' 2='Could not tolerate the supplement' 3='Hospitalization' 4='Other';
	value study_completion_complete_ 0='Incomplete' 1='Unverified' 2='Complete';
	run;
 
data gcrc;
	set gcrc;
 
	format sex sex_.;
	format race race_.;
	format diabetes diabetes_.;
	format diabetes_type diabetes_type_.;
	format access_type access_type_.;
	format access_location access_location_.;
	format dialysis_schedule_days dialysis_schedule_days_.;
	format dialysis_schedule_time dialysis_schedule_time_.;
	format etiology_esrd etiology_esrd_.;
	format subject_complete subject_complete_.;
	format plasma1_b plasma1_b_.;
	format plasma2_b plasma2_b_.;
	format plasma3_b plasma3_b_.;
	format serum1_b serum1_b_.;
	format serum2_b serum2_b_.;
	format serum3_b serum3_b_.;
	format baseline_complete baseline_complete_.;
	format compliance_1 compliance_1_.;
	format hospit_1 hospit_1_.;
	format cause_hosp_1 cause_hosp_1_.;
	format discharge_summary_1 discharge_summary_1_.;
	format death_1 death_1_.;
	format cause_death_1 cause_death_1_.;
	format month_1_complete month_1_complete_.;
	format compliance_2 compliance_2_.;
	format hospit_2 hospit_2_.;
	format cause_hosp_2 cause_hosp_2_.;
	format discharge_summary_2 discharge_summary_2_.;
	format death_2 death_2_.;
	format cause_death_2 cause_death_2_.;
	format month_2_complete month_2_complete_.;
	format plasma1_3 plasma1_3_.;
	format plasma2_3 plasma2_3_.;
	format plasma3_3 plasma3_3_.;
	format serum1_3 serum1_3_.;
	format serum2_3 serum2_3_.;
	format serum3_3 serum3_3_.;
	format compliance_3 compliance_3_.;
	format hospit_3 hospit_3_.;
	format cause_hosp_3 cause_hosp_3_.;
	format discharge_summary_3 discharge_summary_3_.;
	format death_3 death_3_.;
	format cause_death_3 cause_death_3_.;
	format month_3_complete month_3_complete_.;
	format compliance_4 compliance_4_.;
	format hospit_4 hospit_4_.;
	format cause_hosp_4 cause_hosp_4_.;
	format discharge_summary_4 discharge_summary_4_.;
	format death_4 death_4_.;
	format cause_death_4 cause_death_4_.;
	format month_4_complete month_4_complete_.;
	format compliance_5 compliance_5_.;
	format hospit_5 hospit_5_.;
	format cause_hosp_5 cause_hosp_5_.;
	format discharge_summary_5 discharge_summary_5_.;
	format death_5 death_5_.;
	format cause_death_5 cause_death_5_.;
	format month_5_complete month_5_complete_.;
	format plasma1_6 plasma1_6_.;
	format plasma2_6 plasma2_6_.;
	format plasma3_6 plasma3_6_.;
	format serum1_6 serum1_6_.;
	format serum2_6 serum2_6_.;
	format serum3_6 serum3_6_.;
	format compliance_6 compliance_6_.;
	format hospit_6 hospit_6_.;
	format cause_hosp_6 cause_hosp_6_.;
	format discharge_summary_6 discharge_summary_6_.;
	format death_6 death_6_.;
	format cause_death_6 cause_death_6_.;
	format month_6_complete month_6_complete_.;
	format complete_study complete_study_.;
	format withdraw_reason withdraw_reason_.;
	format study_completion_complete study_completion_complete_.;
	run;
 
proc contents data=mydataset;
proc print data=mydataset;
run;
quit;
           
         

Open in New Window

04.29.2008 at 10:32AM PDT, ID: 21464329

bradanelson:

The double quotes I put in the 1st example were not a suggestion, but a requirement. SAS will not look inside of single quotes for MACRO's or GLOBAL variables. Try replacing

infile '%PATH\DATA_EXPORT_2008-04-29' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ;

with

infile "%PATH\DATA_EXPORT_2008-04-29" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ;

Let me know if this helps.

Thanks

04.29.2008 at 10:52AM PDT, ID: 21464480

sah18:

Ahh, I looked right past the single quotes/double quotes difference when editing.
I re-ran it just now and it ran perfectly.

My original question still remains, though, why is this change not necessary on other people's computers (they do not get the error I get when running this same file), but it is on mine?

It seems there is something particular to my install of SAS that is different??

My issue is that this is not a one-time thing. I will have many, many different export files -- and should not really require editing of the file that is provided by the application (of each one of them -- hundreds). The syntax for the file works as is for others. Why doesn't it work for me?

04.29.2008 at 10:57AM PDT, ID: 21464527

bradanelson:

It has to do with the SAS CURRENT FOLDER setting. If you open sas on your machine, look at the bottom right/center of your screen and is should show you where it is currently pointing. You can double click it and change it, but when you close that session, the change is gone. The article above describes how this may change depending on your settings and if you open through command line, shortcuts, Start->Programs, etc. I belive you can change this in your .cfg file as well.

04.29.2008 at 11:11AM PDT, ID: 21464640

sah18:

Thank you for all your assistance!

20080236-EE-VQP-29 / EE_QW_2_20070628