Please fix the names in the target dataset, a dataset can't have multiple variable with the same name. And while you are at it, fill the result table with the values from "have"-dataset and post the code you are using to transpose. ... View more

Please post data in usable form, a dataset like x y z w q A 1 2 3 4 5 B 6 7 8 9 10 C 11 12 13 14 D 15 16 17 18 E 19 20 21 22 23 can't exist, because every variable / column needs a name. Where do the numbers 101 and 202 come from? Please show the complete result you expect and explain the logic to be applied. ... View more

I would not like to rely on third-party-tools that may or may not be able to read datasets. Before moving away from SAS - a strange idea - i would save all dataset to a database, if the required access module is licensed. If not, exporting to json is possible, if you have a recent release of sas. Or, as export to csv along with proc contents of the dataset. ... View more

@GN0001 wrote: Hello team, I have a variable as date numeric as mm/did/yyyy. I want to use it in a where clause: where dob= 12/10/2021; SAS ignores it and returns other dates in the result, how can I fix this issue? Blueblue 12/10/2021 is not numeric, but a string EDIT: not a string, of course, if there are not quotes, but an expression, as Kurt already pointed out so what do you have in dob? If it is not a sas-date, fix this issue first. ... View more

Each observation has over 100 variables. So all variables will hardly fit on a page even after reducing font-size to be hardly readable at all and using landscape-layout. So the question is: Are the clients aware that they want something as useful as a bottle of Tabasco sauce in the desert? ... View more

Instead of re-Arranging the data, you should go back some steps an investigate how the dataset you have now was created, maybe intercepting in the process at an earlier stage makes it easier to solve the task. ... View more

Please open the csv-file with a text editor, like notepad++. If excel shows formatting not meeting your expectations, than most likely excel applied one of its fantastic optimizations. ... View more

Does not happen: data narf; set sashelp.class; Weight = Weight * 12345.67; run; proc export data=narf dbms=dlm outfile="export_sep_test.csv" replace; delimiter=';'; run; So please, run proc contents on the dataset and post the result. ... View more