topic Re: SAS SPD engine problem & mdf files are not generated well. in New SAS User

SAS SPD engine problem & mdf files are not generated well.

maheshsompalli — Thu, 29 Nov 2018 19:28:13 GMT

I had a problem with running a program creating spds9 files, I am using libname for assigning the locations of store files and i encountered the data files dpf are generating good , but with metadata files mdf. the data supposed to produce 14MB of data its producing just the 620KB of data no any errors in the program and dpf files it is creating are good, Can anyone help me in resolving this issue.

I have checked the code and every thing is well and good

Re: SAS SPD engine problem & mdf files are not generated well.

Lakker — Thu, 29 Nov 2018 21:03:49 GMT

Hi,

Is this related to %let SPDSSIZE=14 ?

Re: SAS SPD engine problem & mdf files are not generated well.

maheshsompalli — Thu, 29 Nov 2018 22:02:57 GMT

The data is produces is not accurate it is generating data no any sizing problems but, mdf files are not genrated correctly, right side of image is previous run data and now I am running it again in different environment.

left side data is my current run

Re: SAS SPD engine problem & mdf files are not generated well.

LinusH — Fri, 30 Nov 2018 14:01:08 GMT

I don't follow you, are you comparing dpf and mdf file sizes?

If so, you have misunderstood the role of these file types.

If the program executed without warnings or errors, why do think it's wrong?

Does the data look corrupt?

Re: SAS SPD engine problem & mdf files are not generated well.

maheshsompalli — Fri, 30 Nov 2018 16:49:30 GMT

that is my problem in previous run these mdf files has generated offset-E841A0 number of rows

but now it is only generating offset-99560 number of rows. I know program is running with out any warning or errors, but missing data in the mdf files.

But DPF files has matching rows. That's were it is getting really weird.

normally the program should execute for 6 hours now it is completes it run in 1 hour.

Re: SAS SPD engine problem & mdf files are not generated well.

LinusH — Sat, 01 Dec 2018 07:18:43 GMT

Still not understand. Mdf files doesn't hold any rows at all, it's just meta data.
Why are you looking at the physical files at all?
Start your anslysis by looking at the data from a SAS session using SPDE libname.

Re: SAS SPD engine problem & mdf files are not generated well.

maggiem_sas — Mon, 10 Dec 2018 16:13:56 GMT

You said you are running in a different environment. Can you give more details about that change? Are you running the code in a different environment? Or did you modify the LIBNAME statement to store the table in a different environment? (Or both?)

If you added a new path in the DATAPATH, then the .mdf and existing .dpf files might still be located on the the old environment.

See the current documentation.