About bayzid

bayzid · ‎05-12-2023

How can I generate another variable that contains the specific keyword as below?

bayzid · ‎05-12-2023

Thanks very much.

bayzid · ‎05-12-2023

I have a very long character variable and want to create a binary variable 0/1 if any of the specific words is found. As shown in the following figure, I have the Diagnosis variable and want to create the Hypertension variable if the former contains any of he words in red font.

bayzid · ‎05-10-2023

I am using the following code but still the same result. proc freq data=sas.dosemed_all; tables ScheduleType/list all format=comma14.; run;

bayzid · ‎05-09-2023

I have a very large number in a frequency table which SAS is abbreviating in the output as below. How can i get SAS to report all the digits?

bayzid · ‎05-08-2023

Sorry- I am still not clear about it. An example would have been great.

bayzid · ‎05-03-2023

Yes- that worked.

bayzid · ‎05-03-2023

Yes- that worked. After compressing the size is smaller than the original dataset. Is there any way to include the compress option in the macro so that it doesn't require an additional data step?

bayzid · ‎05-03-2023

Hi Ahmed, Thanks for the macro. It worked to reduce the variable length but the size of the dataset has been inflated >4 times.

bayzid · ‎05-03-2023

Yes- I want to do that for both numeric and character variables. Some of the variables have greater length than maximum length. Using COMPRESS option in the dataset can reduce the size but do not change the variable length which creates an inflated dataset when transformed to other formats.

bayzid · ‎05-03-2023

How can i find out maximum length of all the variables in a SAS dataset and then use those lengths to create a new dataset?

bayzid · ‎05-01-2023

Thanks Tom. Much appreciated.

bayzid · ‎04-30-2023

The code worked fine for an individual file. I am running multiple macros for importing all the files in group using the following syntax. Can you please suggest where the map information should go? libname test JSON "C:\Users\mq10004085\Macquarie University\MRFF Aged care Data - Documents\JSON_1st_02032023\&&file&i...json" ORDINALCOUNT= NONE ;*NOALLDATA; data sas.&&ds&i ; /*Creating tables in the Work library instead of the samt lib*/ set test.Root; dataname="&&file&i"; /*Variable containing the json file names*/ run;

bayzid · ‎04-29-2023

Would that create a problem in the process?

bayzid · ‎04-28-2023

I have 23 types JSON file with same structure but different variables. Attached 3 types of file.

Online Status	Offline
Date Last Visited	‎06-26-2023 12:25 PM

Re: Adding a trailing space to a character variable

Re: Adding a trailing space to a character variable

Re: Adding a trailing space to a character variable

Re: Adding a trailing space to a character variable

Adding a trailing space to a character variable

Re: Viewing SAS data table

Re: Viewing SAS data table

Re: prxparse function

Re: prxparse function

prxparse function

Re: Viewing SAS data table

Re: finding word to create new variable

Re: finding word to create new variable

finding word to create new variable

Re: Reporting large numbers

Reporting large numbers

Re: Running Stata from within SAS

Re: Maximum lenght of variables

Re: Maximum lenght of variables

Re: Maximum lenght of variables

Re: Maximum lenght of variables

Maximum lenght of variables

Re: Reading data from JSON as charcater

Re: Reading data from JSON as charcater

Re: Reading data from JSON as charcater

Re: Reading data from JSON as charcater