About manikanta9500

manikanta9500 · ‎12-16-2021

Hi All, I am New to this forum, but I am hoping can get a reply to my question fairly quickly. Requirement : 1) Import excel file present location into SAS dataset ( file name wave1) Note : Excel is refreshed on daily bases 2) Current SAS dataset is an exact replica of the Excel wave1. So if there are any columns missing in excel which was previously present for some reason , these columns will be missing from the SAS dataset too. However, Spotfire marks it as an invalid dataset since few columns are missing. To overcome this we have placed previous created SAS dataset in backup folder and using below code retain variable structure. After importing into excel file into SAS data set I am using below code data final; set new previous (obs=0); run; Above code work fine sometime and it will throw below error some time Error : Variable has been defined as both character and numeric. Please help me to resolve this error permanently . Thanks in advance .

manikanta9500 · ‎12-02-2021

We have developed a SAS program which import XLSX file which contains 100 variable . This program will execute daily and XLSX file will change the variables and data frequently . Example : Consider we have 10 variable in yesterdays refresh and today we have only 9 variable in excel . But we want all 10 variable in SAS dataset when we refresh today . where 9 variable will have data and missing 1 variable will be part of SAS dataset with blank value . Kindly request you provide your input how we can archive above scenario. Thanks in advance

Online Status	Offline
Date Last Visited	‎12-16-2021 01:46 PM

Error : Variable has been defined as both character and numeric.

Retaining the variable structure

Re: Retaining the variable structure

Error : Variable has been defined as both character and numeric.

Retaining the variable structure