About Pandu2

Pandu2 · ‎12-03-2021

I posted the data which has one column and I need the final dataset which should have 3 columns

Pandu2 · ‎12-03-2021

Didn't I say it's not in my control. It was on the server side I've got no access for that

Pandu2 · ‎12-03-2021

Wrong type it's dsd.

Pandu2 · ‎12-03-2021

Sure, Data work.want Infile srct dad lrecl=30000000 dlm ='[{}}'; Input js : $2000.@@; do i =1 to countw(js, ' , '); name =scan(js,i, ' , '); Output; end; drop js i ; run; So, it creates a temp dataset and has multiple observations but I kept few only. Please have a look at the data which I posted above.

Pandu2 · ‎12-03-2021

I've got that file which I've no control over it as it is from servers.

Pandu2 · ‎12-03-2021

I tried using infile statement but in the end the dataset seemed blank nd also the length of the character supposed to 50

Pandu2 · ‎12-03-2021

Those values must be character like 123,abc23 etc. And also 1through 6 are serial numbers

Pandu2 · ‎12-03-2021

Exactly but quite few changes are required in your code and output dataset please remove the name variable and also xyz,gef, rod column values must be taken from a dataset instead of entering manually cuz they're multiple records which are repeated

Pandu2 · ‎12-03-2021

I do care about them as they must act as a columns in a dataset

Pandu2 · ‎12-03-2021

Hi all, I've a temp dataset whose structure is like below sno name. 1 "Xyz":"123" 2 "gef":"abc23" 3 "rod":"124899" 4. "Xyz":"567" 5. "gef":"ijk67" 6. "rod":"800775" Likewise it has multiple records which are repeated what I would like to do is dequote each name variable value and put it as a separate variable, value to create a dataset which is like this Sno Xyz gef rod 1 123 abc23 124899 2 567 ijk67 800775 Does anyone help me out on how to do this. Any help would be greatly appreciated.

Pandu2 · ‎11-23-2021

Pardon me, I just posted the real json data.

Pandu2 · ‎11-23-2021

I'm a beginner who's learning from experts advise. And also your code has given an error: The ID value "PN" occurs twice in the input data.

Pandu2 · ‎11-23-2021

I can possibly do that but your code didn't give any values the table is empty.

Pandu2 · ‎11-23-2021

I believe for every ID & UN & Dep it has corresponding multiple records of PN & TY & EDUTC but your code just gave a single record of PN&TY&EDUTC for each ID & UN & Dep though it has multiple records.

Pandu2 · ‎11-23-2021

Thanks for your help but it created have and _have columns and it has the values but I require like below table ID | UN | PN | Dep | EDUTC | TY | . . . . . . . . . . . . Likewise I would like to have the table and also in EDUTC I just need only date excluding everything after T. Could you please able to figure out it. Thankyou

Online Status	Offline
Date Last Visited	‎02-21-2024 04:04 AM

AUTOMATING LOGIN AND DOWNLOAD PROCESS USING SAS

Re: Drill down cells

Re: Drill down cells

Re: Drill down cells

Re: Drill down cells

Re: Drill down cells

Re: Drill down cells

Re: Drill down cells

Re: Drill down cells

Re: Drill down cells

Re: Finding occurred value

Re: Date in macro variables

Query builder in sas

Re: How to dequote a value

Re: How to dequote a value

Re: How to dequote a value

Re: How to dequote a value

Re: How to dequote a value

Re: How to dequote a value

Re: How to dequote a value

Re: How to dequote a value

Re: How to dequote a value

How to dequote a value

Re: Parse Json to SAS table

Re: Parse Json to SAS table

Re: Json

Re: Parse Json to SAS table

Re: Parse Json to SAS table