cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
guillaume_bs
‎10-13-2021
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Apply Format before exporting to sas7bdat

by Calcite | Level 5 in SAS Programming
‎09-30-2021 11:48 AM
‎09-30-2021 11:48 AM
Thanks a lot Kurt. Yes applying the put(...) function to the data to get the format applied & stored in the data itself produces the expected result indeed. I was wondering if there was a way to avoid doing it explicitly and just dump the data with all columns replaced with their "formatted equivalent". If there is no way to do that I'll use the explicit put(...) to create new, formatted columns as you suggest. Thanks for your help ! ... View more

Re: Apply Format before exporting to sas7bdat

by Calcite | Level 5 in SAS Programming
‎09-29-2021 08:42 AM
‎09-29-2021 08:42 AM
Thanks Kurt ! Yes the situation you describe is exactly what I am facing. Right now, most of the time, the datasets passed don't have any format applied, so there is no loss in the sas7bdat file and it works fine. Some times, there was a format applied and it gets lost when only the sas7bdat file is used. My question (it is probably a dumb SAS question) would be : when exporting the file, what should be done to apply the format ? (so the sas7bdat file contains the well-formated data and the sas7bdat file is basically empty) ... View more

Re: Apply Format before exporting to sas7bdat

by Calcite | Level 5 in SAS Programming
‎09-29-2021 07:50 AM
‎09-29-2021 07:50 AM
Thanks Shmuel for your message. I use the pyreadstat library (wrapping the readstat C library). I know it can read data and catalog simultaneously, to apply the catalog, as stated here : https://github.com/Roche/pyreadstat#reading-value-labels with the function pyreadstat.read_sas7bdat('data.sas7bdat', catalog_file='catalog.sas7bcat', ...) My problem is that I can only bring the sas7bdat file to this function and my pipeline doesn't allow me to get any sas7bcat file. So the formating should be applied when generating the sas7bdat file. I hope my question is clearer with these details, Thanks !! ... View more

Apply Format before exporting to sas7bdat

by Calcite | Level 5 in SAS Programming
‎09-29-2021 06:10 AM
‎09-29-2021 06:10 AM
Hi everyone,   I have a python script that needs to read data, and, for some reason (related to our python pipeline) we have to read a single file. When exporting SAS data containing formats with labels, two files are exported (sas7bdat for the data without applying the labels, sas7bcat for the catalog containing the labels).   I would like to export the sas7bdat file with the data containing the labels applied ; could you please help me with the correct approach for this ? (I really couldn't find a clear answer ; seems that put(data_column, $format_name) does it for one column but I would like a synthetic way to get this done in one shot on all columns at the export).   Many thanks !! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-13-2021 09:30 AM
Quick links