topic Re: customizing format of some variables when importing CSV file inside PROC IMPORT in SAS Programming

customizing format of some variables when importing CSV file inside PROC IMPORT

fatemeh — Wed, 06 Jan 2021 06:34:29 GMT

Hello,

How to customize format of some variables when importing CSV file inside PROC IMPORT ? Appreciate for any help.

Re: customizing format of some variables when importing CSV file inside PROC IMPORT

Shmuel — Wed, 06 Jan 2021 06:43:40 GMT

Proc Import can't guarantee weather a numeric variable will be assigned as a num type or char type. That is probably the reason it does not contain a format statement.

After importing the dataset you should check the variables weather they were assigned the right type. Then you can use proc datasets or a data step to assign the wanted formats.

Re: customizing format of some variables when importing CSV file inside PROC IMPORT

Kurt_Bremser — Wed, 06 Jan 2021 09:22:14 GMT

Do not use PROC IMPORT, write the data step yourself. Or run IMPORT once, copy the data step from the log, and adapt it to your needs.

Re: customizing format of some variables when importing CSV file inside PROC IMPORT

Reeza — Wed, 06 Jan 2021 17:14:49 GMT

You cannot do that within PROC IMPORT.

However, once you run PROC IMPORT check your log, it will have the generated code including the types. Copy and paste that into your editor and then modify it as necessary.

If you're using traditional SAS (Display Manager) you can copy the code from the log without the line numbers by holding down ALT+SHIFT (I think) while selecting with the cursor. Or I strip the line numbers in NotePad++

Re: customizing format of some variables when importing CSV file inside PROC IMPORT

ballardw — Wed, 06 Jan 2021 17:46:37 GMT

@Reeza wrote:

You cannot do that within PROC IMPORT.

However, once you run PROC IMPORT check your log, it will have the generated code including the types. Copy and paste that into your editor and then modify it as necessary.

If you're using traditional SAS (Display Manager) you can copy the code from the log without the line numbers by holding down ALT+SHIFT (I think) while selecting with the cursor. Or I strip the line numbers in NotePad++

Or, again in the Display manager enhanced editor, immediately after running the proc import press the F4 key. By default this is set to "recall" last code submitted into the editor. In this case, the "last code" is that generated by Proc Import. The result will be at the top of the editor window and will likely need to be moved in the program flow.