topic Re: How to import Universally Unique Identifier from a text file with '|' delimiter in SAS Programming

How to import Universally Unique Identifier from a text file with '|' delimiter

anavipalmaescob — Sat, 28 Sep 2024 07:27:19 GMT

Hello!

I am trying to import the UUI from my text data set, with no success, here are the first lines of the code

data imported_data;

infile 'your_file_path.txt' delimiter='|' dsd firstobs=2 truncover;

length patient_id $ 36 center_id $ 10 provider_id $ 36 diagnosis_1_icd9 $ 10 diagnosis_2_icd9 $ 10;

input patient_id $

center_id $

provider_id $

diagnosis_1_icd9 $

diagnosis_2_icd9 $

diagnosis_3_icd9 $

diagnosis_4_icd9 $

diagnosis_5_icd9 $

Re: How to import Universally Unique Identifier from a text file with '|' delimiter

Kurt_Bremser — Sat, 28 Sep 2024 14:22:56 GMT

Please show the complete log (all code and messages) from the step by copy/pasting the text into a window opened with the </> button.

Re: How to import Universally Unique Identifier from a text file with '|' delimiter

ballardw — Sat, 28 Sep 2024 14:42:20 GMT

Please always discuss things in terms of the variables used in the code. You ask about UUID but your code does not show any such named variable.

Describe what the actual problem is as we do not have your file to read.

Or share the first 5 lines of the data set by copy and paste into a text box opened on the forum with the </> icon that appears above the message box.

Always include a complete data step or procedure code. What you show is incomplete so we don't know what else you may be attempting that might not work.

Best is to copy from the LOG the text of the code and all the messages generated by the code and paste the copied text into a text box.