DATA Step, Macro, Functions and more

CSV Import - How do I import a file called project.csv?

Reply
Frequent Contributor
Posts: 128

CSV Import - How do I import a file called project.csv?

 000001 //CLMIDS  JOB (F0000000,44785,xxxxxxx,A2D),'x.xxxxx',                   
 000002 //         CLASS=1,MSGCLASS=X,REGION=8M,TIME=NOLIMIT,                   
 000003 //         RESTART=JS010.SAS,                                           
 000004 //         NOTIFY=xxxxxxx
 000005 //JS010    EXEC SAS,WORK='130000,130000',PARM=CAPSOUT                   
 000006 //*                                                                     
 000007 //INST   DD DSN=xxxxxxxxx.WRKLIB1.INST.CLMIDS.SASS,DISP=SHR               
 000008 //*                                                                     
 000009 //SYSIN    DD *                                                         
 000010 ********************************************************************;   
 000011   OPTIONS NODATE LS=132 OBS=MAX SORT=2430 SORTPGM=BEST                  
 000012           PS=59 NOBYLINE YEARCUTOFF=1920;                               
 000013                                                                         
 000014      **IMPORT RECOUPEMENTPROJECT EXCEL FILE**                          
 000015                                                                        
 000016                                                                       
 000017                                                                       
 000018                                                                       
 000019                                                                        
 000020                                                                        
 000021                                                                      
 000022                                                                        
 000023                                                                       
 000024                                                                         
 000025      **EXTRACT FROM CLAIMS WAREHOUSE - INST**                           
Regular Contributor
Posts: 162

Re: CSV Import - How do I import a file called project.csv?

file - > import data, and then follow the instructions. Save the code, and then you can rerun it or modify it.

--------------
blog: papersandprograms.com
Frequent Contributor
Posts: 128

Re: CSV Import - How do I import a file called project.csv?

Posted in reply to PaulBrownPhD

no, this is the SAS mainframe that uses JCL

Frequent Contributor
Posts: 128

Re: CSV Import - How do I import a file called project.csv?

Posted in reply to PaulBrownPhD

never mind, im supposed to do an FTP transfer first

Ask a Question
Discussion stats
  • 3 replies
  • 43 views
  • 0 likes
  • 2 in conversation