About sg_kr

sg_kr · ‎02-22-2024

we deleted the data based on the if condition and we want those deleted data into another dataset

sg_kr · ‎02-22-2024

absoultely agree!! those values doesnt have any sense. but we need to check what all the data we deleted and thats the reason we want them in another dataset can you make clear on how to use retain here? thank again!!

sg_kr · ‎02-22-2024

Thanks Tom for the resolution. Any chance , can we get the deleted items to another dataset . like test data should have all the account numbers data and another dataset to have data which are deleted in the if statement if (account_no in (' ','account no','*****************') then delete; when i use output, im able to get them but my test data is empty.

sg_kr · ‎02-13-2024

Thanks for your response! I tried to Execute it but unfortunately i encountered an error like below also there is an date column included inthe file as well An error occurred executing the workspace job "Sample Data". Integration technologies failed to submit the code. [Error] Failed to transcode data from U_UTF8_CE to U_LATIN1_CE encoding because it contained characters which are not supported by your SAS session encoding. Please review your encoding= and locale= SAS system options to ensure that they can accommodate the data that you want to process. A portion of the source string, in hex representation is: [None] 7305623f3a4: 3b 2a 27 3b 2a 22 3b 2a 2f 3b 71 75 69 74 3b 72 *:***/,quit;rl [None] 7305623f3b4: 75 6e 3b 0d 0a 4f 50 54 49 4f 4e 53 20 50 41 47 |un;..OPTIONS PAGI [Error] Some code points did not transcode.

sg_kr · ‎02-13-2024

Hi, I'm trying to import a text file which is unstructured like header at the top and then column names. i want the dataset with column names listed below account no in-date in-Time balance type code ref party i have attached sample input file and also attached the desired output file as well kindly please help me on this

sg_kr · ‎02-13-2024

thanks for the response, just want to know about the two input statements in the data step. and how to deal if my columns names are two words like account no, instead of accountno

sg_kr · ‎02-12-2024

Hi , i have to read an unstructured data from a text file to SAS dataset raw data like below: Description AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA assakndsklfdsfpsdskmcs'kfdskfnsd'vkmsdv;ls vlksnfdks'fjdsoifnsonvs;lnsohfsnskjfhso;fskfjslfks';fljslkfjs;lfjslkfj;lksfjslkfjos;kufoeisocnds;ojvnoriecnwiocns fhdsiupfhwfnsdpcmdwpofwecmsd'lkvnpsfmspcns[oijsncspncdsvnsnccd accountno date current_balance credit debit total_bal ********************************************************* 1111 01/02/2000 100 20 40 80 2222 01/02/2000 10 20 30 0 2222 02/02/2000 40 10 2 48 accountno date current_balance credit debit total_bal ********************************************************* 1111 01/02/2000 100 20 40 80 2222 01/02/2000 10 20 30 0 222202/02/20004010248 accountno date current_balance credit debit total_bal ********************************************************* 1111 01/02/2000 100 20 40 80 2222 01/02/2000 10 20 30 0 222202/02/20004010248 accountno date current_balance credit debit total_bal ********************************************************* 1111 01/02/2000 100 20 40 80 2222 01/02/2000 10 20 30 0 222202/02/20004010248 Output--- i want dataset to be with the following columns accountno date current_balance credit debit total_bal kindly please help us on this also i have attached the file as well

sg_kr · ‎09-01-2020

its executing without syntax error. but logically not correct. here is the log. 397 %let Daily_Dm_Load_Date =%SYSFUNC(INTNX(day,%SYSFUNC(TODAY())-7,0),date9.); 398 %let ds_dt =%SYSFUNC(INTNX(day,%SYSFUNC(TODAY()),0),date9.); 399 LIBNAME DM "/SASEBI/OPS/data/CS Dashboard"; NOTE: Libref DM was successfully assigned as follows: Engine: V9 Physical Name: ***************** 400 %put &Daily_Dm_Load_Date; SYMBOLGEN: Macro variable DAILY_DM_LOAD_DATE resolves to 25AUG2020 25AUG2020 401 %put &ds_dt.; SYMBOLGEN: Macro variable DS_DT resolves to 01SEP2020 01SEP2020 402 403 LIBNAME DM "***********************"; NOTE: Libref DM was successfully assigned as follows: Engine: V9 Physical Name: *************** 404 Proc sql; 405 select distinct dm_load_date into: CS_ds_DMdates1 separated by ' ' from 405! DM.CS_90DAY_DETAILS; 406 quit; NOTE: The PROCEDURE SQL printed page 18. NOTE: PROCEDURE SQL used (Total process time): real time 33.66 seconds cpu time 8.19 seconds SYMBOLGEN: Macro variable CS_DS_DMDATES1 resolves to 25AUG2020 30AUG2020 407 %put &CS_ds_DMdates1; 25AUG2020 30AUG2020 408 409 options mprint; 410 %macro Appnd ; 411 LIBNAME DM ***************; 412 options mprint mlogic symbolgen compress=yes; 413 414 /* */ 415 %if ( &Daily_Dm_Load_Date ne &CS_ds_DMdates1.) %then %do; 416 417 %put "it is not in the list"; 418 %end; 419 420 %else %do; 421 422 %put "it is in the list"; 423 %end; 424 %mend ; 425 %appnd; MLOGIC(APPND): Beginning execution. MPRINT(APPND): options mprint mlogic symbolgen compress=yes; SYMBOLGEN: Macro variable DAILY_DM_LOAD_DATE resolves to 25AUG2020 SYMBOLGEN: Macro variable CS_DS_DMDATES1 resolves to 25AUG2020 30AUG2020 MLOGIC(APPND): %IF condition ( &Daily_Dm_Load_Date ne &CS_ds_DMdates1.) is TRUE MLOGIC(APPND): %PUT "it is not in the list" "it is not in the list" MLOGIC(APPND): Ending execution. NOTE: Remote submit to GRID complete. NOTE: Remote submit to SSASGRS complete.

sg_kr · ‎09-01-2020

Hi Team, i have an issue here in looking for a date variable in list of date variables in sas. i need to run a code based on condition. %let Daily_Dm_Load_Date =%SYSFUNC(INTNX(day,%SYSFUNC(TODAY())-1,0),date9.); %let ds_dt =%SYSFUNC(INTNX(day,%SYSFUNC(TODAY()),0),date9.); %put &Daily_Dm_Load_Date(1Sep2020); %put &ds_dt.; Proc sql; select distinct(dm_load_date) format date9. into: CS_ds_DMdates SEPARATED BY "," from DM.CS_90DAY_DETAILS; quit; %put &CS_ds_DMdates.(25Aug2020,31Aug2020); %macro Appnd ; options mprint mlogic symbolgen compress=yes; /*delete and replacing Old data*/ %if %sysevalf( "&Daily_Dm_Load_Date "d ne &CS_ds_DMdates.) %then %do; %put "it is not in the list"; %else %do; %put "it is not in the list"; %end; %mend ; %appnd; i want to look the "Daily_Dm_Load_Date " in "CS_ds_DMdates". can anyone help me on this.

sg_kr · ‎01-23-2020

This is working but the sheet names with spaces and '-' between them facing naming erros

sg_kr · ‎01-22-2020

Hi, thanks for your response. this is not regarding license issue,i want to import different tabs to different datasets using code

sg_kr · ‎01-22-2020

Hi , I have an excel with multiple number of sheets in that, now i need a macro to import each sheet in excel to each dataset with sheet name. i cannot give the sheet name manually every time it needs to be dynamic

sg_kr · ‎07-17-2019

Hi, I have a folder in local machine, where every month set of CSv files will be updated. Now i want to import all of them and create tables as per their file name . can anyone help on this. thanks

sg_kr · ‎07-03-2019

i have already mapped the network drive to the machine, i checked it. VDI:virtual Desktop Infrastructure.

sg_kr · ‎07-03-2019

yes, i have. its working when i run this on VDI machine but not remote machine.

Online Status	Offline
Date Last Visited	‎05-23-2024 03:31 AM

Re: Importing unstructured txt file

Re: Importing unstructured txt file

Re: Importing unstructured txt file

Re: Importing unstructured txt file

Importing unstructured txt file

Re: Reading unstructured text file into sas

Reading unstructured text file into sas

Re: Date lookup in list of dates

Date lookup in list of dates

Re: Importing Excel Tabs to Different Datasets

Re: Reading unstructured text file into sas

Re: Reading unstructured text file into sas

Re: Importing Excel Tabs to Different Datasets

Re: Assigning value of one variable to other variable

Re: Code to get combinations

Re: Importing unstructured txt file

Re: Importing unstructured txt file

Re: Importing unstructured txt file

Re: Importing unstructured txt file

Importing unstructured txt file

Re: Reading unstructured text file into sas

Reading unstructured text file into sas

Re: Date lookup in list of dates

Date lookup in list of dates

Re: Importing Excel Tabs to Different Datasets

Re: Importing Excel Tabs to Different Datasets

Importing Excel Tabs to Different Datasets

import Set of CSV files

Re: unable to export the excel file

Re: unable to export the excel file